Author: Brian PhillipsBrian Phillips
Date: May 6, 2008 11:27
I am trying to use a SQL Adapter to query a view on a SQL Server 2005 db.
The view connects to a Sybase ASE database via a linked server. When the
query executes, I get the following error.
The adapter "SQL" raised an error message. Details "HRESULT="0x80040e14"
Description="The operation could not be performed because OLE DB provider
"Sybase.ASEOLEDBProvider" for linked server "XXXLINK2" was unable to begin a
distributed transaction."
HRESULT="0x80040e14" Description="The OLE DB provider
"Sybase.ASEOLEDBProvider" for linked server "XXXLINK2" reported an error. The
provider did not give any information about the error."
".
I admit I don’t know a whole lot about DTC, but I don’t understand why a
distributed transaction would be necessary for a simple select. Also, Sybase
ASE runs on Linux, so DTC would not be applicable.
Any help you could provide would be appreciated.
Thanks,
-Brian
|