0

I need to connect to Oracle11g database using PowerBI (64-bit) and crystal reports xi (32-bit). I installed both versions of Oracle client following the instruction provided in this thread Installing Oracle 32-bit Client on Windows Server Already Running 64-bit Oracle Database Server

PowerBI is working well and Crystal reports xi can't connect to Oracle database. The error message is "unknown database connector error".

Since the crystal reports xi is a 32-bit version, I checked ODBC data source administrator (32-bit). It is unable to connect SQLState= IM004, see the screenshot below. Is that the reason Crystal reports not connecting? IM004

I also noticed the trusted_connection is false in crystal reports (see screenshot), not sure if that is another problem.

TRUST

Any idea of why Crystal Reports can't connect to the Oracle database?

Community
  • 1
  • 1
Kasu
  • 39
  • 1
  • 7
  • When you install the Oracle Client did you also install the ODBC drivers? (32 and 64 bit) – Wernfried Domscheit May 11 '18 at 17:09
  • Try to add DSN as "System DSN". As far as I know "User DSN" does not distinct between 32 and 64 bit. – Wernfried Domscheit May 11 '18 at 17:10
  • Yes, I have both 32 and 64 bit ODBC drivers. I can't add system DSN in the 32 bit odbc data source administrator. I added system DSN in the 64 bit odbc data source administrator. Stil getting "unknow database connector error" in 32 bit Crystal Reports when trying to refresh reports. – Kasu Jun 07 '18 at 21:42

0 Answers0