Results 1 to 1 of 1
  1. #1
    Join Date
    Mar 2004
    Location
    Barcelona (Spain)
    Posts
    1

    Unanswered: JDBC connection to an Informix SE v5

    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.
    Last edited by josep; 03-29-04 at 19:38.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •