SQLSTATE = IM003 Cannot load driver due to system error 193.

[Former Member]

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

[Breck_Carter]

See this forum discussion...

http://sqlanywhere-forum.sap.com/questions/890/windows-7-64-bit-1001-4075-system-dsn-setup-problems

[t1950]

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)

[t1950]

i get the same message using odbcad32.exe (we're PB 12.5, have not tested my app with ASA 12)
BTW ASA 12 "installs" connections for 32 bit, but you can't look at them. you get the same message.

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.

[reimer_pods]

Note that sometimes ist rather tricky to use the corrent bitness of the ODBC administration. There's
%SystemRoot%\\System32\\odbcad32.exe
for 64 bit and
%SystemRoot%\\Syswow64\\odbcad32.exe
for 32 bit data sources.
That can be quite irritating, MS did a really good job to keep your brain busy 😉 And AFAIK the only way to tell which version you're running, is by looking in the task manager's process list for '*32' after odbcad32.exe.

[Former Member]

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?

[Former Member]

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?

[VolkerBarth]

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.