SQL Anywhere 32 ODBC

[#1]

The reseller for the ERP application we use seems ot think that SQL Anywhere 16 does not ship with 32-bit ODBC client drivers. This seems a bit far-fetched to me. Can someone please confirm?

[Former Member · Accepted solution]

SQL Anywhere 16 installs the 32-bit client (including ODBC) by default. The 32-bit server is an optional install. You'll have to use the 32-bit ODBC Administrator to create data sources (C:\\Windows\\Syswow64\\odbcad32.exe).

[former_SQLA_member1694903 · Accepted solution]

That's pretty much what I figured. Thanks

[VolkerBarth · Accepted solution]

Just to add: Mikel's answer is dedicated to 64-bit Windows. For 32-bit Windows, the 32-bit server and client components will be installed by default, as in previous versions. (That may be absolutely obvious for most folks but who knows...)

[Former Member]

Start ODBC Data Source Adminsitrator from Start | Search by typing in ODBC 32 You will find the SQL Anywhere 16 driver 16.00.00.1324

There is the 'demo' System DSN

Start ODBC Source Administrator 64 from Start | Search by typing in ODBC 64 You will find the SQL Anywhere 16 driver 16.00.00.1324

There is a System DSN SQL Anywhere 16 Demo

What I wonder is that the driver has the same name and version.

[Breck_Carter]

16.00.00.1324 is the SQL Anywhere 16 version and build number for the copy you have installed. All modules in that copy will share that same build number.

[VolkerBarth]

What I wonder is that the driver has the same name and version.

Just to understand: Do you wonder why the 32-bit and the 64-bit ODBC driver for SQL Anywhere 16 have the same name and version? Or what exactly does irritate you?

BTW: 16.0.0.1324 is an old v16 build version - I would generally recommend to use a current EBF like 16.0.0.1915...

[Former Member]

Plain curiosity

[VolkerBarth]

Sorry, I still do not understand what it is that makes you wonder.