"the set of columns could not be obtained"

[justin_willey]

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

[Former Member]

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

[justin_willey]

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