Transaction with(out) Statements

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for SQL Server in Delphi and C++Builder
Post Reply
fake
Posts: 4
Joined: Wed 01 Mar 2006 09:43

Transaction with(out) Statements

Post by fake » Wed 03 May 2006 14:48

if i trace my database-traffic i encounter the following situation:

SQLTransaction Begin 2466650 53 x MGPC01
SQLTransaction Commit 2466650 53 x MGPC01
RPC:Completed exec sp_executesql N'UPDATE Patient ...
SQLTransaction Begin 2466718 53 x MGPC01
SQLTransaction Commit 2466718 53 x MGPC01
RPC:Completed exec sp_executesql N'UPDATE Patient ...

why are there SQLTransactions Beginns and Commits, but no Statement in it? Why is there no Transaction around the statements ?

thanks for helping me understanding this

Jackson
Posts: 512
Joined: Thu 26 Jan 2006 10:06

Post by Jackson » Fri 05 May 2006 10:47

We couldn't reproduce the situation.
Please send us a complete small test project to reproduce the situation; it is desirable to use Northwind or Master schema objects, otherwise include definition of your own database objects; don't use third party components

Also supply us following information
- Exact version of Delphi.
- Exact version of DbxSda. You can see it history.html.
- Exact version of Microsoft SQL Server and OLE DB provider that you use.
You can see it in version info of SQLOLEDB.DLL and SQLNCLI.DLL.

Post Reply