Re: Informix and JDBC versions compatibility => can't connect

On Fri, Feb 12, 1999 at 12:50:32PM +0100, Igor A. Walter wrote: > I don't know Informix very well and we have a version hardly documented. > > I can identify the following problems: > -all docs refer to Informix Dynamic Server 7.x, Informix SE 5.x or Informix > On line Server 5.x. We have Informix On Line server 7.x, what should it > correspond to? Is it an unsupported version of Informix ? Docs for Informix Dynamic Server 7.x > - I guess we should have a daemon listening to a specific port (in examples > it's always 1533) in order to connect with JDBC. The doc shows how to launch > a lib/sqlexecd daemon but we don't have it. We have lib/sqlrm, is it the > equivalent? [I hope sqlrm stands for remote sql and not rm sql. :) ] Or > should we launch bin/sqldemo? > > Below, the ouptut of ps-ef on AIX 3.2.5 and the Java test error messages > (It's JDBC driver 1.22JC1, we have just downloaded the version 1.40). > > Thanks, Igor > The "daemon" is one of oninit processes. You needn't any more daemons to run, BUT You have to configure a listener thread for TCP protocol. To do this you have to: 1. Add in your $INFORMIXDIR/etc/$ONCONFIG file a server alias to your DBSERVERALIASES parameter. 2. Add in the same file a NETTYPE entry, wich might look like: NETTYPE tlitcp,1,,NET 3. Make a entry in your $INFORMIXDIR/etc/sqlhosts file for the server alias (see p.1). This entry should look like: server_alias ontlitcp hostname servicename Where hostname is the host your Informix Server is running on and servicename should be the name of a entry in your /etc/services file. This entry should be like: servicename port_number/tcp port_number is the port number that you will specify in your connection string (you could set it to 1533 if you like). 4. Restart the Informix server. You can check that Informix Server is listening to the specified port using "netstat -a" command. Hope this help, Octav -- Octav Chiriac Phone: (373) 2 21 20 96 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 24 00 83 Moldova, Republic of mailto:com@netinfo-moldova.com