Skip to Content

Crystal Reports 2016 Unknown Database Connector Error Oracle Server

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?

xle5l.png (111.9 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Oct 13, 2019 at 11:02 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.