Insert into from LinkedServer [RESOLVED]

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Insert into from LinkedServer [RESOLVED]

Author

Topic

erickwidya
Starting Member

5 Posts

Posted - 2007-08-02 : 00:34:55

hi all,

i try to execute INSERT query from linked server to local server using VB 6 SP6, MSSQL 200 SP4, XP Prof. Ed. SP2

why do i received this error

quote:
-2147217900
[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]

i already set the MSDTC and also follow the KB's intruction..

PS: if i run it using QA, it work fine

plz help

thanks,
erick

jonasalbert20
Constraint Violating Yak Guru

300 Posts

Posted - 2007-08-02 : 01:03:26

kindly post the query.

Want Philippines to become 1st World COuntry? Go for World War 3...

erickwidya
Starting Member

5 Posts

Posted - 2007-08-02 : 01:51:04

[code]SET XACT_ABORT ON TRUNCATE TABLE [DBName].dbo.TableName
INSERT INTO [DBName].dbo.TableName
SELECT * FROM OPENQUERY(LinkedServer,'SELECT * FROM [DBName2].dbo.TableName2')[/code]

EDIT: already try four name part, already try using SPROC either but the error still the same when i try to running it from the Application

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-08-02 : 02:08:33

change the DTC configuration to 'no authentication required' and re-test.

-ec

erickwidya
Starting Member

5 Posts

Posted - 2007-08-02 : 03:23:50

ok..already been set up and looks fine..

it works ok..it need the computer to be restarted not just the service :(
and for the past this couple days, i never try to restarted the computer ..o noo

thanks all

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources