advantage of sprocs

From: "Loane Sharp" <look_sharp_not@xxxxxxxxxxx>
Date: Wed, 2 Nov 2005 04:38:22 +0200

Hi there
I'm running some pretty large queries from Excel VBA to a SQL Server
database using the ADO 2.8 library. I frequently get timeouts, and I've put
in an error-handling procedure depending on the connection state etc., but I
was wondering whether anyone has experience with stored procedures -
particularly whether they can solve the timeout problem. Or am I on the
wrong track?
Best regards
Loane

.

Prev by Date: Re: ADO and DBF on Windows Server 2003
Next by Date: Disconnected Recordset function in remote MDE file
Previous by thread: ADO and DBF on Windows Server 2003
Next by thread: Disconnected Recordset function in remote MDE file
Index(es):
- Date
- Thread

Relevant Pages

Connection timeout
... I get a connection timeouts when I am connected to the database via ... TOAD and also using Putty and SQLPlus (the operating system on the ... Before I was connected to the database undefinitely. ...
(comp.databases.oracle.server)
Re: Set an SQLCommand timeout default application wide?
... As the database grows, we are seeing SQLCommand timeouts. ...
(microsoft.public.dotnet.framework.adonet)