Hello everyone having issue with Boe crystal report 2013 report

[Former Member]

The report works and run fine on the local machine, but when migrating report from crystal report design tool. to the BOE preprod environment. getting the following error:

The viewer could not process an event, failed to open connection, Database vendor code:4060 error.  [CRWEB00000119] ERROR . when trying to view the report.

We check the ODBC connection for 32bits the connection is successful. from local machine and from Server machine(environment)

Can some one please help resolve this issue.

Thanks

Kim Roll

[abhilash_kumar · Accepted solution]

Hi Kim,

Any errors with the text 'Database Vendor Code' suggest an issue with the database driver, connectivity between the database or anything related specifically to the database being used.

I searched for the error and I guess you're connecting to a SQL Server database?

Make sure you're using the SQL Server Native Client 10.0 or 11.0 driver.

-Abhilash

[DellSC · Accepted solution]

After publishing a report, you also need to go to that report in the CMC, right-click on the report, select "Database Configuration", and set the password for the report.  If you expect to run the report interactively and not just on a schedule, you'll also change the "When viewing and scheduling report" option to "Use same database logon as when report is run".

-Dell

[Former Member · Accepted solution]

Hi Abhilash,

That worked using the SQL Server Native Client 10.0 or 11.0 driver to resolve the issue Thank you for your Help

[raghavendra_hullur]

Hi,

Also check below links (though those are related to CR 2011) whether will help to resolve the issue.

This error seems to be related to Database client version (32 bit and 64 bit):

Thanks,

Raghavendra