Jump to content

How to configure ODBC link from Mysql to MSSQL

Project Srl

Recommended Posts

Hi all,


how can i correctly configure an ODBC link from prestashop MySQL to MSSQL 2005?


I need this connection to automatically import/export data from and to prestashop db and an SQL db.


I have already installed the ODBC driver version 5.1 and confgiured the "MySQL connector ODBC data source" with the DSN connection but when i try to configure the SQL Management studio - linked server i received the error:



TITLE: Microsoft SQL Server Management Studio

"The linked server has been created but failed a connection test. Keep the linked server?"
Except during the execution of a statement or a batch Transact-SQL. (Microsoft.SqlServer.ConnectionInfo)
Can not initialize the data source object provider OLE DB "MSDASQL" for linked server "MYSQL ODBC 5.1 DRIVER".
The provider OLE DB "MSDASQL" for linked server "MYSQL ODBC 5.1 DRIVER" returned message "[Microsoft][Driver Manager ODBC] Architecture mismatch between the driver and the application specified in the DSN". (Microsoft SQL Server, errore: 7303)
Do you have any suggestion / ideas?
Thank you in advance
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...