Power Designer

[Former Member]

Hello, I have installed Power Designer evaluation version and SQL Anywhere. In order to setup the repository, I need to create a ODBC connection for SQL Anywhere. Now the problem that I face is that PD is 32 bit and SQL anywhere is 64 bit. So every time I try to connect using this odbc, I am getting IS014 error (that is because of different ODBC drivers in this case). I tried creating a 32 bit odbc driver from windows, but SQL anywhere is not showing up in User/System DSN. Could anyone please help me here?

Thanks

[MCMartin]

To access the 32 bit ODBC settings you have to use the 32-bit version of the odbc administration, in Win7 just search for odbc and you should see it with the (32-bit) behind it, alternatively here is the full path: C:\\Windows\\SysWOW64\\odbcad32.exe

[chris_keating]

Please note that the 32 bit and 64 bit administrator are named the same so you need to ensure that you run it using the full path.

And if you have not done so, you may need to install the 32 bit SQL Anywhere ODBC driver