|
| Hi,
I have some problems running transactions against an SQL Server database. I get the following error when my method executes:
"The connection cannot be used to perform this operation. It is either closed or invalid in this context."
This is a transactional component installed on COM+, on my Windows XP SP2 computer. Before installing SP2 there was no problem runnig the distributed transaction. There is also no problem executing the same method of my component if the component is installed on COM+ but it isn't a transactional component. The problem seems to be with the DTC when SP2 installed.
The SQL Server 2000 database is on a different computer on an Windows 2000 Server machine. The machines are in the same domain and there is connectivity between the Win 2k server and my Win XP machine - I've tryed pinging on both machines.
I know that when installing service pack 2 on Win XP, MS-DTC gets a whole new set of security features turned off so I activated Network DTC Access allowing inbound/outbound transactions, XA Transactions etc.
I also enabled network traffic for msdtc.exe program.
Everithing seems to be ok, but my transaction doesn't work. I've made tests with different Win 2k servers/Win XP SP2 machines and the result is the same.
Any suggestions, please? |
|