sybase and odbc on a 64 bit - not shown in odbcmanager

[Former Member]

hi there,

i have a win 7 32BIT - it works fine, i can make an odbc connection with the sybasedriver. but on win7 64BIT i have the problem that i dont see the sybase driver for 32bit. when i use C:WindowsSystem32odbcad32.exe, i see the driver, but the connection dont work. when i use C:WindowsSysWOW64odbcad32.exe, i cant see the sybase driver.

can someone help me? its a fresh installed win 7 64bit.

thanks a lot! MS

[VolkerBarth]

The following question may be of further help (aka details):

Please explain the ODBC Administrator situation in 64-bit Windows 7.

[jeff_albion]

when i use C:\\Windows\\System32\\odbcad32.exe, i see the driver

This is the 64-bit ODBC Administrator. If you can see the driver only here, you only have the 64-bit ODBC driver installed. Try installing/registering the SQL Anywhere 32-bit ODBC driver, and try again with C:\\Windows\\SysWOW64\\odbcad32.exe:

regsvr32 "%SQLANY12%\\bin32\\dbodbc12.dll"

[Former Member]

thanks for your answer! how can i install it? I have used the same cd and installation with the 32bit system. i only can select the Db and have no x86 or x64 choise.

thanks!

[Former Member]

thank you!

it works, i can install the 32bit too, i dont have see it...

[jeff_albion]

i only can select the Db and have no x86 or x64 choise.

Are you installing the full SQL Anywhere package, or are you installing a third-party product that installs SQL Anywhere in the background as part of its own install? If you haven't purchased SQL Anywhere directly, you should speak to your third-party software vendor directly to see if they can supply you with a 32-bit driver (and to see if they allow third-party access to the database).

If you have purchased the full SQL Anywhere product, you should need to just select the "(32-Bit) Database Client Components -> [X] ODBC Driver" during the SQL Anywhere product install. The file will appear exactly as I mentioned it in my post: "%SQLANY12%\\bin32\\dbodbc12.dll" (e.g. "C:\\Program Files\\SQL Anywhere 12\\bin32\\dbodbc12.dll")

[Former Member]

I had to register the ODBC driver manually in a command prompt that had been run as Administrator. The command was:

odbcconf.exe INSTALLDRIVER "SQL Anywhere 11|Driver=%SQLANY11%bin32dbodbc11.dll|"