Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.


I have a legacy system that I connect to over ODBC via excel and other tools. The 32 Bit ODBC Data Source Administrator lists a System Data Source using the Adaptive Server Anywhere 9.0 Driver. However, when I go to excel/ms query to query data the system dsn using the ASA9.0 driver does not appear. Other system dsn's do appear. Saved queries continue to function, I can't author new queries or edit existing.


asked 16 Feb '18, 15:12

jimm2371's gravatar image

accept rate: 0%

What OS version are you using: 32bit Windows or 64bit Windows?

I suspect that you applications - "excel and other tools" - are 64bit and therefore the 32bit DSNs cannot be used (since it uses a 32bit driver). If you are using 64bit applications, then you will need to either need to switch to using 32bit applications or use a 64bit SQL Anywhere driver.


permanent link

answered 16 Feb '18, 15:21

Mark%20Culp's gravatar image

Mark Culp
accept rate: 41%

I recently encountered this error. The only other solution I found was an ODBC Bridge Tool. This is the one I use -

(05 Mar '18, 10:19) Jongee
Your answer
toggle preview

Follow this question

By Email:

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 16 Feb '18, 15:12

question was seen: 2,801 times

last updated: 05 Mar '18, 10:19