How do I correct this error? When running the sample app in PowerBuilder 12.5, I get the error message: SQLSTATE = IM003 Cannot load driver due to system error 193. (SQL Anywhere 12 C:\Program Files\SQL Anywhere 12\Bin64\dbodbc12.dll). I use windows 7 64 bits |
Try the 32 bit ODBC 32 bit driver. PB is a 32 bit app and needs the 32 bit driver. c:\windows\sysWOW64\odbcad32.exe you may have to delete the 64 bit odbc connection first (using Control Panel) |
See this forum discussion... http://sqlanywhere-forum.sap.com/questions/890/windows-7-64-bit-1001-4075-system-dsn-setup-problems |
Thanks, one more question, do I have to uninstall SQL Anywhere 12 64 bit and install sql Anywhere 12 32 bit?, because I can't delete 64 bit odbc connection (c:windowssysWOW64odbcad32.exe or c:windowssystem32odbcad32.exe) and I can't create 32 bits connection either. I have little knowledge, Could you tell me how to do it? If you do not want to use the installed SQL Anywhere 64-bit components and just want to use the 32-bit components, then I think it's easiest to uninstall SQL Anywhere 12 and just install the 32-bit components. If you like to have both bitnesses installed, it should work to re-run the setup (say, from the "Software" control panel topic), and use "Add components" (or whatever this is worded exactly) to add the 32-bit components. Not sure about the "not being able to delete ODBC DSNs" - that surely should work when SQL Anywhere is installed correctly.
(03 Oct '12, 15:38)
Volker Barth
|
Thanks, one more question, do I have to uninstall SQL Anywhere 12 64 bit and install sql Anywhere 12 32 bit?, because I can't delete 64 bit odbc connection (c:windowssysWOW64odbcad32.exe or c:windowssystem32odbcad32.exe) and I can't create 32 bits connection either. I have little knowledge, Could you tell me how to do it? |
i get the same message using odbcad32.exe (we're PB 12.5, have not tested my app with ASA 12) my app is still using SQL A 11. we had to create a 32 bit install for our clients. i'm not sure how you do it, but try creating a 32 bit client install from SQL Anywhere 12. Install the 32 bit client then use odbcad32.exe i think you should be good to go. 1
Note that sometimes ist rather tricky to use the corrent bitness of the ODBC administration. There's
(04 Oct '12, 04:15)
Reimer Pods
|