January 26, 2007 at 2:53 pm
Been having troubles getting DTC to work betweeen virtual machines running SQL. I have two virtual PCs and two virtual servers all running on my desktop, and when I try to run a simple transaction from either VPC to a VS, I get intermittent 7391 errors. In other words, I run it in query analyzer (SQL 2000) and about half the time I get a result back (91) and the other half I get this:
Server: Msg 7391, Level 16, State 1, Line 2
The operation could not be performed because the OLE DB provider 'SQLOLEDB' does not support distributed transactions.
[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]
The code I'm trying is:
begin transaction
select count(*) from [vs-rc-w2k].northwind.dbo.customers
commit transaction
Anyone have any insights or similar experiences? We use virtual servers in our lab and the intermittent behaviour has me worried.
January 29, 2007 at 8:00 am
This was removed by the editor as SPAM
February 1, 2007 at 3:31 am
I had some similar problems ( without virtual servers or pc's ) there's some issues in ms kb about xp. Other than that our issues related to nested transactions and ditto within ado transactions.
Don't know if that helps at all.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply