Skip to Content
0
Former Member
Feb 07, 2012 at 12:56 PM

CR2011, BO 4.0, connection to SQL server via ODBC

42 Views

Hi,

when developing reports locally using Crystal Reports 2011 I dont' have problems connecting to our MS SQL Server using ODBC. However, as soon as the report is exported to our BO Edge 4.0 SP2 server I get this error message when viewing the report in Launchpad (or CMC) and refreshing it:

"The viewer could not process an event. Failed to open the connection. CRWEB00000119"

In CMC I then entered the credentials for this report but I still get the error message.

So I created a new ODBC connection on the BO server pointing to the SQL server - but I can't specify this ODBC connection in CMC.

Any hints?

Thanks!