I am connecting to sql server 2000, (ODBC connection) using a view that utilizes linked server to hit a 2005 server. Everything works fine in designer, and I can parse my fields. When I go to run a report from the same universe I get:
“Exception: DBD, [Microsoft][ODBC SQL Server][SQL Server]The operation could not be performed because the OLE DB provider ‘SQLOLEDB’ was unable to begin a distributed transation. State: 42000”
I can run other reports out of this universe, as long as it does not touch the 2005 view. I’ve tested my odbc connection with other products, and it works fine. Why business objects? Was thinking that it was msdtc settings, but looks like the issues is specific to business objects.
HI,
have a look at this post.what driver are you using for odbc connection between the linked server and 2005 server?is it the same as of that of sql server 2000?
Operating System for 2000: Windows 2000 SP4
Operating System for 2005: windows 2003 enterprise sp1
Version of odbc and/or oledb on 2000: 2.81.1117.0 (mdac 2.8 SP1)
Version of odbc and/or oledb utilized by linked server: Sql server odbc driver 2000.85.1117 (on 2000)
Version of odbc and/or oledb on 2005 server: 2.82.1830.0 (MDAC 2.8 SP2)
(BOB member since 2007-02-07)