MySQL OleDB provider name error

luc72 said 1 year, 8 months ago:

Hi,
I’m trying to connect via oledb to mysql, but I’m getting this error:

The ‘MySQLProv’ provider is not registered on the local machine

This is the connection string:
Provider=MySQLProv; Data Source=server; Initial Catalog=dbname; User ID=user; Password=pwd;

Of course in the code I use the real data source / catalog / user / pwd parameters

Which is correct provider name for oledb? Can anyone help me?
Thanks!!

Gianluca

timb said 1 year, 8 months ago:

@luc72

You may want to try ‘MySQL Provider’ as the provider in your connection string.

Tim B

luc72 said 1 year, 8 months ago:

No, same error!
The ‘MySQL Provider’ provider is not registered on the local machine.

timb said 1 year, 8 months ago:

@luc72

I reviewed this with our hosting support team and was advised that in order to determine the cause of your error we will need you to provide account specific information. I’ll have our support team reach out to you directly to obtain this information.

Tim B

luc72 said 1 year, 8 months ago:

Hi Tim,
currently I’ve resolved using an ODBC connection instead of OleDB.
Everything is working well!

Thanks for the support!

timb said 1 year, 8 months ago:

@luc72

That’s great to hear! Thanks for posting on the Community.

Tim B

rand42 said 1 year, 7 months ago:

Hi, I’m having the same problem but I need to use OleDB as the Web application is already written. Is there any chance of getting a solution to this issue.

Cheers

timb said 1 year, 6 months ago:

@rand42

The issue may be with the connection from your account and this is something that our Support Team must verify with your account specific information.

Tim B

gil12345 said 8 months, 3 weeks ago:

Problem:
I’m trying to connect to MySQL using OLEDB but I’m getting an error.
“The ‘MySqlProv’ provider is not registered on the local machine”
This happens any time my site tries to access the database

A while ago I created a website in visual web developer (written in C#, and HTML4 with a Microsoft Access 2007 Database) … Up till recently I was hosting it at somee.com. (http://wom.somee.com is the website fully functional).

I wanted a faster and better service so I turned to GoDaddy. When I realized that the service that I purchased was not compatible with Access “.accdb” database I decided to switch the Database to a MySQL database, my site retrieved the Data from the database via OleDB methods. So I created a connection string for my app that ran the MySQL with OLEDB methods.

I created the connection string exactly as it says in the godaddy configuration page .. and I replicated the .accdb database to a mySQL database. Then when I try to access the database from the website (signing in) .. my website returns a error that the “MySQLprov” provider isn’t registered on the local machine … local machine is you guys … anyway for some reason this worked perfectly on somee.com but your service is faster and so I really need you guys to help me fix the error.

Please help me.
I need to fix this ASAP ..

Thank you,
Gil

timb said 8 months, 3 weeks ago:

@gil12345

The nature of this inquiry is account specific and I will not be able to properly assist you through this forum. Please contact our Support Team with your domain, support PIN, and reference this thread for proper handling.

Tim B

luc72 said 8 months, 3 weeks ago:

@gil12345

I had the same problem. Try using ODBC:

Dim t_DBconn As New System.Data.Odbc.OdbcConnection
Dim t_DBCommand As New System.Data.Odbc.OdbcCommand
Dim t_DBData As System.Data.Odbc.OdbcDataReader

t_DBconn = New System.Data.Odbc.OdbcConnection(“DRIVER={MySQL ODBC 3.51 Driver}; SERVER=your-dbserver-url; PORT=3306; DATABASE=yourdb; USER=aaa; PASSWORD=xxx; OPTION=0;”)

t_DBCommand = New System.Data.Odbc.OdbcCommand(“SELECT * FROM yourtable”, t_DBconn)
t_DBData = t_DBCommand.ExecuteReader

….

rand42 said 8 months, 3 weeks ago:

Hi, I had a similar issue with this a while ago, I can’t remember exactly what the issue was but here are the lines of code I now use for connecting to our SQL Server db.

dim con
set con=server.CreateObject(“ADODB.connection”)
con.open “Driver={SQL Server}; Server=xxxxxxxx.db.xxxxxxx.hostedresource.com; Database=xxxxxxx; Uid=xxxxxx; Pwd=xxxxxx;”

The x’s are obviously replaced with our site specific values.

Hope this is of some use.

Cheers
Paul