Re: ADO - Bad when it is time to Optimize


"Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx> wrote in message
news:eHjwxR9YHHA.3824@xxxxxxxxxxxxxxxxxxxxxxx
cvsudheer@xxxxxxxxx wrote:
<snipped>

Is it even possible to create a disconnected recordset from a server-side
cursor? I seem to recall attempting to do this once and getting an error.
If
I have a chance later today I will see if my memory is playing tricks on
me.


Now you got me thinking, and I intend to go play myself later on. The
situation I remember was where code had been reworked to use a disconnected
recordset. They were using ADO 2.5 and the MSOracle provider (and Oracle
7???). There was no error - the disconnect just didn't happen.
ActiveConnection was 'nothing', but the connection was still out there.

Which leads to another interesting point. After rereading all the articles
you cited I was reminded of how many actors are actually involved in any
scenario - the data access version, the provider/driver (vendor), the
database version, and ultimately the wire. Something benign in one may have
profound effects in another.

Then you can have a situation where the engine/provider are spawning their
own 'extra' connections to support some kinds of queries. Quite beyond the
control of one's ADO calls or one's knowledge.

Which leads back to the OP's question - what is a good general tool or
method to use when trying to investigate possible pooling issues?

I started to offer some suggestions and then realized that I usually just
end up hacking my way through one damn scenario after another using "All of
the above" at some point or another. <g>

-ralph


.

Relevant Pages

  • Re: Recovering 2.5 hp motor for phase convertor (long story with pictures)
    ... "Star/Delta" refers to the way the windings can be configured for approx. ... With 6 leads brought out, the motor must be externally configurable for "Star" or "Delta". ... also; Converting from one configuration to the other does yield a sq.root of 3 change in voltage and vs. Assume the 6 leads brought out from each ... This would be the high voltage connection. ...
    (rec.crafts.metalworking)
  • Re: Precipitous Collapse of the US dollar
    ... protestant fortnight. ... Will you evolve in connection with the inside, ... leads the punch? ...
    (sci.crypt)
  • Re: RDP & Port Forwarding
    ... Scenario 2: Using Remote Desktop outside your network ... you have a persistent high-speed connection --if you only ... This is the port that Remote Desktop uses by default, ...
    (microsoft.public.windowsxp.general)
  • Re: Why use a firewall with dialup?
    ... SYN-ACK depending on the port. ... packets not to TCP port 22 or part of an outgoing connection plus block ... Bluescreen leads to downtime. ... Downtime leads to suffering. ...
    (freebsd-questions)
  • Re: Remobjects, good in multi-threading environment?
    ... the connection is interrupted regularly. ... This can certainly be handled by the WIB. ... require a response back. ... Hence your worst case scenario would still work and we would be able to ...
    (borland.public.delphi.thirdpartytools.general)