Devart Forums

On my systems, I am developing on Windows 2003 server, where I have mssql installed.

On my test machine, I am running windows xp, and have sqlexpress installed.

Either system will work, if I run locally.

On either sytem, if I connect to the 'opposite' system and try editing a record, (which starts a transaction), I get an error when I call

'msTransaction.StartTransaction'

Watching it through dbmonitor, I see the error :

The partner transaction manager has disabled its support for remote/network transactions.

Followed by the assertion failure in my program:
Assertion failure d:\projects\Delphi\sDac\Source\OledbAccess line 4251.

Since one of my sites is hitting this, can you point me in the correct direction to fix?

I am using sDac 4.35.0.14
Delphi 7

It looks like one or more connections cannot start transaction because of settings of corresponding SQL Server. Assert is a wrong error, and we will fix it in the next build of SDAC. If you properly setup all servers, this assert will disappear.
To get more information about server settings, search at Microsoft's site for text of the error message you caught by DBMonitor.

Did you also fix the :
Assertion failure d:\projects\Delphi\sdac\source\crthread.pas line 272?

(another client, but not sure of the sdac version)

This problem should be fixed if someone reported about it. Could you provide more detailed information about this problem?

Unfortunately no -
client site sent me a screen shot with it, but I can't recreate.

This assert may be related to asynchronous data fetch, TMSServiceBroker or TMSChangeNotification components. I hope this information will help you to track down this problem.

No help there, then. I'm not using either one.