Re: ADO and TCPIP Connections

Thanks Steve,

I'll keep looking.
The only reason why we found it is because some of our users started
complaining about performance over a network and their setup (network and
servers etc...) was pretty high.

Like I said, I'll try have a look and see if I can find anything else out.

Thanks again for trying :)

"Steve Zimmelman" <skz@xxxxxxxxxxxxxxxxxx> wrote in message
news:43fced65$1@xxxxxxxxxxxxxxxxxxxxxxxxx
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: Wireless connection
    ... Just I returned the D-Link and I will try "Netgear" some of my friends ... > then right click on IntelPRO/Wireless 2200BG Network connection (local ... >> setup but I cannot get the Internet. ...
    (microsoft.public.windowsxp.network_web)
  • Re: Will Xbox Extender work on UK/PAL Xboxes?
    ... you have an adhoc network here the way this is setup. ... as an ad hoc connection to this AP. ... I strongly recommend you reconfigure your network to use a router ... the problem must be with the WGA or Xbox settings. ...
    (microsoft.public.windows.mediacenter)
  • Re: Network Novice needs alot of help with win98 and xp setup.
    ... Host:- win xp with broadband connection with Realtek RTL8139 Family Fast ... Client:- Laptop with Win98 and installed Belkin CardBus NetWork Card ... computer during the graphic at the end of the setup. ... To configure Windows 98 to use the shared Internet connection, ...
    (microsoft.public.windowsxp.network_web)
  • Re: Network Novice needs alot of help with win98 and xp setup.
    ... Host:- win xp with broadband connection with Realtek RTL8139 Family Fast ... Client:- Laptop with Win98 and installed Belkin CardBus NetWork Card ... computer during the graphic at the end of the setup. ...
    (microsoft.public.windowsxp.network_web)
  • Re: Trying to setup network so I can share printer
    ... I decided after all my meddling tryng to setup networks that my best bet was ... to restore laptop to factory settings so it has a clean slate and then system ... I then thought I would run Network Diagnostics from ... I have an internet connection through Bigpond ADSL. ...
    (microsoft.public.windowsxp.print_fax)