BusinessObjects Board

DA0005 and DMA0007 error in Infoview

building reports webintelligence legacy 1/2
#1

Hi everyone,

I’m experiencing a weird situation.

The BO version we’re using is 5.1.8 and WebI is version 2.

We used SQL Server 2000 before and everything worked fine. After upgrading to SQL Server 2005 and move the database to another server, reports can only be refreshed through BusinessObjects, but not through Infoview. The error message we got in Infoview is below:

Automation exception BusinessObjects server process raised an automation exception. (BOMGR0060) IDispatch error #109 Connection or SQL sentence error: (DA0005): [[Microsoft][ODBC SQL Server Driver]Client unable to establish connection1326] The following data providers have not been successfully refreshed: AR. (DMA0007): [] (server name)

We changed the DSN in Infoview server to redirect to the new server.

Let me express the situation in the simple way:

  1. reports worked fine both in BO and Infoview in SQL Server 2000 server (server A).

  2. after move the same database to a new server installed with SQL server 2005 (server B), reports work through BusinessObjects (full client), but not through Infoview (thin client) and got the above error message.

  3. we checked the DSN in Infoview server and it points to the new SQL Server 2005 server correctly.

I was wondering it’s a BO issue or database security issue?

Any help will be appreciated.

whuang138 (BOB member since 2002-08-29)

#2

By the way, I checked the help file of BO for the error codes and it doesn’t help me anything.

Thanks.

whuang138 (BOB member since 2002-08-29)

#3

I don’t know the answer to your question – but one thing you might check is the version of the middleware on your WebI server. Perhaps it’s an old version, and you might need a newer version with your new database version.

Anita Craig :us: (BOB member since 2002-06-17)

#4

Could solve this problem ?If yes, please tell me the way .becasue I am facing the same problem now.

Thanks

designer_star (BOB member since 2007-09-13)

#5

Hi,
There are two solutions for this

1.changing the sql server drivers on webi boxes to 2005 native client drivers
2.Modifying the prm file so that it will support ansi 92 format sql in all the webi boxes

remove the * or what ever following this statements

LEFT_OUTER=
RIGHT_OUTER=
and add ANSI_92 to the below line in the prm file
OUTERJOINS_GENERATION=ANSI_92

Hopes this will resolve your problem

regards,
Kumar

kumar446 :india: (BOB member since 2006-01-23)