Error when running crystal reports

[Former Member]

Hello,

We are running crystal reports in a windows 2003 32 bit server, using version 14.0.2.364.

After successfully running reports without issue, the user cannot do so anymore instead received the error below:

Logon Failed.

IMOO3: Specified driver could not be loaded due to system error   1114 (Oracle in Oraclient11g_home1).[ Database vendor code: 160 ]

if we reboot the server, user is able to run reports again however after a short while is suddently affected by this problem once more.

Other users who rdp into the server can run the same reports without incurring that error.

thanks.

[Former Member]

Hi Wasim,

Check below threads to resolve the issue.

Thanks,

Sastry

[DellSC]

Since this error has a "Database Vendor Code", that means that the error is coming from the Database - in this case, Oracle.  Doing a quick Google search on "oracle error 160" brings up a bunch of links to errors on ODBC connections.  Are you using an ODBC connection in your report?  If so, you could try a couple of things:

1.  Make sure that you're using Oracle's ODBC driver in your DSN, not the one from Microsoft.  Especially since you're on Windows Server 2003, odds are that this is an older driver that may not be completely supported in the newer version of Crystal.

2.  Update the report to use a "Native Oracle" connection.  This has always been a MUCH more reliable way to connect to Oracle from Crystal than using ODBC.

-Dell