Timed out trying to establish connection

[jdavenport11]

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 = UniJDBCand 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 connectionThe 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

[Owainnorth]

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.

[Guest]

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

[jdavenport11]

It is Server 2003 enterprise edition, service pack 2

[jdavenport11]

thank you, this was helpful.  i got the port number and did the telnet and got the empty black screen, so then as you say it must be a CF issue??  do you mean something is missing on the coldfusion server?  we did have trouble with the driver first but got past that error and now just get the timed out error.

[jdavenport11]

FYI, we eventually gave up on JDBC and are using ODBC connection instead, and it is working.