Dynamic AI Support Forum

Hello,

I am trying to create a database connection between Dynamic AI and my 64-bit mySQL server on my 64-bit Windows 7 machine. When I press the 'Test Connection' button, I get the following error:

[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

If I understand correctly, this is due to the architecture inconsistency between the 32-bit Dynamic AI and the 64-bit mySQL server. Is there available a 64-bit installation for Dynamic AI? Any workaround?

Thank you in advance.

Hi,

The way to resolve this is to install a 32 bit MySQL odbc driver (you can find it here http://www.mysql.com/downloads/connecto ... #downloads )

The 32 bit driver can co-exist with the 64 bit driver and the mysql server still operates at 64 bit - the only catch is that you will have a separate 32bit odbc administrator - it looks and works exactly like the 64 bit counterpart, but stores DSNs in a different part of the registry. You need to configure your DSNs in the 32bit version of the administrator for Dynamic AI to see them. If the client does not install a shortcut, you can access it from c:\windows\syswow64\odbcad32.exe

Ask again if you have any problems

Best regards

Bo Andersen

Thank you Bo, that worked great!