By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,140 Members | 1,706 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,140 IT Pros & Developers. It's quick & easy.

MySQL Provider not registered

P: n/a
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
Nov 15 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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**********@btinternet.com> wrote in message
news:bu**********@hercules.btinternet.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


Nov 15 '05 #2

P: n/a
On Wed, 21 Jan 2004 21:34:23 +0000 (UTC), "Steven Blair"
<st**********@btinternet.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
Nov 15 '05 #3

P: n/a
Here is what I am doing:

string source = "Provider=MySQLProv;" +

"Data Source=mySQLDB;" +

"User Id=myUsername;" +

"Password=myPassword";

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

"Austin Ehlers" <th***********************@hotmail.com> wrote in message
news:jj********************************@4ax.com...
On Wed, 21 Jan 2004 21:34:23 +0000 (UTC), "Steven Blair"
<st**********@btinternet.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

Nov 15 '05 #4

P: n/a
On Thu, 22 Jan 2004 18:04:43 +0000 (UTC), "Steven Blair"
<st**********@btinternet.com> wrote:
Here is what I am doing:

string source = "Provider=MySQLProv;" +

"Data Source=mySQLDB;" +

"User Id=myUsername;" +

"Password=myPassword";

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
Nov 15 '05 #5

P: n/a
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***********************@hotmail.com> wrote in message
news:94********************************@4ax.com...
On Thu, 22 Jan 2004 18:04:43 +0000 (UTC), "Steven Blair"
<st**********@btinternet.com> wrote:
Here is what I am doing:

string source = "Provider=MySQLProv;" +

"Data Source=mySQLDB;" +

"User Id=myUsername;" +

"Password=myPassword";

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

Nov 15 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.