Transactions failing Win10 XE5 SDAC 6.8.16
Posted: 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
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