Re: ADO and TCPIP Connections

I don't know. I've never had that happen. Or if it has, I'm not aware of it.
I tested one of my apps on my system with multiple queries and only saw 3
connections for the app.

-Steve-

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

We are using a TADOConnection.
A test app was setup that opens query's to the DB, while this is happening a
TCPIP scanner is running and that it how it was picked up.

Could it be how the ADOConnection has been setup that could cause this?

Thanks

"Steve Zimmelman" <skz@xxxxxxxxxxxxxxxxxx> wrote in message
news:43fcb498$1@xxxxxxxxxxxxxxxxxxxxxxxxx
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-






.

Relevant Pages

  • Re: A month with a Nokia n95 (long)
    ... and can't play. ... One of these days I will get around to writing a small app to do it all on the fly. ... HSDPA works well and you can have more than one internet connection going at once. ... For example I can use it as a modem for my laptop and also "listen again" to a Beeb radio programme. ...
    (uk.telecom.mobile)
  • Re: ADO Connection.Execute Method leaves Open SQL Process
    ... Have the App create a single ADODB.Connection object, ... requesting only one connection from a single ADO Connection ... Pool, thus if all requests are sequenced and not over-lapping ...
    (microsoft.public.vb.database.ado)
  • Re: ADO Connection.Execute Method leaves Open SQL Process
    ... your first paragraph where it talks about "a VB6 app". ... requesting only one connection from a single ADO Connection ... ' at this point a new SQL process HAS been created!! ...
    (microsoft.public.vb.database.ado)
  • Memory leak with ADO
    ... When the app runs through the loop 2k times about 16-30 megs ... procedure TForm1.SpeedButton1Click(Sender: TObject); ... Caption = 'Connection String' ... object Connection: TADOConnection ...
    (borland.public.delphi.database.ado)
  • Re: ASP.NET data access
    ... > Since you need disconnected data, datareader is not necessary. ... >> which was then saved back to the db when the app was shut down. ... >> it is returned from the dataset saving a connection, ... The problem that this technique seems to have ...
    (microsoft.public.dotnet.framework.aspnet)