Mysql and linked servers 2

[junkmail]

Hi!, We just switched to a new server the old one was 32 bit and the new one is 64 bit. The problem I am having is that the linked server I created to access a MYSQL DB now gives me the following error. it worked perfectly fine on the old server.

"The specified DSN contains architecture mismatch between the driver and the application"

The weird thing is that the ODBC connection works fine meaning I get a successful connection.

Anyone help would be much appreciated.

 

[fredericofonseca]

most likely you need to install the 64 bit drivers -

https://dev.mysql.com/downloads/connector/odbc/3.51.html

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886

 

[junkmail]

Thanks for all your help! I got it working!