Hello

I have set a SQL Adapter executing a stored procedure, which executes an Ope
nquery sentence retrieving information from a Linked Server (Oracle).

I receive an error: 'MSDASQL' was unable to begin a distributed transaction.

Does anybody knows if is possible to access Oracle this way or not?

I am not sure if this is only a configuration error (MSDTC, databases settin
gs ...) or
if the only way to do this is an adapter to Oracle.

Thank you.

Óscar.

The adapter "SQL" raised an error message. Details "HRESULT="0x80040e14" Des
cription="The operation could not be performed because the OLE DB provider '
MSDASQL' was unable to begin a distributed transaction."
HRESULT="0x80040e14" Description="OLE DB error trace [OLE/DB Provider 'M
SDASQL' ITransactionJoin::JoinTransaction returned 0x8004d00a]."
HRESULT="0x80040e14" Description="[OLE/DB provider returned message: 	
1;Oracle][ODBC]MTS support not available, could not load ORAMTS.DLL]"
<?xml version="1.0" encoding="utf-16" ?><Respuesta xmlns="http://Consulta
Pedido.SchemaSQLOrder"><?MSSQLError HResult="0x80040e14" Source="Microsoft O
LE DB Provider for SQL Server" Description="The operation could not be perfo
rmed because the OLE DB pr
ovider 'MSDASQL' was unable to begin a distributed transaction."?><?MSSQLErr
or HResult="0x80040e14" Source="Microsoft OLE DB Provider for SQL Server" De
scription="OLE DB error trace [OLE/DB Provider 'MSDASQL' ITransactionJoi
n::JoinTransaction returned 0x8
004d00a]."?><?MSSQLError HResult="0x80040e14" Source="Microsoft OLE DB Provi
der for SQL Server" Description="[OLE/DB provider returned message: [
;Oracle][ODBC]MTS support not available, could not load ORAMTS.DLL]"?></
Respuesta>".

[ Post a follow-up to this message ]

I had the same problem as you, and as far as I found out, you can't make
distributed transactions via linked server to an Oracle database. But I
would like to now if you find a solution. I solved it by replicating the
data to a sql database.
"Oscar F" <OscarF@discussions.microsoft.com> wrote in message
news:00DB1C18-E7D9-4AD6-8F61-5DD53C08C01C@microsoft.com...
> Hello
>
> I have set a SQL Adapter executing a stored procedure, which executes an
Openquery sentence retrieving information from a Linked Server (Oracle).
>
> I receive an error: 'MSDASQL' was unable to begin a distributed
transaction.
>
> Does anybody knows if is possible to access Oracle this way or not?
>
> I am not sure if this is only a configuration error (MSDTC, databases
settings ...) or
> if the only way to do this is an adapter to Oracle.
>
> Thank you.
>
> Óscar.
>
> The adapter "SQL" raised an error message. Details "HRESULT="0x80040e14"
Description="The operation could not be performed because the OLE DB
provider 'MSDASQL' was unable to begin a distributed transaction."
> HRESULT="0x80040e14" Description="OLE DB error trace [OLE/DB Provider
'MSDASQL' ITransactionJoin::JoinTransaction returned 0x8004d00a]."
> HRESULT="0x80040e14" Description="[OLE/DB provider returned message:
[Oracle][ODBC]MTS support not available, could not load ORAMTS.DLL]"
>  ?<?xml version="1.0" encoding="utf-16" ?><Respuesta
xmlns="http://ConsultaPedido.SchemaSQLOrder"><?MSSQLError
HResult="0x80040e14" Source="Microsoft OLE DB Provider for SQL Server"
Description="The operation could not be performed because the OLE DB
provider 'MSDASQL' was unable to begin a distributed
transaction."?><?MSSQLError HResult="0x80040e14" Source="Microsoft OLE DB
Provider for SQL Server" Description="OLE DB error trace [OLE/DB Provide
r
'MSDASQL' ITransactionJoin::JoinTransaction returned
0x8004d00a]."?><?MSSQLError HResult="0x80040e14" Source="Microsoft OLE DB
Provider for SQL Server" Description="[OLE/DB provider returned message:
[Oracle][ODBC]MTS support not available, could not load
ORAMTS.DLL]"?></Respuesta>".

[ Post a follow-up to this message ]