How to configure ODBC link from Mysql to MSSQL

[Project Srl]

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?"

 

------------------------------

MORE INFORMATION:

 

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

 

Filippo