Ergebnis der Suchanfrage

• Forum: Datenbanken

  Re: ADODB Transaction and MSSQL

    Delphi
    by miroslaw, 15. Jan 2007
  Oliver,
  
  nice to hear from you.
  
  As you can see the code goes to the place where the error occurs.
  In reality there are 25763¼ SQL statements which should be protected
  by ACID, or simply speaking transaction.
  
  Anyway I connot imagine that it should be forbidden to you transactions
  for select statements also.
• Forum: Datenbanken

  Re: ADODB Transaction and MSSQL

    Delphi
    by miroslaw, 14. Jan 2007
  no this doesn't solve the problem.
  
  The error disappears when I don't call BeginTrans but in that case I have autocomit which I definitely don't want.
• Forum: Datenbanken

  ADODB Transaction and MSSQL

    Delphi
    by miroslaw, 14. Jan 2007
  Hello,
  
  I'd like to use transactions accessing MSSQL 2005. I'm using Delphi 5.
  The following code causes Ole exception:
  
  _conId := TADOConnection.Create (nil);
  
  _conId.ConnectionString := ConnString;
  _conId.IsolationLevel := ilSerializable;
  _conId.LoginPrompt := False;