Question Re: SQL Anywhere 32 ODBC in Technology Q&A

SQL Anywhere 32 ODBC

former_SQLA_member1694903 — Thu, 29 May 2014 16:25:20 GMT

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?

Re: SQL Anywhere 32 ODBC

Former Member — Thu, 29 May 2014 16:36:36 GMT

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).

Re: SQL Anywhere 32 ODBC

former_SQLA_member1694903 — Thu, 29 May 2014 16:37:45 GMT

That's pretty much what I figured. Thanks

Re: SQL Anywhere 32 ODBC

VolkerBarth — Fri, 30 May 2014 10:12:43 GMT

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...)

Re: SQL Anywhere 32 ODBC

Former Member — Fri, 11 Jul 2014 15:28:10 GMT

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.

Re: SQL Anywhere 32 ODBC

Breck_Carter — Fri, 11 Jul 2014 16:04:12 GMT

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.

Re: SQL Anywhere 32 ODBC

VolkerBarth — Sat, 12 Jul 2014 05:43:40 GMT

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...

Re: SQL Anywhere 32 ODBC

Former Member — Sat, 12 Jul 2014 17:22:03 GMT

Plain curiosity

Re: SQL Anywhere 32 ODBC

VolkerBarth — Sun, 13 Jul 2014 06:00:10 GMT

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