Re: ADO and TCPIP Connections

No, I have not disabled connection pooling.
That was one of the things I had a look at as well.

Could the Server Side cursor on the query be doing something to the
connection pooling maybe???
Just a thought.

Thanks.


"Guillem" <guillemvicens-nospam@xxxxxxxxxxxxxxxxxx> wrote in message
news:xn0eitkir3kqor000@xxxxxxxxxxxxxxxxxxxxxxxxx
Jason Fischer wrote:

Just some extra info.

I am using D7 and SQL Server with the latest MDAC installed.

Thanks

"Jason Fischer" <jason_fischer_aus@xxxxxxxxxxxxxx> wrote in message
news:43fb87fe@xxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

I have some ADO query's that get opened and as soon as I open a
query that is set to be a server side cursor, every query opened
after that onme opens a new TCPIP connection.

Is there a way to stop this as it some times goes up to the around
a 1000 TCPIP connection (or so I have been told).

Could anyone shed some light on this for me please?

Thanks


have you connection pooling disabled?

--
Best regards :)

Guillem Vicens Meier
Dep. Informatica Green Service S.A.
www.clubgreenoasis.com
--
Contribute to the Indy Docs project: http://docs.indyproject.org
--
In order to contact me remove the -nospam



.

Relevant Pages

  • Re: How to do a Pick/DataBASIC http server service?
    ... I have used message queueing to perform connection pooling ... subroutines on the server returning any result back through the ... I would like to see a better way of getting from php on linux into U2. ... PHP + OpenQM client/server library + OpenQM ...
    (comp.databases.pick)
  • Re: E_UNEXPECTED(0x8000FFFF) Problem with OraOleDB.Oracle
    ... migration from Windows 2000 Server to Windows 2003 Server I have ... It comes from Oracle and not from Microsoft. ... Try disabling connection pooling to see if the ...
    (comp.databases.oracle.misc)
  • Re: Connection Pooling and low use web site
    ... I apologize for not putting more information in here. ... know for sure that it is connection pooling. ... application with SQL server on the backend using ADO.NET. ... I close the browser, open a new browser, then ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Application Role
    ... eavesdrop on the actual conversation Access is having with the SQL ... >While performance is not an issue so far with some 25 users and a big server ... >> more info on the connection pooling issue. ...
    (microsoft.public.sqlserver.security)
  • RE: Server Unavailable Error (aspnet_wp.exe)
    ... The first thing to check is the machine.config of the server. ... Next, if you are using SQL Server, open the profiler and see what is taking ... the Plumtree Portal is using connection pooling, ... When I look in the event log, ...
    (microsoft.public.dotnet.framework)