If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > JDBC connection to an Informix SE v5

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 03-29-04, 18:31
josep josep is offline
Registered User
 
Join Date: Mar 2004
Location: Barcelona (Spain)
Posts: 1
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 18:38.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On