|
Home > Archive > BizTalk Server General > July 2004 > SQL Adapter distributed transaction
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL Adapter distributed transaction
|
|
| Oscar F 2004-07-09, 3:31 pm |
| 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 pr
ovider '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 Provider 'MSDASQL' ITransactionJoin::JoinTransaction returned 0x8
004d00a]."?><?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>".
| |
| Paw Pedersen 2004-07-09, 3:31 pm |
| 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 Provider
'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>".
|
|
|
|
|