#13 Error when using MpmTransaction with SQL Server database

closed
Bengt Gunne
None
5
2005-05-24
2005-04-19
Sean Flook
No

I am trying to use a MpmTransaction with a group of
update stored procedures. This code worked for SQL
Server before converting the code to use Mimer.

Now when I call the update on the dataadapter I get the
following message:

"The transaction objectis not associated with the
connection object".

The same code works fine with Oracle

Discussion

<< < 1 .. 3 4 5 (Page 5 of 5)
  • Bengt Gunne
    Bengt Gunne
    2005-04-22

    Logged In: YES
    user_id=895705

    That is good news!

    Bengt

     
  • Sean Flook
    Sean Flook
    2005-05-10

    Logged In: YES
    user_id=684148

    Bengt

    Sorry to say that this issue has raised its head again when I
    am using the transaction object with the delete commands.
    Looking at the properties of the MpmDataAdapter delete
    command I noticed that
    MpmConnetion.State = Open,
    MpmTransaction.Connection.State = Open,
    MpmTransaction.NativeTransaction.Connection.State =
    Open,
    NativeCommand.Transaction.Connection.State = Open

    but

    NativeCommand.Connection.State = Closed

    Hope this helps.

    This is happening for SQL Server.

    Sean

     
  • Sean Flook
    Sean Flook
    2005-05-10

    • status: closed --> open
     
  • Sean Flook
    Sean Flook
    2005-05-24

    • status: open --> closed
     
<< < 1 .. 3 4 5 (Page 5 of 5)