SQL 2005 and ADO cursors automatically closed after commit
- From: "Nektar Meletakos" <nmeletakos@xxxxxxxxxxxxxxx>
- Date: Thu, 23 Mar 2006 10:48:58 -0500
We have a problem with cursor's being closed after a transaction commit or
abort.
We are using VB 6.0, ADO, with SQL Server 2005.
We do the following after opening a connection:
SET CURSOR_CLOSE_ON_COMMIT OFF
We set our recordsets with the following:
..CursorLocation = adUseServer
..CursorType = adOpenDynamic
..Properties("Preserve on Abort") = True
..Properties("Preserve on Commit") = True
This prevented open cursors from being closed when commiting or aborting
transactions.
This worked perfectly in SQL 2000 but now we are using SQL 2005 and the
settings don't seem to have any effect anymore.
With SQL 2005, the cursors are closed automatically after a commit or abort.
.
- Prev by Date: Re: Default Maxlength - CLR 2.0
- Next by Date: Re: "No such interface supported" error on Catalog.Create and Connection.Open
- Previous by thread: Component Checker
- Next by thread: 2 tier or 3 tier model?
- Index(es):
Relevant Pages
|
|
