February 5, 2009 at 1:55 pm
When I attempt to create a view that accesses objects on a remote instance, it fails. I'm able to expand the linked server used to access the remote objects and see the objects. This problem only occurs when I'm accessing an sql instance object that is running on a 2000 Windows Operating System from the requesting instance that is running 2003 Windows Operating system. If both local and remote 2000 sql instances are operating on Windows 2003 server, there is no problem. DTC is running on all the Windows 2003 operating systems. Any ideas for a solution?Thanks for everyone for being there to help.
February 5, 2009 at 2:22 pm
Can you run a select on the data you are trying to pull from the remote server? Just that part of the view by itself, I mean.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 6, 2009 at 6:13 am
Thanks for replying. A select fails.
February 6, 2009 at 6:56 am
What error message do you get?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 6, 2009 at 7:40 am
Here's the error...Thanks for helping:
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server] The operation could not be performed because the OLD DB provider 'SQLOLEDB' was unable to begin a distributed transaction.
[Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB provider returned message:New transaction cannot enlist in the specified transaction coordinator.]
[Microsoft][ODBC SQLServer Driver][SQL Server] OLE DB error trace [OLD/DB Provider 'SQLOLEDB' ITransaction JoinTransaction returned 0x8004d00a].
February 6, 2009 at 1:13 pm
I think that is caused by one or both of the servers not having remote transactions handling enabled correctly. You might try checking into that. Of course, I'm assuming you're already done a web search (Google/Live/whatever) for the error message.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply