Hi, I am using SQL Anywhere 9.0.2 and i have several proxy tables from an Oracle 11 database. Sometimes, the proxy tables loose (do not show) their data, like loosing connection, whereas the sybase tables seem ok (show their data) and there is no network issue. The only solution i have found is to stop and start the ASA servise and everything is back. Is there any suggestion why that happens?
asked 30 Aug '11, 15:19
Sounds like an issue with the Oracle ODBC driver. Which Oracle driver are you using? Does the Oracle driver have a connection timeout or something? Note that you should not have to start and stop ASA to get things working again. I would think it is sufficient to simply disconnect and reconnect unless the ODBC driver is in a very strange state.
answered 31 Aug '11, 08:28