Re: TIMEOUT ERROR & Connection String Property

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Abhinav Gargye (agargye_at_hotmail.com)
Date: 11/11/04 

Date: Thu, 11 Nov 2004 08:35:57 -0600

Thanks for the reply Erland.

We have also been experiencing the following error periodically.
[DBNETLIB][ConnectionRead (recv()).]General network error.

You should know that the Webserver (IIS 5) & the DB are behind a firewall.
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: )

Can anyone point out what may be causing this. Not sure if its related to
the Timeouts or vice-versa. Any input on this will be a great help.

thanks again

Abhinav

"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns959E261DEC9AYazorman@127.0.0.1...
> Abhinav Gargye (agargye@hotmail.com) writes:
> > We are experiencing Timeout Errors with oledb (MDAC 2.8)
> >
> > Is there anyway of setting the connection timeout property from the
> > connection string?
> >
> > I have tried out various combinations of Connection Timeout=60000;
> > Connection Timeout=60 etc. but there is no impact.
>
> I believe that only Timeout is what you want. The rule is that the
> keyword in the connection string is the same as the name for the
> property, with DBPROP_INIT_ stripped.
>
> > Properties="ConnectionTimeout=60000;CommandTimeout=60000;UID=P_USER";
>
> On the other hand, I don't think you can set the command timeout in
> the connection string, since this is a session property.
>
>
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

Relevant Pages

  • Re: Unable to Connect To Sql Server 2000 using .NET 2005 EXPRESS
    ... Check www.connectionstrings.com and see if your connection string is valid. ... my sql server here on my laptop on my company's network. ... The timeout period elapsed prior to completion of the ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADO.NET timeout
    ... the connection string, which is particularly handy, if you read in the ... Simple specify the Connection ... > Did you specify timeout for your command or not? ... > CommandTimeout property of the command then it should help you. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cant connect to SQL Server 2008
    ... The connection string from Server Explorer is the same as I'm using in ... I can connect to SQL Server 2008 using sqlcmd from the same ... The error message looks more like a command timeout to me, ...
    (microsoft.public.sqlserver.connect)
  • Re: starting long running stored procedures
    ... Does your connection string include a value for Connect Timeout? ... > I have a windows service that starts a stored procedure that could take many ... When I run it through query analyzer it runs all the way ...
    (microsoft.public.dotnet.framework)
  • Re: OWC spreadsheet control timeout
    ... the connection string should take a timeout keyword that should be ... the 'theSelection' is a string like: ...
    (microsoft.public.office.developer.web.components)