Skip to main content
Inspiring
March 31, 2010
Question

Timed out trying to establish connection

  • March 31, 2010
  • 1 reply
  • 6151 views

Hello,


I need to access a Unidata database residing on an AIX unix server using CF from a Windows server.  I currently access this same db/server from CF on my linux server with no problem. I set up the new datasource in CF Admin on the windows server using the same parameters I use on my linux server:

JDBC URL =
jdbc:ibm-u2://<servername>//datatel/coll18/production/apphome;dbmstype=UNIDATA;
DRIVER CLASS = com.ibm.u2.jdbc.UniJDBCDriver
DRIVER NAME = UniJDBC

and put in the same username and password that I use from the Linux. The datasource will not verify, I get this error:

Connection verification failed for data source: hb2504_colleague
java.sql.SQLException: Timed out trying to establish connection
The root cause was that: java.sql.SQLException: Timed out trying to establish connection

The network administrator says that the windows server and AIX server ARE able to communicate and there is no firewall in the way.  If this is not a network issue, is there any other cause?  Do I need to change the parameters in the
datasource since it is a windows server?  (the unijdbc driver was installed on the windows server and then CF service was restarted).

thanks much for any help,
Julie
    This topic has been closed for replies.

    1 reply

    Owainnorth
    Inspiring
    April 1, 2010

    If you know what port Unidata databases run on, load up a command line on the CF box and type

    telnet <servername> <portnumber>

    If you get a connection refused, then there's something blocking the connection on the network. If you get a clear black console, then it's a CF issue.

    What software is your server running? If it's Server 08 then it's almost certainly Windows Firewall.

    O.

    April 1, 2010

    If it's Server 2008, don't foget to install the Telnet feature, before first trying to telnet.

    Inspiring
    April 1, 2010

    It is Server 2003 enterprise edition, service pack 2