Linked Server Question

[Former Member]

I'm trying to create a universe in a Sql Server 2000 DB, one view in my universe depends on data retrieved by a linked server. When I run my query in Web Intelligence I get this error:

A database error occured. The database error text is: [Microsoft OLE DB Provider for SQL Server] : OLE DB error trace [OLE/DB Provider 'MSDAORA' ITransactionJoin::JoinTransaction returned 0x8004d01b].. (WIS 10901)

I couldn't find any info on the internet about it.

[Former Member · Accepted solution]

Hi Paolo,

Could you please try testing the issue with an ODBC connection.

I found this Microsoft Article regading distributed transactions. It's regarding the error message you were getting. Let me know if this applies to your situation.

http://support.microsoft.com/kb/816701

Regards,

Ganesh