Re: Informix and JDBC versions compatibility

1. Your Informix Server is accepting connections only through shared memory (Look at your line in sqlhosts with the protocol type onipcshm) 2. Add the following to your onconfig file: DBSERVERALIASES dbserver_ip NETTYPE tlitcp,1,,NET3. Add the following line to your sqlhosts file: dbserver_ip ontlitcp agvs sqlturbo4. Add the line sqlturbo 1526/tcp to your /etc/services file. Now, the port in the connection string should be 1526. 5. Restart the Informix server running the commands (as informix or root): onmode -u onmode -k oninit I don't know for sure if the tlitcp protocol is supported on your platform. To find the supported protocols you have to look in the release notes somewhere in: $INFORMIXDIR/release/en_us/0333/IDS_7.3 There should be a line stating the supported protocols like: TLI using IPX/SPX TLI using TCP/IP At least this is in my release notes. If your port doesn't support the TLI protocol, just change "tlitcp" to "soctcp" and "ontlitcp" to "onsoctcp". To test that your server is listening to the new connection you can: 1. set the INFORMIXSERVER env. variable to dbserver_ip 2. run the dbaccess and try to connect to any database. Best Regards, Octav On Fri, Feb 12, 1999 at 02:02:23PM +0100, Igor A. Walter wrote: > Thank you very much for your help but since I'm a beggining on Informix and > this is a production database we need more details on how to do that... > > Octav Chiriac wrote: > > > Hello, > > > > I think you just need to configure a soctcp or tlitcp > > connection in your onconfig file and sqlhosts file. > > > > 1. Set a alias to your server in DBSERVERALIASES parameter and > > add a NETTYPE entry with tlitcp(or soctcp) protocol type (if you > > haven't one there) in onconfig file. > > Well, I have a DBSERVERALIASES entry empty. So, I should put dbserver_tcp > there, right? > DBSERVERNAME dbserver_tcp # Name of default database server > DBSERVERALIASES dbserver_tcp # List of alternate> dbservernames > > I don't have a NETTYPE entry, what should I do, tlitcp or soctcp? The only > entry that gives me one of these is on sym.out file: > sym.out:0x1034f95c soctcp_sighand > sym.out:0x1034fac0 soctcp_siginit > sym.out:0x1034faf8 soctcp_setopts > > Does it mean we have soctcp? We don't have any entry of these in > /etc/protocols, do we need one? > > > > > > > > 2. Add the server alias in your sqlhosts file with the protocol > > ontlitcp(or onsoctcp). > > How should I do that, the only line I have is: > dbserver_tcp onipcshm agvs xyz> > Should I add just the following line? > dbserver_tcp onsoctcp agvs xyz> > > > 3. Restart the OnLine server. > > The only way I know of doing that on AIX is shutdown -r. Any other > suggestion? > > > Hope it helps, Octav > > Yes, a lot. Thank you and sorry for the newsbie questions, > > Igor > (Italy) > > > > > > > Does anybody know if the Informix On Line Database version 7.12.UC1 > > > supports Informix JDBC driver 1.22.JC1? Which daemons should be running > > > on AIX to listen to JDBC connections and on which port? > > > > > > uname -a gives me: > > > AIX host 2 3 002124004800 > > > > > -- > (opinions stated are not necessarily those of my employer) > > -- 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