Hello all,
We've 2 machines (aka: server_1, server_2) on the same LAN.
server_1)
- OS: SCO OpenServer 5.0.4Eb,
- DBMS: Informix SE 5.10.UD1
- database name: db_example
- IP address: 192.168.0.1
server_2)
- OS: Debian GNU/Linux 3.0r2 (Woody)
- Java: j2sdk1.4.1_02
- JDBC: IBM's 2.21 JC5
Our problem is in establishing a connection between these 2 environments on these 2 machines.
Inside a JVM in server_2, we run a simple java class for testing purposes and only get a succesful driver loading with
--------------------------------------------------------
Class.forName("com.informix.jdbc.IfxDriver");
--------------------------------------------------------
but we don't get any connection with
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
String url = "jdbc:informix-sqli://192.168.0.1:1533/db_example:INFORMIXSERVER=ifxserver;user=any;passw ord=guess;DBPATH=/u/dbs/;SQLH_FILE=/usr/informix/etc/sqlhosts;USEV5SERVER=1";
Connection con = null;
con = DriverManager.getConnection(url);
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
We don't understand the meaning of the fields in this file at server_1:
$INFORMIXDIR/etc/sqlhosts
db_example setlitcp server_1 ifxserver
Neither we don't encounter any file named sqlexecd at server_1:
$INFORMIXDIR/lib/
Could anyone explain what we need to establish a connection?
Thanks in advance.