I believe your provider must be a valid db driver....make 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 1 Robbins Road Westford, MA U.S.A 01886 Nothing fancy and nothing Microsoft -----Original Message----- From: GRC [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 27, 2001 2:44 PM To: [EMAIL PROTECTED] Subject: making a dsn-LESS connection 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php