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?

Thanks

asked 13 Dec '10, 16:01

Justin%20Willey's gravatar image

Justin Willey
6.6k106136205
accept rate: 21%


Justin,

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

Karim

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

Karim

permanent link

answered 13 Dec '10, 16:55

Karim%20Khamis's gravatar image

Karim Khamis
5.6k53870
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

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:

×124
×62
×46

question asked: 13 Dec '10, 16:01

question was seen: 1,145 times

last updated: 14 Dec '10, 12:17