7391 error while inserting. - SQL Server Forums

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

SQL Server Development (2000)

7391 error while inserting.

Author

Topic

hafeez
Starting Member

14 Posts

Posted - 2006-10-06 : 01:38:28

Hi,
I am using SQL SERVER 2005 standard edition in windows xp environment.

And remote system also have same SQL SERVER 2005 standard edition windows xp environment.

I am using LINKED SERVER concpet to read and write the data into another database.

I am able to read the data from another database. But failing to write(Insert) the data.

INSERT INTO OPENQUERY(TS1,'SELECT * FROM hyi3w162.dpvsql.dbo.sampl
e') VALUES(3)

When i run this command i am getting the following error.
MSSQL error. SQLSTATE: 42000 Native error: 7391
Message: [Microsoft][ODBC SQL Server Driver][SQL Server]The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "TS3" was unable to begin a distributed transaction.

One more question is How do i set environment variables in MS SQL(Ex: like ORA_HOME is there any env variable available that i need to set)

Please help me regarding this issues.
Thanks in advance.
Hafeez.

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2006-10-06 : 04:02:09

What happened here? ->
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=72906

--
Lumbago
"Real programmers don't document, if it was hard to write it should be hard to understand"

hafeez
Starting Member

14 Posts

Posted - 2006-10-06 : 06:34:56

Hi,
I followed the steps whatever mentioned in this link.
http://support.microsoft.com/kb/q300083/
after followed this steps i got the above error.
So, please help me regarding this.
Thanks,
Hafeez.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources