1196474 - Error: "Failed to open the connection / Io exception: The Network Adapter could not establish the connection (Database Vendor Code 17002)."

Symptom

When trying to open a JDBC connection to an Oracle 10g database in Crystal Reports XI, the following error message appears:

"Failed to open the connection / Io exception: The Network Adapter could not establish the connection (Database Vendor Code 17002)."

Reproducing the Issue

To determine if this is the cause, perform the following steps:

Click Start > Run
Type "cmd".
Click OK. The command window appears.
Try to ping your Oracle server using its host name. For example:
ping oracleserver.system.net
Now try to ping the same server using its IP address. For example:
ping 123.45.67.89

If the first command results in a message such as "Request timed out" or "Ping request could not find host", but the second command is successful, then the problem is the failure of your network to resolve the host name.

Cause

This error message occurs if your network is unable to resolve the name of your Oracle host.

Resolution

To work around this behavior, perform the following steps:

Make a backup copy of your CRConfig.xml file.
Edit your CRConfig.xml file.
If you have configured the file as outlined in knowledge base article 1218714, it should contain a line such as:
<JDBCURL>jdbc:oracle:thin:@hostname:1521:hostsid</JDBCURL>
Edit this line by replacing "hostname" with the Oracle host's IP address. For example:
<JDBCURL>jdbc:oracle:thin:@123.45.67.89:1521:hostsid</JDBCURL>

For a permanent solution, ask your network administrator to fix the network problem of not being able to resolve the host name. Once the network can resolve the host name, you can restore the CRConfig.xml so that the <JDBCURL> line contains the host name instead of the IP address.

Keywords

crxi , 2098033 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

SAP Crystal Reports XI ; SAP Crystal Reports XI R2