ADO Connection Time Out / Dropped

Thread View: borland.public.cppbuilder.database.ado

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Heinz Ketchup Thu, 21 Jul 2005 15:04

#707

Author: Heinz Ketchup
Date: Thu, 21 Jul 2005 15:04

17 lines
1749 bytes

Hi Everyone,

This is I think, a relatively simple question, although there are a few clear cut answers on the web. I'm establishing a connection through TADOConnection->Open() Method.

Now I can perform Transactions, but after IDLING (15 minutes+, Reviewing the Information, going for Coffee, etc...) for awhile; the connection is dropped and an Exception is thrown when another Query is made after the IDLING period.

If the property Keep Connection = true, why is the connection dropping? Is this a bug in ADO? 

I connect to 2 DB, Oracle 8.x and Sybase 7.x
Is this possibly a DB issue, where internally the thread is terminated?

I'm just looking to solve my problem.
I'll try to catch the exception and do an Open Statement again to see if that will be a temporary work around.

Thanks Everyone,
Heinz

Re: ADO Connection Time Out / Dropped

#709

Author: Viatcheslav V. Vassiliev
Date: Thu, 21 Jul 2005 20:00

41 lines
2494 bytes

Server can drop connection if it is idle quite longtime. This can not be 
controlled from program.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 + 
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Heinz Ketchup" <heinz_like_the_ketchup@h0tmail.n0spam.c0m.n0spam> 
�������/�������� � �������� ���������: 
news:42dfb971$1@newsgroups.borland.com...
>
> Hi Everyone,
>
> This is I think, a relatively simple question, although there are a few 
> clear cut answers on the web. I'm establishing a connection through 
> TADOConnection->Open() Method.
>
> Now I can perform Transactions, but after IDLING (15 minutes+, Reviewing 
> the Information, going for Coffee, etc...) for awhile; the connection is 
> dropped and an Exception is thrown when another Query is made after the 
> IDLING period.
>
> If the property Keep Connection = true, why is the connection dropping? Is 
> this a bug in ADO?
>
> I connect to 2 DB, Oracle 8.x and Sybase 7.x
> Is this possibly a DB issue, where internally the thread is terminated?
>
> I'm just looking to solve my problem.
> I'll try to catch the exception and do an Open Statement again to see if 
> that will be a temporary work around.
>
> Thanks Everyone,
> Heinz
>
>
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads