Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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?

asked 29 May '14, 16:25

BudDurland's gravatar image

BudDurland
3169920
accept rate: 0%


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

permanent link

answered 29 May '14, 16:36

Mikel%20Rychliski's gravatar image

Mikel Rychliski
2.1k1641
accept rate: 32%

That's pretty much what I figured. Thanks

(29 May '14, 16:37) BudDurland

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

(30 May '14, 10:12) Volker Barth

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.

permanent link

answered 11 Jul '14, 15:28

mysorian's gravatar image

mysorian
1189913
accept rate: 0%

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.

(11 Jul '14, 16:04) Breck Carter

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

(12 Jul '14, 05:43) Volker Barth

Plain curiosity

(12 Jul '14, 17:22) mysorian
Replies hidden

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

(13 Jul '14, 06:00) Volker Barth
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:

×36
×21

question asked: 29 May '14, 16:25

question was seen: 4,423 times

last updated: 13 Jul '14, 06:00