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 the 'Connection' tab. Select the MyOLEDB Provider for MySQL Click 'Next' Enter the db name and location. Click Test Connection. If it works, click OK, and open the UDL file with notepad. The third line is your connection string. Good luck, Bruce ----- Original Message ----- From: "GRC" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, November 27, 2001 9:43 PM 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
