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 connection informaion is simply the ODBC system DSN name.
Can anyone point me in the right direction?
asked 13 Dec '10, 16:01
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:
--- 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.