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? Thanks asked 13 Dec '10, 16:01 Justin Willey |
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:
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 answered 13 Dec '10, 16:55 Karim Khamis |