making a dsn-LESS connection

[GRC <guestroom@xxxxxxxxxxxxxxxx>]

I wish to have my asp pages (on an NT 4.0 iis 4.0 machine) connect to a 
mysql database.
I want to have the DSN-LESS type of a connection.

This DSN version works:
ConnectionString = "DSN=myDSNname;User Id=myuserid;Password=aword;"	

However this DSN-less version does not:
ConnectionString = "Provider=MySQL;datasource=localhost;Initial 
Catalog=acatalog;User Id=myuserid;Password=aword;"	

The error number and description is this:
3706 : ADO could not find the specified provider

Is this error saying that I dont have the NAME right? or is it that I don't 
actually have the provider (the ole db or whatever dll etc) on my machine ?

More to the point, does anyone know what the correct connection string 
value should be?

thanks
Harry


---------------------------------------------------------------------
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread92391@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php