cancel
Showing results for 
Search instead for 
Did you mean: 

proxy tables loose connection

Former Member
3,412

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?

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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.