Re: ADO and TCPIP Connections



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.

How are you connecting to the database? Are you using a TAdoConnection
component or a connection string in each query?

I use a TAdoConnection for all my queries and I'm not seeing what you describe.

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).

How was this tested?

-Steve-


.