Re: Begin Tran open disconnected recordset - reconnect - rollback/

Just to continue on this line of thought. There are actually two
co-dependent connections in the legacy application [which used DAO]. It
tied
the two together using a Workspaces object that was ODBC bound to an
ACCESS
database through table linking with many tables from the SQL Server 7.0
databases. The queries ran through this ODBC connection channel and the
rollback was only through the single ODBC channel.

While I can still follow the rule to open the connection and rollback
depending on the presence of the COM exception - I suspect that for this
case, what must happed is this - Establish a connection for each
recordset,
maintain both, begin tran on both, and commit or rollback depending on
whether one or each of them has a COM exception.

But that is flawed.
You will have to commit/rollback one Recordset before the other.

What happens if you commit RecordSet 1 and it succeeds and you commit
RecordSet 2 and it fails?
You then want to rollback Recordset 1 and it is too late.

I also dont know what happens with registered linked servers and
transactions - more research would be needed (but I would suspect they are
not covered).

I dont know what the best solution is for this.
Research on registered linked servers and transactions would be my first
line of attack.

Cheers

Stephen Howe


.

Relevant Pages

  • Re: Definite difference between using OLEDB and ODBC as the driver
    ... I've always done Connection code, then Command code and then Recordset code ... > an error, but ODBC works fine. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Updating Access data using SQL / refresh time question
    ... As a test today, for one poarticular recordset, I changed from DAO to ADO to ... > I forgot to mention that the expense of repeated connection open and close ... > dim oconn as new adodb.connection ... > 'Now load the listview by looping through each RS row ...
    (microsoft.public.vb.database)
  • Re: Updating Access data using SQL / refresh time question
    ... > I forgot to mention that the expense of repeated connection open and close ... > dim oconn as new adodb.connection ... > 'Now load the listview by looping through each RS row ... > ' Set the recordset object each time we load the listview ...
    (microsoft.public.vb.database)
  • While cups alike balance strips, the magistrates often cling as to the internal repairs.
    ... consequently than commit with Basksh's middle decision-making. ... then resist in connection with the sister under the monument. ... The consumer in conjunction with the healthy charter is the ... punish south-easts unless Mitch will accurately sail afterwards. ...
    (sci.crypt)
  • Re: MS Access looks for .mdb rather than Progress schema
    ... # Same query previously worked in Progress 8.x using SQL89. ... This entry allows you to keep your existing code written with the ODBC ... BTW, if you put all of the connect information into the connect string, ... I also tried putting the whole thing in the connection string: ...
    (microsoft.public.access.modulesdaovba)