Re: Why all the connections?


"Kevin Davidson" <kevin@xxxxxxxxx> ???????/???????? ? ???????? ?????????:
news:43de2912@xxxxxxxxxxxxxxxxxxxxxxxxx
> Vitali Kalinin wrote:
>> Which CursorLocation, CursorType and LockType do you use for the
>> datasets? ReadOnly, ForwardOnly, ServerSide cursors could result in
>> behavior that you had described.
>>
>>
>>
> Yes, I am using clUseServer, ctOpenForwardOnly and ltReadOnly. I would
> like to learn more about why this could cause multiple connections. I will
> try other combinations.
>
> I believe I have other applications with the same cursor and locking that
> do not exhibit extra connections. I need to do more study.
>
> Thanks (spacibo),
>
> Kevin
MS SQL OleDB allows only single open fire horse cursor per connection, but
ADO tries to hide that restriction from you and silently clones connection
busy with fire horse cursor. So you should always close fire horse cursors
ASAP. Also I would consider using SQLjoin instead of doing lookup for each
record on the client side.



Regards,

Vitali


.

Relevant Pages

  • Re: Question about Connection Pooling in ASP
    ... >> connections, such as recordset loops using connected recordsets, ... > since you are only retrieving one value and closing the recordset? ... Even better would be to use the default forwardonly cursor instead of the ... Different access modes will force new connections. ...
    (microsoft.public.inetserver.asp.db)
  • Re: can i set up a mysql db connection as a class ?
    ... it seems to mix up connections and cursors. ... Beside of that I would prefer not to share the cursor ... def DestroyConnection: ... is there any risk of two threads accessing the Execute ...
    (comp.lang.python)
  • Re: SQL Connection Management
    ... How are connections to remote databases managed when you use static SQL ... cursor", "fetch" and "close cursor". ... CRTSQLCPPI I specify the information for a remote database. ...
    (comp.sys.ibm.as400.misc)