I believe your provider must be a valid db drivermake sure it exists on
your machine.
you may want to check out www.4guysfromrolla.com they have a great section
on asp dsn/dsn-less connections.
Hope it helps.
Darren S. Ball
Software QA Engineer
Lucent Technologies - InterNetworking Systems
Hi Harry,
Your ADO connection string should look something like this:
Provider=MySqlProv;Data Source=yourdatabasename;Password=yourpassword;User
ID=youruserid;Location=localhost
Easiest way to build it is to createan empty text file on your desktop.
Rename it 'Test.udl'.
Double Click it.
Select