FW: screen shots for connecting EHDS client from k

This is probably something simple, but I need a second set of eyes. I have a user trying to execute a URL on his remote workstation to a server that contains an Informix client say 11.5. It seems that he should be able to connect to the remote database via the client, but I'm missing something in the connection process. Is there something in the JDBC, URL, or onconfig that needs to be set? OS=AIX 6.1 <-- Client and Database servers IDS=11.50.UC3 I-Connect <-- Client server IDS =11.50.FC3 database instance <-- Database server Process: C:\\\\EHDSJavaScreens.v53b>c:\\\\jdk1.1.8\\\\bin\\\\java -mx22000000 -ms22000000 -oss8000000 -ss8000000 -classpath C:\\\\jdk1.1.8\\\\lib\\\\classes.zip;.\\\\lib\\\\support_tools.jar;.\\\\lib \\\\updatedriver.jar;.\\\\lib\\\\reports.jar;.\\\\lib\\\\manualroute.jar;.\\\\lib\\\\gateway. jar;.\\\\li b\\\\maintenance.jar;.\\\\lib\\\\games.jar;.\\\\lib\\\\swing\\\\swing.jar;.\\\\lib\\\\swing\\\\wind ows.jar; .\\\\lib\\\\capacityplanning.jar;.\\\\lib\\\\customer.jar;.\\\\lib\\\\splashscreens.jar;.\\\\ lib\\\\laun cher.jar;.\\\\lib\\\\tracking.jar;.\\\\lib\\\\jdbc.jar;.\\\\lib\\\\hdsbeans.jar;.\\\\lib\\\\send page.jar ;.\\\\lib\\\\config.jar;.\\\\lib\\\\menu.jar;.\\\\lib\\\\checkshipactualdate.jar;.\\\\lib\\\\mai lpstmstr .jar;.\\\\lib\\\\mailscreen.jar;.\\\\lib\\\\manage.jar;.\\\\lib\\\\mqlibs.jar;.\\\\lib\\\\drda.j ar;.\\\\lib \\\\ddreschedule.jar;.\\\\lib\\\\freightlaneupdate.jar;.\\\\lib\\\\splitter.jar;.\\\\lib\\\\a ddress.j ar;.\\\\lib\\\\coverassignment.jar;.\\\\lib\\\\HDSFlexRouting.jar;.\\\\etc -noverify Gateway.G atewayScreen kirkserver.com kirkserver.com useradm 155.155.0.0:0 ROUTE kirkserver USHOFLT111111 2009-10-14 14:32:37 - Gateway is starting up... starting Xmenu with 6 parms connect [kirkserver.com] XmenuDb.connectDb() - Connecting to the database... ERROR: failed to connect! URL=jdbc:informix-sqli://kirkserver.com:1551/db _user:informixserver=ifmx_web;user=useradm;password=home ERROR: Attempt to connect to database server (%s) failed. java.sql.SQLException: Attempt to connect to database server (%s) failed. at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java) at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java) at com.informix.jdbc.IfxDriver.connect(Compiled Code) at java.sql.DriverManager.getConnection(Compiled Code) at java.sql.DriverManager.getConnection(DriverManager.java:134) at Menu.XmenuDb.connectDb(XmenuDb.java) at Menu.XmenuDb.selectPrintComand(Compiled Code) at Menu.XmenuDb.initialize(XmenuDb.java) at Menu.Xmenu.initialize(Xmenu.java) at Menu.Xmenu.<init>(Xmenu.java) at Gateway.GatewayScreen.main(GatewayScreen.java) connect [kirkserver.com] connect [kirkserver.com] error initializing Exception occurred in main() of com.sun.java.swing.JFrame java.lang.NullPointerException: at Menu.XmenuDb.closeDb(XmenuDb.java) at Menu.XmenuDb.initialize(XmenuDb.java) at Menu.Xmenu.initialize(Xmenu.java) at Menu.Xmenu.<init>(Xmenu.java) at Gateway.GatewayScreen.main(GatewayScreen.java) SQLHOSTS on client server: ifmx_web onsoctcp databaseserver.com 1551 Thanks, ******************************************************************* Ernie Knox IT Database Administrator Specialist Sears Holdings 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry: 2244650553@messaging.sprintpcs.com <mailto:2244650553@messaging.sprintpcs.com> Page via Skytel: 2244650553@sprint.skytel.com <mailto:2244650553@sprint.skytel.com> Informix or MySQL Primary: 9110210@skytel.com <mailto:9110210@skytel.com> Informix or MySQL Secondary: 7276872@skytel.com <mailto:7276872@skytel.com> " Yes we can make a Change! " " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! " " Lets not forget - GO Pistons and Red Wings! " GSU *******************************************************************

