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: 8501
Message: [Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC on server 'HYI3W131' is unavailable.
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.
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: 8501
Message: [Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC on server 'HYI3W131' is unavailable.
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.