Hi,

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.

Thanks

asked 16 Feb, 15:12

jimm2371's gravatar image

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

HTH

permanent link

answered 16 Feb, 15:21

Mark%20Culp's gravatar image

Mark Culp
23.7k9134279
accept rate: 40%

I recently encountered this error. The only other solution I found was an ODBC Bridge Tool. This is the one I use - https://www.easysoft.com/products/data_access/odbc_odbc_bridge/index.html#section=tab-1

(05 Mar, 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

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:

×16

question asked: 16 Feb, 15:12

question was seen: 521 times

last updated: 05 Mar, 10:19