Hello, I got the IP address and port number and put them into my datasource in place of the server name in the JDBC URL, in this format:
jdbc:ibm-u2://<IP address>:<port number>//datatel/coll18/production/apphome;dbmstype=UNIDATA; I am still getting the same error. perhaps my syntax is wrong? thanks much, Julie ------------------------ >Julie, >i don't know your DB, but can you define , in the cf admin, the datasource >as a network one, pointing to it with its server ip and port >(http://aaa.bbb.ccc.ddd:1234)? >regards > >-----Messaggio originale----- >Da: Julie Davenport [mailto:[email protected]] >Inviato: mercoledì 31 marzo 2010 20.41 >A: cf-server >Oggetto: Cannot connect to database from windows server > > >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=UNIDA >TA; >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 insists 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-server/message.cfm/messageid:6870 Subscription: http://www.houseoffusion.com/groups/cf-server/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-server/unsubscribe.cfm
