Crystal Reports: ORA-12170: TNS:Connect timeout occurred [Database Vendor Code: 12170]

In the SAP Crystal Reports editor, you open the Database Expert and trying to view/edit the command, after you have entered your database login credentials you received the following error.

This can be caused by several issues. The following are some of the ways to fix it.

1. ping the database machine to make sure you can access that machine.

2.  Check if the database host of your Oracle Instant Client is using the correct IP address. If you are accessing the database on a remote machine, localhost or 127.0.0.1 will not work. 

       a. Open your Control Panel.

       b. Open the Administrative Tools window.

       c. Right-click on the ODBC Data Sources and open it.

       d. Select the System DSN tab to look for the Driver used by your data source. 

        e. Select the Drivers tab and locate your driver.

       f. Open a file explorer, go to Program Files (x86)\Oracle Instant Client\<your driver>.

       g. Open the tnsnames.ora file in a text editor, change the HOST = <the correct database IP address> 

3. Make sure the firewall is not blocking the connection.

-----------------------------------------------------------------------------------------------------------------

If you have ever asked yourself these questions, this is the book for you. What is the meaning of life? Why do people suffer? What is in control of my life? Why is life the way it is? How can I stop suffering and be happy? How can I have a successful life? How can I have a life I like to have? How can I be the person I like to be? How can I be wiser and smarter? How can I have good and harmonious relations with others? Why do people meditate to achieve enlightenment? What is the true meaning of spiritual practice? Why all beings are one? Read the book for free here.