Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Distributed transaction error when querying view (Read 2987 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Distributed transaction error when querying view
19.03.10 at 14:20:24
 
Distributed transaction error when querying view
 
When running a query against a view that retrieves information from linked servers in SQL Server can run into the following problem. A simpel select * from myview result in errors that indicate problems with distributed transations:
 

Error 2: -2147217900: [Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB error trace [OLE/DB Provider 'SQLOLEDB'ITransactionJoin::JoinTransaction returned 0x8004d00a].
 
Error 3: -2147217900: [Microsoft][ODBC SQL Server Driver][SQL Server]The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a ditributed transaction.

 
On Microsoft's site:
 
You may receive a 7391 error message in SQL Server 2000 when you run a distributed transaction against a linked server after you install Windows Server 2003 or Windows XP Service Pack 2
 
For resolution of this problem see:
http://support.microsoft.com/kb/839279
Back to top
 
« Last Edit: 19.03.10 at 14:20:39 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1