Distributed transactions bet linked servers

hi anyone,
I checked the DTC on both ends to be on but I am still getting this message
when running an insert
New transaction cannot enlist in the specified transaction coordinator.
Thanks,
--
bicDid you enable Network DTC Access? I did it under 2003 Server but had to do
it again after installing SP1.
http://support.microsoft.com/default.aspx?scid=kb;en-us;329332
"bic" wrote:
> hi anyone,
> I checked the DTC on both ends to be on but I am still getting this message
> when running an insert
> New transaction cannot enlist in the specified transaction coordinator.
> Thanks,
> --
> bic

Distributed transactions bet linked servers

hi anyone,
I checked the DTC on both ends to be on but I am still getting this message
when running an insert
New transaction cannot enlist in the specified transaction coordinator.
Thanks,
bic
Did you enable Network DTC Access? I did it under 2003 Server but had to do
it again after installing SP1.
http://support.microsoft.com/default...b;en-us;329332
"bic" wrote:

> hi anyone,
> I checked the DTC on both ends to be on but I am still getting this message
> when running an insert
> New transaction cannot enlist in the specified transaction coordinator.
> Thanks,
> --
> bic

Distributed transactions bet linked servers

hi anyone,
I checked the DTC on both ends to be on but I am still getting this message
when running an insert
New transaction cannot enlist in the specified transaction coordinator.
Thanks,
bicDid you enable Network DTC Access? I did it under 2003 Server but had to do
it again after installing SP1.
http://support.microsoft.com/defaul...kb;en-us;329332
"bic" wrote:

> hi anyone,
> I checked the DTC on both ends to be on but I am still getting this messag
e
> when running an insert
> New transaction cannot enlist in the specified transaction coordinator.
> Thanks,
> --
> bic

Distributed Transactions among servers with different languages

Hello,

My software uses DTC. When my server pool consists of Windows 2000 English machines only, everything works perfect.

However, if I test the software with some computers running Windows and SQL Server in Spanish and others running Windows in English, the software fails. Sometimes I get "0x8004d01c: A connection with the Transaction Manager was lost," others "0x8004d01b: Failed to obtain the Transaction Dispenser Interface." The DTC services are up and running in all computers.

As I said, it all works well when all servers run English Windows 2000. Is there a chance that the Distributed Transaction Coordinator service in English can't communicate with its counterpart in a Spanish Win2000?

Any comments would be greatly appreciated... Thanks!Dont get me started.....

Have you checked Technet for this?

Cheers

SG|||I've not been able to get any documentation on this subject. What have you learned? Please "get started"...

Originally posted by sqlguy7777
Dont get me started.....

Have you checked Technet for this?

Cheers

SG|||Hi

Sorry...."get started" is an expression...ignore it...

If two servers run two different languages, a T-SQL command in english may look different to the same command in Espanol, si?

i.e. SELECT * FROM TEST - English
??? * ??? ??? - Espanol

Does microsoft use same key words in Espanol & English?

HTH

SG|||The key words are the same. The language syntax is the same. This is true for SQL, C, VB and everything else.

We've narrowed down the problem, and it seems that the property "isenabled" of a COM+ object is not available in the Spanish (or French) versions of Windows 2000. It does exist in Windows 2000 English. Is this possible?

Originally posted by sqlguy7777
Hi

Sorry...."get started" is an expression...ignore it...

If two servers run two different languages, a T-SQL command in english may look different to the same command in Espanol, si?

i.e. SELECT * FROM TEST - English
??? * ??? ??? - Espanol

Does microsoft use same key words in Espanol & English?

HTH

SG|||Howdy

I dont know - I'm not a COM+ dude. It is possible, and worth doing some more searching on the internet as well. Have you looked right through BOL as well?

Sorry I cant help more.

Cheers

SG|||I would be surprised if something as basic as that was not available but there are strange problems with language versions.

This sounds like a wwindows problem rather than sql server (unless you are talking about the database property). Try posting on the microsoft newsgroups

http://msdn.microsoft.com/newsgroups/

Distributed Transaction Coordinator

Hi,
I understand if I use Immediate update from Subscriber to Pulisher, i will
use the function of DTC, how about if I make a schedule e.g. every 1 hour,
when it runs (Push/Pull), does that use DTC also?
Second ? is do i have to use Remove Server to run or I can use Linked
Server?
Thanks so much
Ed
Ed,
the schedule refers to the distribution agent and applies to commands going
from the publisher to the subscriber. if you want to 'postpone' the relay of
commands from the subscriber to the publisher, you can use queued updating
subscribers. Replication uses remote servers, but linked servers can also be
used for the DTC (have a look at :
http://support.microsoft.com/default...b;en-us;274098 )
HTH,
Paul Ibison, SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)