Kbase P182800: JDBC connection string fails after making several changes including servers. Progress versions and
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
18/02/2011 |
|
Status: Unverified
SYMPTOM(s):
JDBC connection string fails after making several changes including servers. Progress versions and OS platforms.
JDBC connection from Progress database on Solaris box to the Oracle database on a Windows box is currently working.
Test connect from the Progress database on a Linux RH ENT 5 OS to an Oracle database on a different Windows box but using that same JDBC connection string with some modification fails.
Message: The TCP/IP connection to the host #####.##.###, port 1433 has failed. Error: "Connection refused. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".
Error: Unable to connect to the Target DB
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
Making use of third party JAVA application "Dispatcher" to move data via a JDBC connection.
CAUSE:
The IP address in the JDBC connection string was incorrect.
FIX:
Change the IP address in the JDBC connection string to the correct IP address.