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.

v10.0.1 trying to connect to an ODBC remote server (its an Access database) and set up a proxy table using Sybase Central.

Remote server connects fine, list of table appears, but having chosen the table and pressed Next, I get the error message

The set of columns could not be obtained

The connection informaion is simply the ODBC system DSN name.

Can anyone point me in the right direction?


asked 13 Dec '10, 16:01

Justin%20Willey's gravatar image

Justin Willey
accept rate: 20%


I believe the problem may have to do with the fact that Sybase Central fully qualifies the remote location when querying the table metadata. Can you try the following:

  1. drop the remote server
  2. connect using dbisql
  3. recreate the remote server using "CREATE SERVER ...'
  4. reconnect using Sybase Central and continue trying to create the proxy table


--- EDIT ---

Actually, I change my mind. Avoid Sybase Central entirely. Do not follow step 4 above. Instead, continue with DBISQL and create your proxy table(s) using CREATE EXISTING TABLE. If performing all the necessary steps in DBISQL works, then let me know and I'll open a bug case with the Sybase Central folks.


permanent link

answered 13 Dec '10, 16:55

Karim%20Khamis's gravatar image

Karim Khamis
accept rate: 40%

edited 14 Dec '10, 12:17

Thanks Karim, I'll do that and let you know what happens.

(14 Dec '10, 17:14) Justin Willey
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: 13 Dec '10, 16:01

question was seen: 2,648 times

last updated: 14 Dec '10, 12:17