MySQL Forums
Forum List  »  Connector/NET and C#, Mono, .Net

Advanced Search
New Topic

Re: Hourly data sync from local MSSQL 2005 to AWS mySQL
Posted by: Fernando Gonzalez
Date: December 11, 2012 11:52AM

ADO/OLE DB is not natively supported for MySql, you can connect thru ODBC using Connector/ODBC or thru ADO using OLEDB provider for ODBC and then again Connector/ODBC

However, If you are getting issues with ADO, you can try the ADO.NET driver for MySql, Connector/NET.

Here's is a small tutorial on it
http://blogs.msdn.com/b/mattm/archive/2008/03/03/connecting-to-mysql-from-ssis.aspx


download the latest Connector/NET here, http://dev.mysql.com/downloads/connector/net/

Navigate: Previous Message• Next Message
Options: Reply• Quote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.