MSSQL ODBC And Transactions

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi There,



I have developed the ODBC app which can work with Oracle as well as
MSSQL server databases. I need to use transactions at some level. By
setting AUTOCOMMIT OFF and using SET TRANSACTION and BEGIN WORK,
COMMIT WORK everything works fine with Oracle. But with MSSQL server
does not. Do I need to code something special for MSSQL? Does anyone
has example on how to implement transactions with MSSQL server using
ODBC?



I tried reading lots of documents on Microsoft site but nothing
specifically says how to do this. One way the doc says is using
SQLSetConnectAttr with SQL_ATTR_TXN_ISOLATION but does not specify how
to.



Any help with appreciated. Thanks in advance.



Milind


.

Relevant Pages

  • Re: tquery vs tadoquery master/detail deletions
    ... >not sure if I then have to manually handle starting and committing ... >commit and/or rollback the transactions as needed. ... >MSSQL Server 2000. ... >part because of the lack of good detailed examples on ADO dataset usage. ...
    (borland.public.delphi.database.ado)
  • MSSQL ODBC And Transactions
    ... I have developed the ODBC app which can work with Oracle as well as ... MSSQL server databases. ... I need to use transactions at some level. ... COMMIT WORK everything works fine with Oracle. ...
    (microsoft.public.sqlserver.connect)
  • Re: What Borland should stop wasting their time on
    ... broken transaction support like MSSQL Server is beyond me. ... Even in its latest incarnation, for which it was supposed to have been fixed, it's still broken: write transactions DO still block read transactions. ...
    (borland.public.delphi.non-technical)
  • Re: Newbie Oracle Question
    ... What does this mean, Oracle SQL Server? ... Knowledge of MSSQL Server is of little benefit (and can indeed be an ... More than twice. ...
    (comp.databases.oracle.server)