Assertion failure

ccmcbride · Post by **ccmcbride** » Mon 21 Jan 2008 16:30

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

Antaeus · Post by **Antaeus** » Tue 22 Jan 2008 14:18

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.

ccmcbride · Post by **ccmcbride** » Wed 23 Jan 2008 21:02

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)

Antaeus · Post by **Antaeus** » Thu 24 Jan 2008 07:56

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

ccmcbride · Post by **ccmcbride** » Thu 24 Jan 2008 17:34

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

Antaeus · Post by **Antaeus** » Fri 25 Jan 2008 09:54

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.

ccmcbride · Post by **ccmcbride** » Fri 25 Jan 2008 15:57

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