Re: making a dsn-LESS connection

[Bruce and Irene]

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

RE: making a dsn-LESS connection

[Darren S Ball]

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
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