Transactions failing Win10 XE5 SDAC 6.8.16

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
mskeels
Posts: 16
Joined: Tue 06 Mar 2012 15:08

Transactions failing Win10 XE5 SDAC 6.8.16

Post by mskeels » Wed 02 Dec 2015 16:47

I have an application written in XE5 which was working correctly on Windows 8.1. It is using Devart SDAC components to access SQL Server 2008 R2 database on a Windows 2008 Server.

Upon moving to Windows 10, There is an error I keep getting and it is definitely associated with the SDAC components. I get the error message

"Cannot issue SAVE TRANSACTION when there is no active transaction."

This occurs when executing code like

if not fdmSQL.msCROEHeader.Connection.InTransaction then
begin
fdmSQL.msCROEHeader.Connection.StartTransaction;
end;

I know this is vague, but so is the problem. I was able to stop the error in one area of the program by changing the way the transactions were handled but that in turn broke another area of the program.

Not sure what to do; looking for ideas please.

Mark

azyk
Devart Team
Posts: 1058
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: Transactions failing Win10 XE5 SDAC 6.8.16

Post by azyk » Thu 03 Dec 2015 10:11

To solve the issue, try to download the latest SDAC version 7.2.8 and update. The latest version download is available on our website: https://www.devart.com/sdac/download.html . Let us know if the issue remains.

mskeels
Posts: 16
Joined: Tue 06 Mar 2012 15:08

Re: Transactions failing Win10 XE5 SDAC 6.8.16

Post by mskeels » Mon 07 Dec 2015 15:39

Ok we're testing but it looks like that solved the problem. I'll update this thread when we know more. Thanks a bunch.

Post Reply