Thank you for the quick reply.

I did all the things that I was supposed to do in order for this to work (followed the instructions posted on Microsoft support page)...

That's the problem. But if I want to fix this problem I have to obtain a Hotfix: Microsoft Windows 2000 Post-Service Pack 4 (SP4) COM+ 1.0 Hotfix Package 27 which...

The Distributed Transaction Coordinator service is started and at properties in the Log on tray I have: Log on as: Local System account.

The exact error is: "MSDTC on server 'SERVER-MACHINE'...

There is one more problem for me: if I try executing all that using a transaction (begin tran UPDATE... commit tran) I get this error: MSDTC on server 'SERVER-MACHINE' is...

Yes I finally realized the comma error to. I can't believe i didn't see it in the first place!

Thank you for the supplied example to.

Regards,

Michael

Hello

If i use "server=localhost" i get the same error:Login failed for user 'sa,Password='.

I have resolverd the conenction problem using OPENROWSET like this:

SELECT *

FROM OPENROWSET('SQLOLEDB','localhost';'sa';'',

'SELECT * FROM Bank.dbo.ClientInfo').

My...