proxy tables loose connection

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?

proxy-tables

asked 30 Aug '11, 15:19

APR
16●1●1●2
accept rate: 0%

Did anyone restart the Oracle database?

(30 Aug '11, 16:30) Calvin Allen

flat view

One Answer:

active answers oldest answers newest answers popular answers

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.

permanent link

answered 31 Aug '11, 08:28

Karim Khamis
5.7k●5●38●70
accept rate: 40%

flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

proxy-tables ×70

question asked: 30 Aug '11, 15:19

question was seen: 2,892 times

last updated: 31 Aug '11, 08:28

SAP SQL Anywhere

proxy tables loose connection

Follow this question

Related questions