MySQL Provider not registered

[Steven Blair]

Hi,

Trying to make a connection and getting the following error:

"The 'MySQLProv' provider is not registered on the local machine."

MySQl is installed and working, I also went to ODBC settings and created a
new System Data Source for MySQl. (MySQL ODBC 3.51 Driver)

Is it my responsibilty to set the provider name, or is this held somewhere
on the system ?
--
Steven
www.stevenblair.com

[Dmitriy Lapshin [C# / .NET MVP]]

Hi,

I am not a MySQL expert, but you might be using OLEDB provider for MySQL,
not an ODBC one. If this is the case, ensure the OLEDB provider for MySQL is
installed properly.
If you could post your connection string (without username and password, of
course) and code that establishes the connection, it would be easier to
pinpoint the possible reason of the error.

--
Dmitriy Lapshin [C# / .NET MVP]
X-Unity Test Studio
http://x-unity.miik.com.ua/teststudio.aspx
Bring the power of unit testing to VS .NET IDE

"Steven Blair" <st**********@b tinternet.com> wrote in message
news:bu******** **@hercules.bti nternet.com...

Hi,

Trying to make a connection and getting the following error:

"The 'MySQLProv' provider is not registered on the local machine."

MySQl is installed and working, I also went to ODBC settings and created a
new System Data Source for MySQl. (MySQL ODBC 3.51 Driver)

Is it my responsibilty to set the provider name, or is this held somewhere
on the system ?
--
Steven
www.stevenblair.com

[Austin Ehlers]

On Wed, 21 Jan 2004 21:34:23 +0000 (UTC), "Steven Blair"
<st**********@b tinternet.com> wrote:

Hi,

Trying to make a connection and getting the following error:

"The 'MySQLProv' provider is not registered on the local machine."

MySQl is installed and working, I also went to ODBC settings and created a
new System Data Source for MySQl. (MySQL ODBC 3.51 Driver)

Is it my responsibilty to set the provider name, or is this held somewhere
on the system ?

For your connection string, just use the dsn name for it. ie:
OdbcConnection myConn=new OdbcConnection( "DSN=myDSNname" );

Austin

[Steven Blair]

Here is what I am doing:

string source = "Provider=MySQL Prov;" +

"Data Source=mySQLDB; " +

"User Id=myUsername;" +

"Password=myPas sword";

conn.Open();
--
Steven
www.stevenblair.com

"Austin Ehlers" <th************ ***********@hot mail.com> wrote in message
news:jj******** *************** *********@4ax.c om...

On Wed, 21 Jan 2004 21:34:23 +0000 (UTC), "Steven Blair"
<st**********@b tinternet.com> wrote:

Hi,

Trying to make a connection and getting the following error:

"The 'MySQLProv' provider is not registered on the local machine."

MySQl is installed and working, I also went to ODBC settings and created anew System Data Source for MySQl. (MySQL ODBC 3.51 Driver)

Is it my responsibilty to set the provider name, or is this held somewhereon the system ?

For your connection string, just use the dsn name for it. ie:
OdbcConnection myConn=new OdbcConnection( "DSN=myDSNname" );

Austin

[Austin Ehlers]

On Thu, 22 Jan 2004 18:04:43 +0000 (UTC), "Steven Blair"
<st**********@b tinternet.com> wrote:

Here is what I am doing:

string source = "Provider=MySQL Prov;" +

"Data Source=mySQLDB; " +

"User Id=myUsername;" +

"Password=myPa ssword";

conn.Open();
No need for that. Just set up an Odbc User DataSource. Control Panel Administrative Tools > Data Sources. Click Add. Select MySQL ODBC

3.51 Driver and click Finish. For the Data Source Name, pick
something that describes the actual database (say "MyFirstDB" ). Be
sure to click "Test Data Source" to make sure all of your Parameters
are correct. Then, in your code, all you need is just:

OdbcConnection myConn=new OdbcConnection( "DSN=MyFirstDB" );
myConn.Open();

Austin

[Steven Blair]

Yes working now using OdbcConnection object.

This originally didnt work, but done a little investigation and realised I
need to install ODBC.net.
So, downloaded, instalkled, and added a reference and Open works fine :)

Thanx for the help, much appreciated.

--
Steven
www.stevenblair.com
"Austin Ehlers" <th************ ***********@hot mail.com> wrote in message
news:94******** *************** *********@4ax.c om...

On Thu, 22 Jan 2004 18:04:43 +0000 (UTC), "Steven Blair"
<st**********@b tinternet.com> wrote:

Here is what I am doing:

string source = "Provider=MySQL Prov;" +

"Data Source=mySQLDB; " +

"User Id=myUsername;" +

"Password=myPa ssword";

conn.Open();

No need for that. Just set up an Odbc User DataSource. Control Panel

Administrative Tools > Data Sources. Click Add. Select MySQL ODBC

3.51 Driver and click Finish. For the Data Source Name, pick
something that describes the actual database (say "MyFirstDB" ). Be
sure to click "Test Data Source" to make sure all of your Parameters
are correct. Then, in your code, all you need is just:

OdbcConnection myConn=new OdbcConnection( "DSN=MyFirstDB" );
myConn.Open();

Austin