🚀 go-pugleaf

Try add "OLE DB Services=-2" to your connection string.

//------------------------------------------
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:40308545@newsgroups.borland.com...
> Hi all,
>
> I'm developing an application that connects to a SQL server database. This
> application uses a TADOQuery to execute some SQL statements (SELECT,
UPDATE,
> INSERT) periodically, let's say every 3 seconds. The application runs an a
> client PC connected to the server through LAN and under normal conditions
> there aren't problems.
>
> If I turn off the server PC (where the database is located) obviously
either
> ExecSQL() and Open() methods fail and correctly throw an exception. The
> problem arises when I turn on the server PC: the ExecSQL() method (used
for
> UPDATE and INSERT) returns to work, instead Open() (SELECT) still throws
the
> exception "Connection error". At this point the ConnectionString is still
> correct.
>
> Does anyone have any hint to solve the problem?
>
> Thank you,
>
> Steve.
>
>