Crystal Reports 2016 Unknown Database Connector Error Oracle Server

[former_member635222]

I get an “Unknown Database Connector Error” when I try to create a new Oracle Server connection in Crystal Reports 2016 on a Windows 10 machine. This is a new installation. I was previously using CR2016 on a Windows 7 machine with no issues. Here are the details of the installation:

• Both the Oracle 11g 32-bit and 64-bit clients are installed in different directory trees on the machine.
• The PATH system environment variable has the 32-bit path listed right after the 64-bit path and I’ve confirmed that there are no typos.
• There is a TNS_ADMIN string value under HKEY_LOCAL_MACHINE\SOFTWARE\Oracle that has the path for the 32-bit NETWORK\ADMIN folder and there are no typos.
• The TNSNAMES.ora file is in the 32-bit NETWORK\ADMIN folder and I’m using the correct SERVICE_NAME, in the proper case, at the Service prompt for the new Oracle Server connection.

I searched the community for existing answers, but I didn't find one. Here’s a screen shot of the registry entries. Are the KEY_OraCient11g64_home1 entries causing the problem?

[DellSC]

Crystal is 32-bit software, so you need to have the 32-bit Oracle Client installed in order for Crystal to connect to Oracle. From your screenshot, it looks like you might have just the 64-bit client. They can be installed side-by-side without any issues.

-dell

[former_member635222]

Thanks for responding to my question. I did have the 11g 32-bit Oracle Client installed. I found out the day after I posted the problem that we were using an Oracle 12c database. After I installed the 12c 32-bit Oracle Client it solved the problem.