Skip to Content
0

SAP Crystal Reports Logon failed

Dec 02, 2016 at 08:29 PM

528

avatar image
Former Member

Using SAP Crystal Reports 2013 Support Pack 8

Version 14.1.8.2060 CR Developer

Oracle Driver ODTwith ODAC121024 Using OLEDB connection

Windows 8.1

Gave me the following error when I attempt to connect to the database server after opening a saved report. Note: I can create a new connection and connect just fine, it is only on reopening a saved report and refreshing the report that it fails with the following error.

Login failed.

Details: ADO Error Code: 0x80004005

Source: Microsoft OLE DB Provider for Oracle

Description: Error while trying to retrieve text for error ORA-01019

Native Error: 1019[Database Vendor Code: 1019]

Please help resolve.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Vitaly Izmaylov
Dec 02, 2016 at 08:55 PM
0

Try to "Set Datasource Location" for the saved report. You can recreate connection and update the report.

While in "Set Datasource Location" dialog you can compare the properties of the original connection and the properties of the new connection. Saved report may be pointing to a driver that does not exist anymore.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 06, 2016 at 08:27 AM
0

Nice thought but you shouldn't have to do this every time you open and save the report. It makes it impossible to use in production. This is not the solution. The error is occurring right after creating the report from scratch with a new connection, save the report, close crystal reports, reopen and refresh. Then up comes the error message.

Share
10 |10000 characters needed characters left characters exceeded
Don Williams
Dec 05, 2016 at 11:48 PM
0

Hi David,

Microsoft's Oracle driver only supports Oracle 7 and will not work very well with newer versions.

Install Oracle's Client and use that one.

Why it works one time I don't know... but it should not work at all. Likely some filtering happening.

Don

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 17 at 10:01 PM
0

me too... "database logon failed" error come for me. please help me solve this problem?

Share
10 |10000 characters needed characters left characters exceeded