Re: ADO and TCPIP Connections

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: ADO and TCPIP Connections
    ... I am using D7 and SQL Server with the latest MDAC installed. ... I have some ADO query's that get opened and as soon as I open a query that ... opens a new TCPIP connection. ... TCPIP connection. ...
    (borland.public.delphi.database.ado)
  • Re: How to Mimic Access Externally Linked Tables using ADO?
    ... > using SQL Server for efficiency reasons. ... > connection up programmatically using ADO or ADOX or some SQL Server API? ... >> newsgroup, but if you have a good reason to send me e-mail, you'll find ... ADO does not have a query engine. ...
    (microsoft.public.data.ado)
  • Re: How to access the SQL server express from mfc application?
    ... There are different ways to do this via MFC. ... You could certainly try ADO, ... the entire contents of the database to a SQL Server Standard Server. ...
    (microsoft.public.vc.mfc)
  • Re: DAO vs ADO
    ... and ADO when working with SQL Server data. ... which makes DAO a good choice. ... > add additional overhead by loading Jet, ...
    (microsoft.public.access.conversion)
  • Re: DAO vs ADO
    ... and ADO when working with SQL Server data. ... which makes DAO a good choice. ... > add additional overhead by loading Jet, ...
    (microsoft.public.access.adp.sqlserver)