Can I execute a JDBC URL via a remote workstation thru an Informix client to a remote database server? I'm getting " ERROR: Attempt to connect to database server (%s) failed." Is there something in the JDBC, URL, or onconfig that needs to be set? OS=AIX 6.1 <-- Client and Database servers IDS=11.50.UC3 I-Connect <-- Client server IDS=11.50.FC3 database instance <-- Database server SQLHOSTS on client server: ifmx_web onsoctcp databaseserver.com 1551 Currently the URL is accessing the database server via synonyms on the client server. I would just like them to use I-connect from the client server to the database server. Thanks, ******************************************************************* Ernie Knox IT Database Administrator Specialist Sears Holdings 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry: 2244650553@messaging.sprintpcs.com Page via Skytel: 2244650553@sprint.skytel.com Informix or MySQL Primary: 9110210@skytel.com Informix or MySQL Secondary: 7276872@skytel.com " Yes we can make a Change! " " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! " " Lets not forget - GO Pistons and Red Wings! " GSU ******************************************************************* -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Knox, Ernest Sent: Wednesday, October 14, 2009 2:54 PM To: ids@iiug.org Subject: FW: screen shots for connecting EHDS client fr.... [17557] This is probably something simple, but I need a second set of eyes. I have a user trying to execute a URL on his remote workstation to a server that contains an Informix client say 11.5. It seems that he should be able to connect to the remote database via the client, but I'm missing something in the connection process. Is there something in the JDBC, URL, or onconfig that needs to be set? OS=AIX 6.1 <-- Client and Database servers IDS=11.50.UC3 I-Connect <-- Client server IDS =11.50.FC3 database instance <-- Database server Process: C:\\\\EHDSJavaScreens.v53b>c:\\\\jdk1.1.8\\\\bin\\\\java -mx22000000 -ms22000000 -oss8000000 -ss8000000 -classpath C:\\\\jdk1.1.8\\\\lib\\\\classes.zip;.\\\\lib\\\\support_tools.jar;.\\\\lib \\\\updatedriver.jar;.\\\\lib\\\\reports.jar;.\\\\lib\\\\manualroute.jar;.\\\\lib\\\\gateway. jar;.\\\\li b\\\\maintenance.jar;.\\\\lib\\\\games.jar;.\\\\lib\\\\swing\\\\swing.jar;.\\\\lib\\\\swing\\\\wind ows.jar; ..\\\\lib\\\\capacityplanning.jar;.\\\\lib\\\\customer.jar;.\\\\lib\\\\splashscreens.jar;. \\\\ lib\\\\laun cher.jar;.\\\\lib\\\\tracking.jar;.\\\\lib\\\\jdbc.jar;.\\\\lib\\\\hdsbeans.jar;.\\\\lib\\\\send page.jar ;.\\\\lib\\\\config.jar;.\\\\lib\\\\menu.jar;.\\\\lib\\\\checkshipactualdate.jar;.\\\\lib\\\\mai lpstmstr ..jar;.\\\\lib\\\\mailscreen.jar;.\\\\lib\\\\manage.jar;.\\\\lib\\\\mqlibs.jar;.\\\\lib\\\\drda. j ar;.\\\\lib \\\\ddreschedule.jar;.\\\\lib\\\\freightlaneupdate.jar;.\\\\lib\\\\splitter.jar;.\\\\lib\\\\a ddress.j ar;.\\\\lib\\\\coverassignment.jar;.\\\\lib\\\\HDSFlexRouting.jar;.\\\\etc -noverify Gateway.G atewayScreen kirkserver.com kirkserver.com useradm 155.155.0.0:0 ROUTE kirkserver USHOFLT111111 2009-10-14 14:32:37 - Gateway is starting up... starting Xmenu with 6 parms connect [kirkserver.com] XmenuDb.connectDb() - Connecting to the database... ERROR: failed to connect! URL=jdbc:informix-sqli://kirkserver.com:1551/db _user:informixserver=ifmx_web;user=useradm;password=home ERROR: Attempt to connect to database server (%s) failed. java.sql.SQLException: Attempt to connect to database server (%s) failed. at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java) at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java) at com.informix.jdbc.IfxDriver.connect(Compiled Code) at java.sql.DriverManager.getConnection(Compiled Code) at java.sql.DriverManager.getConnection(DriverManager.java:134) at Menu.XmenuDb.connectDb(XmenuDb.java) at Menu.XmenuDb.selectPrintComand(Compiled Code) at Menu.XmenuDb.initialize(XmenuDb.java) at Menu.Xmenu.initialize(Xmenu.java) at Menu.Xmenu.<init>(Xmenu.java) at Gateway.GatewayScreen.main(GatewayScreen.java) connect [kirkserver.com] connect [kirkserver.com] error initializing Exception occurred in main() of com.sun.java.swing.JFrame java.lang.NullPointerException: at Menu.XmenuDb.closeDb(XmenuDb.java) at Menu.XmenuDb.initialize(XmenuDb.java) at Menu.Xmenu.initialize(Xmenu.java) at Menu.Xmenu.<init>(Xmenu.java) at Gateway.GatewayScreen.main(GatewayScreen.java) SQLHOSTS on client server: ifmx_web onsoctcp databaseserver.com 1551 Thanks, ******************************************************************* Ernie Knox IT Database Administrator Specialist Sears Holdings 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry: 2244650553@messaging.sprintpcs.com <mailto:2244650553@messaging.sprintpcs.com> Page via Skytel: 2244650553@sprint.skytel.com <mailto:2244650553@sprint.skytel.com> Informix or MySQL Primary: 9110210@skytel.com <mailto:9110210@skytel.com> Informix or MySQL Secondary: 7276872@skytel.com <mailto:7276872@skytel.com> " Yes we can make a Change! " " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! " " Lets not forget - GO Pistons and Red Wings! " GSU ******************************************************************* ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.