I have a problem with proxy-table and user disconnection that happens very
rare. The most of the time I do not have any issue but sometimes I do.
I run a Sybase Anywhere Server 18.104.22.16827 and I use a proxy table on a
remote server (Oracle 10g). I am using the Oracle wire ODBC driver 10
version 5.10.00.124. I use a READ ONLY table from the remote server and my
software run its query (SELECT * FROM ...) without ANY TRANSACTION.
The problem happens when the user disconnect from the DB, sometime it is
unable to do that and the properties stuck in:
If I manually drop the connection the Engine die and I have to restart it.
It seems the Oracle connection remain "pending" and I do not have any tool
to drive it from Sybase.
Has anybody seen that? Any Suggestion? How I can overcome the situation
without dropping the connection (killing the engine)?
Subject: Oracle Remote server don't allow user to disconnect
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-RFC2646: Format=Flowed; Original
Date: 15 Feb 2008 04:23:00 -0800
X-Trace: forums-1-dub 1203078180 10.22.241.152 (15 Feb 2008 04:23:00 -0800)
X-Original-Trace: 15 Feb 2008 04:23:00 -0800, vip152.sybase.com
Xref: forums-1-dub sybase.public.sqlanywhere:63
Article PK: 866517