Re: SQLConnection Dillema

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Cor Ligthert (notmyfirstname_at_planet.nl)
Date: 09/23/04 

Date: Thu, 23 Sep 2004 13:40:05 +0200

Cablito,

Do you think you have with these messages enough for some days as answer on
your question?

http://tinyurl.com/5djng

I selected them to only one person (with the most complete answers about
this subject)

I hope this helps?

Cor

"Cablito" <cablito@dontspam.com>
> The dilema is simple:
>
> Documents tell you to paranoically close your connections as soon as you
> are
> done with them, to release resources, though I fail to see how much impact
> an open connection on a sql server has both for client and server or even
> the network.
>
> Now I have an application that besides all the other tasks, such as
> inserting records and looking up records, has a "real time" counter. Since
> it is a multi-user scenario, this counter has to periodically be updated
> by
> a select count on a table.
>
> So, do I go by the books and, every 5 seconds when I need a new count, I
> open a connection, fetch the count, and then close it again or I just keep
> an open connection for that? IŽd use another connection for the inserting
> process due to threading issues.
>
> the sqlconnection object connects really fast to sql as compared to ADO,
> in
> my own experience, but the delay seems to appear when you move to a
> production environment where there is network traffic, the sql server is
> being hit by monster queries from SAP or Peoplesoft or whatever.
>
> Anyone?
>
>

Relevant Pages

  • Re: Pivot Table Timeout
    ... If the query takes a long time and times-out, it can be adjusted with properties in the SQL connection string. ... 'Open Connection to remote SQL Server ...
    (microsoft.public.office.developer.web.components)
  • Re: Pivot Table Timeout
    ... If the query takes a long time and times-out, it can be adjusted with properties in the SQL connection string. ... 'Open Connection to remote SQL Server ...
    (microsoft.public.office.developer.web.components)
  • Re: Error "SQL Server does not allow remote connections"
    ... The application could not connect to the sql server db. ... network is blocking the connection. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 ... integratedSecurity, SqlConnection owningObject) +737554 ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Connection from remote computer to network SQL Server
    ... There is no firewall on the W2K machine acting as the SQL server. ... I tried making the SQL machine a "trusted" on the router. ... connection works. ... To find the IP address of your computer inside the network, ...
    (microsoft.public.access.adp.sqlserver)
  • ADO.net Orcas Samples Install Problem
    ... An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, ... or am I better off with a full SQL Server install. ...
    (microsoft.public.dotnet.framework.adonet)