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

asked 01 Oct '12, 23:54

cmunpal's gravatar image

cmunpal
31113
accept rate: 0%

edited 02 Oct '12, 11:32

Breck%20Carter's gravatar image

Breck Carter
27.0k444614889


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)

permanent link

answered 02 Oct '12, 10:26

Tom%20Mangano's gravatar image

Tom Mangano
632212636
accept rate: 6%

edited 02 Oct '12, 11:32

Breck%20Carter's gravatar image

Breck Carter
27.0k444614889

permanent link

answered 02 Oct '12, 11:37

Breck%20Carter's gravatar image

Breck Carter
27.0k444614889
accept rate: 21%

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?

permanent link

answered 03 Oct '12, 12:52

cmunpal's gravatar image

cmunpal
31113
accept rate: 0%

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?

permanent link

answered 03 Oct '12, 12:58

cmunpal's gravatar image

cmunpal
31113
accept rate: 0%

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.

permanent link

answered 03 Oct '12, 13:03

Tom%20Mangano's gravatar image

Tom Mangano
632212636
accept rate: 6%

edited 03 Oct '12, 13:11

1

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.

(04 Oct '12, 04:15) Reimer Pods
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×40

question asked: 01 Oct '12, 23:54

question was seen: 10,803 times

last updated: 04 Oct '12, 04:16