02-18-2013 07:24 AM
I'm trying to connect our TEO (2.2) instance to a MySQL instance, but unable to do so successfully.
On the TEO server, I've loaded the MySQL provider as well as the ODBC driver.
I then try to define the connection details in the new target:
Hostname: <hostname of the server hosting MySQL>
Default user: <runtime user for the read-only account to the database>
Connection String: Provider=MySQLProv;Data Source=<database name>
Clicking "OK" throws the following error: "The 'MySQLProv' provider is not registered on the local machine."
Based on the error, it feels to me like the TEO server doesn't recognize that provider, but I'd like some help on getting it to the point where it does.
Could you please provide me with the steps needed to get our TEO instance to connect to the DB?
Thanks,
Mark
Solution:
1) Install the provider from Cherry City Software : http://cherrycitysoftware.com/CCS/Providers/ProvMySQL.aspx
2) Configure the connection string as follows: Provider=OleMySql.MySqlSource.1;Data Source=<FQDN of DB host>;Initial Catalog=<DB name>
Thank you very much C Roberts!
Solved! Go to Solution.
02-18-2013 08:11 AM
The connection string shows "MySQLProv", is that what you actually used?
Looking at the sample C# code(and VB.net) I see this as the provider:
OleMySql.MySqlSource.1
Did you try that?
Also it looks like
Data Source=
Initial Catalog=
If you cannot get by this, would probably be best to open a TAC case for review.
02-18-2013 08:31 AM
Trying "Provider=MySQLProv" with no other arguments throws the "The 'MySQLProvider' is not registered on the local machine.
Trying "Provider=OleMySql.MySqlSource.1;Data Source=
Thank you very much for helping me sort out the connection string.
Mark
02-18-2013 07:38 AM
Did you download 32-bit or 64-bit provider?
If you downloaded 32-bit adapter the problem is that by default the Generic DB Adapter is running as a 64-bit process and won't be able to see/load the 32-bit providers/drivers.
Svetlana
02-18-2013 07:40 AM
I am using the 64-bit provider on a 64-bit instance of Windows 2008 R2.
Mark
02-18-2013 07:56 AM
Which provider are you using? The only one I ever heard of getting to work (with mySQL) is Cherrysoft and that was spotty a while ago. You installed/registered the provider? (the error seems to say otherwise)
02-18-2013 07:58 AM
I am using the provider from Cherry City Software: http://cherrycitysoftware.com/CCS/Providers/ProvMySQL.aspx
Their intallation indicated that it succeeded, and the activation that is required also succeeded.
Mark
02-18-2013 08:11 AM
The connection string shows "MySQLProv", is that what you actually used?
Looking at the sample C# code(and VB.net) I see this as the provider:
OleMySql.MySqlSource.1
Did you try that?
Also it looks like
Data Source=
Initial Catalog=
If you cannot get by this, would probably be best to open a TAC case for review.
02-18-2013 08:31 AM
Trying "Provider=MySQLProv" with no other arguments throws the "The 'MySQLProvider' is not registered on the local machine.
Trying "Provider=OleMySql.MySqlSource.1;Data Source=
Thank you very much for helping me sort out the connection string.
Mark
02-18-2013 08:33 AM
neat! Let us know how good/bad it works. I have not seen many customers use mySQL but I know it's out there in bunches in the real world
-shaun
04-23-2014 10:33 AM
Hi,
But this provider is paying, is there a free alternative as MyOLEDB doesn't seem to be maintained anymore?
Cheers,
04-23-2014 01:21 PM
Unfortunately, you will have to search for one. We have only ever used the CherryCity provider.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide