jdbc NT-Linux connection

Posted in 1999

Topics: Connectivity: ODBC / JDBC / .NET, Security, Permissions & Auditing, Networking & sqlhosts Configuration, Platform-Specific Issues, Java & JDBC Development

dhagen1065@my-dejanews.com — Tue, 25 May 1999 10:55:19 GMT — source: Informix-list mailing list archive (1991-1998)

Hi, I try to connect a java client program from NT4 (SP4) to Informix-SE (7.24.UC5) on Linux (SuSE 6.1) I downloaded the JDBC-20 driver from Informix my connect string is: jdbc:informix-sqli://b3pc230:1536//database/demo/stores7:INFORMIXSERVER= demo_se;user=test;password=test in sqlhosts on the linux pc: demo_se sesoctcp b3pc230 sqlexecinf there are entries in 'services' and 'hosts' on both machines, ping works, sqlexecd is running I get the following error: -------- java.sql.SQLException: Attempt to connect to database server (com.informix.asf.IfxASFException: [demo_se]Java socket exception encountered:java.net.ConnectException: Connection refused: no further information) failed. at java.lang.reflect.Constructor.newInstance(Native Method) at com.informix.jdbc.IfxDriver.connect(Compiled Code) at java.sql.DriverManager.getConnection(Compiled Code) at java.sql.DriverManager.getConnection(DriverManager.java:159) at Play.main(Play.java:63) Attempt to connect to database server (com.informix.asf.IfxASFException: [demo_se] Java socket exception encountered:java.net.ConnectException: Connection refused: no further information) failed. -------- and there is no logging information from sqlexecd :-( I used IPTraf to show the ip traffic: Source Destination Packets Bytes Flags Iface [ip]:1382 [ip]:1536 1 44 S--- eth0 [ip]:1536 [ip]:1382 1 40 RESET eth0 what's wrong? Thanks in advance from Hagen --== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.---

↪ replying to dhagen1065@my-dejanews.com

Edward A. Geddis — Thu, 10 Jun 1999 13:41:17 -0400 — source: Informix-list mailing list archive (1991-1998)

Hagen, If you want a Java driver that actually connects to Informix, as well as other major database platforms, consider OpenLink: http://www.openlinksw.com -- Thanks, Edward A. Geddis Technical Support Consultant OpenLink Software http://www.openlinksw.com Making Technology Work for You <dhagen1065@my-dejanews.com> wrote in message news:7idvin$k99$1@nnrp1.deja.com... > Hi, > > I try to connect a java client program from NT4 (SP4) to Informix-SE > (7.24.UC5) on Linux (SuSE 6.1) > I downloaded the JDBC-20 driver from Informix > > my connect string is: > jdbc:informix-sqli://b3pc230:1536//database/demo/stores7:INFORMIXSERVER= > demo_se;user=test;password=test > > in sqlhosts on the linux pc: > demo_se sesoctcp b3pc230 sqlexecinf > > there are entries in 'services' and 'hosts' on both machines, ping > works, > sqlexecd is running > > I get the following error: > > -------- > java.sql.SQLException: > Attempt to connect to database server (com.informix.asf.IfxASFException: > [demo_se]Java socket exception encountered:java.net.ConnectException: > Connection refused: no further information) failed. > at java.lang.reflect.Constructor.newInstance(Native Method) > at com.informix.jdbc.IfxDriver.connect(Compiled Code) > at java.sql.DriverManager.getConnection(Compiled Code) > at java.sql.DriverManager.getConnection(DriverManager.java:159) > at Play.main(Play.java:63) > Attempt to connect to database server (com.informix.asf.IfxASFException: > [demo_se] > Java socket exception encountered:java.net.ConnectException: Connection > refused: > no further information) failed. > -------- > > and there is no logging information from sqlexecd :-( > > > I used IPTraf to show the ip traffic: > Source Destination Packets Bytes Flags Iface > [ip]:1382 [ip]:1536 1 44 S--- eth0 > [ip]:1536 [ip]:1382 1 40 RESET eth0 > > > what's wrong? > > Thanks in advance from > Hagen > > > --== Sent via Deja.com http://www.deja.com/ ==-- > ---Share what you know. Learn what you don't.---

Glossary

sqlhosts