Hello list,
we are running Remedy with an MS SQL Database ... we have established a
linked server connection to an Oracle DB.
This connection is running fine, and I am able to select and insert
entries using the Query Analyzer.
However, when trying the same with Direct SQL from a Remedy Escalation,
we are then getting the error below:
" The operation could not be performed because the OLE DB provider
'MSDAORA' was unable to begin a distributed transaction. (SQL Server
7391)OLE DB error trace [OLE/DB Provider 'MSDAORA'
ITransactionJoin::JoinTransaction returned 0x8000d048]. "
Question : has anyone ever run into that one, and might have an idea how
to fix that ?
- the Microsoft DTC service is running and configured
- added the following to ar.cfg : SQL-Server-Set-ANSI:Defaults: T (and
re-started the Remedy Service)
- ardb.cfg has the following entry: DB-Options:SQL Server
{
name:XACT_ABORT
value:ON
}
If anyone might have any suggestion or idea, that would be greatly
appreciated !
Next step would be to maybe create a local MS SQL server view. Tested a
little. Could create a Remedy view with that, but creating entries did
not work.
Thank you in advance !
Robert
Germany
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
