cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

proxy tables loose connection

Former Member

on ‎2011 Aug 30 4:19 PM

3,410

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?

Know the answer?

Help others by sharing your knowledge.

Answer

Need more details?

Request clarification before answering.

Show replies
Show replies
Former Member
‎2011 Aug 30 5:30 PM

Did anyone restart the Oracle database?

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
‎2011 Aug 31 9:28 AM
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.

Show replies
Show replies
Ask a Question