🚀 go-pugleaf

"OLE DB Services=-2" should turn off connection pooling.

> Do you think is it a good and safe solution?
Yes if it works. When server was disconnected ADO can not connect back
itself and should be forced to reconnect.

//------------------------------------------
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)



"Steve Aletto" <steve_alettoNOSPAM@THANKShotmail.com> �������/�������� �
�������� ���������: news:4030c139@newsgroups.borland.com...
> > Try add "OLE DB Services=-2" to your connection string.
>
> Hi Viatcheslav,
>
> unfortunately that doesn't solve the problem. What is it for?
>
> Anyway, I found a work-around for the moment, simply I set again the
> connection string if an exception is thrown and the next time I Open() I
can
> access the DB:
>
> try
> {
>     Q->Open();
> }
> catch (...)
> {
>     Q2->ConnectionString = "";
>     Q2->ConnectionString = TheConnectionString;
> }
> Q->Close();
>
> Do you think is it a good and safe solution? I'm not very sure, but I
don't
> understand the reconnection problem as well (by the way, all the SQL
> statements have the same problem, not only SELECTs as I told before).
>
> Thank you,
>
> Steve.
>
>