Question Re: proxy tables loose connection in Technology Q&A

proxy tables loose connection

Former Member — Tue, 30 Aug 2011 15:19:20 GMT

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?

Re: proxy tables loose connection

Former Member — Tue, 30 Aug 2011 16:30:45 GMT

Did anyone restart the Oracle database?

Re: proxy tables loose connection

Former Member — Wed, 31 Aug 2011 08:28:25 GMT

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.