SQL Demo with MySQL 5.1 Driver

Share icon

Mon, 09/30/2013 - 04:18 am

Hi,
I have ODBC Driver for MySQL 5.1 installed on Windows7, and I'm trying to run the SQL-demo.pxp.
I've created the connection as described, and on running the demo I get the following error:

[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
SQL XOP: SQLDriverConnect failed.

Does anyone have a solution for this, or know what is wrong with the connection?
Cheers,
Jason.
Make sure you have matching "bitness."
It sounds like you are attempting to use a 64 bit driver.
Try installing the 32 bit version instead.

I am using a 32 bit version of the MySQL ODBC 5.2 ANSI driver on a 64 bit Win7 machine, running 32 bit IGOR and everything is working fine.

September 30, 2013 at 09:26 am - Permalink