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.
| Author |
Topic |
|
hafeez
Starting Member
14 Posts |
 Posted - 2006-10-03 : 05:35:23
|
| 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.sample') VALUES(3)When i run this command i am getting the following error.MSSQL error. SQLSTATE: 42000 Native error: 8501Message: [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. |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2006-10-03 : 07:08:30
|
| Ok, I'm no genious on MS DTC (Microsoft Distributed Transactions Coordinator) but have you verified that this service is running on both computers? It's named "Distributed Transaction Coordinator" and is found with all other services in Computer Management.--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-03 : 07:13:06
|
| yes DTC service is running on both the computers and still getting the same problem. :-( |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2006-10-03 : 07:32:16
|
| Hm, as I said I don't know too much about DTC so I'm just shooting in the dark here but are any of the servers on a cluster? In that case this might help you: http://support.microsoft.com/kb/822473/Maybe you can also try to rewrite your query so it doesn't get interpreted as a distributed transaction?-> http://www.mcse.ms/archive81-2005-1-1389350.html--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-03 : 08:02:44
|
| Hi Lumbago,Thanks for your reply..but i don't know what is the servers in cluster environment.By the way is there any environment variable like ORA_HOME for MS SQL SERVER to set?Please suggest any other solution.Thanks,Hafeez. |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2006-10-03 : 08:32:58
|
| What is ORA_HOME? There are unfortunately no global variables you can set in sql-server...you would have to "hack" it by creating a table in the master database or something..--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
|
|
|
|
MSDTC error in Windows xp environment.