Skip to Content
0
Oct 14, 2019 at 02:33 PM

unable to connect to Oracle drivers from Crystal Report's Database Expert

425 Views

I'm trying to migrate a small .NET application (VS2008, Crystal Report 10, OS Win7 32-bit).
The application has got 2 reports that use some data of an oracle database version 11g Release 2 (11.2.0.1).

When I upgrade the application (VS2019Pro, latest Crystal Report (CR13SP25), OS Win10 64-bit) the application itself runs as expected and the 2 crystal reports show the proper data. It's only when I open Database Expert in crystal report designer and try to access the Oracle connection, I receive an error when trying to pull the list of tables of that connection.

I've tried all 3 possible Oracle connections and all of them give a (different) error:
(1) Microsoft OLE DB Provider for Oracle (MSDAORA): "ADO error code: 0x80004005 - Error while trying to retrieve text for error ORA-01019"
(2) OLE DB for Oracle (OraOLEDB.Oracle): "ADO error code: 0x8000ffff"
(3) Oracle Server (crdb oracle): "Unknown error in database connector"

Now the weird part is that sometimes I do have access to those 3 connections in Database Expert, meaning the list of tables becomes visible. This happens very rarely and doesn't last for a long time. I've also noticed that when this happens I can access all 3 different connections, so it's "all or nothing".

This behaviour is the same when I create a new solution and add a new crystal report or when I use Visual Studio 2017 Professional instead of 2019.

Anybody has an idea on how to fix this kind of behaviour? Thanks in advance!