Server system is server2003 64 Chinese, 64, SQL server2008 database environment in the configuration of mysql, already installed mysql ODBCconnect, ODBC has the connection is successful, now want to make a package by SSIS connect mysql, but through ADO.NET connection ODBC ERROR: "ERROR when the initialization provider, cause the failure of the connection test, the ERROR [IM0002], the ODBC driver manager did not find the data source name and do not specify a default driver," baidu found whether server2003 after installing SQL without bringing the Microsoft ole db provider for ODBC driver, need additional installation, but due to the system environment is too long, it's official website to find the version number 11 and minimum support Windows 7 system, only download zone is found in English, can't install,
Could you tell me whether need extra install ODBC driver, finally leave a mailbox 43326341 @qq.com, thank you

CodePudding user response:

Have found a Chinese version of the patch, now through SQL cross links is successful, also can query the mysql table, but through the SSIS package or report the error