Re: JDBC driver and connectivity problems

Steve Pringle wrote: > I'm new to Informix. I simply want to connect to an Informix db server > (on a remote Unix system) from NT using a java app and the Informix > level 2 jdbc driver. I can't seem even get the ILogin demo to work. It's > complaining about error -931 - (see below) > > Cannot locate servicename service/tcp service in /etc/services. > > The service servicename is not listed in the network configuration file > /etc/services (UNIX) or (DOS). Check the $INFORMIXDIR/etc/sqlhosts file, > and check that the service name for the desired server is correct. If > so, contact your network administrator to find out why the service is > not known. If you are using INFORMIX-OnLine for NetWare, check the file > on the client for the required entries. > > Any help to get me past this problem would be greatly appreciated. > > thanks, > Steve Pringle For some reason, the client install does not update your services file (the server install does) Under WindowsNT, you can find the services file in %SystemRoot%\\system32\\drivers\\etc\\ add the following lines to the end of the file. turbo 1526/tcp # INFORMIX-OnLine Workgroup Server srv_agent 1530/tcp # INFORMIX-OnLine Server Agent you might need to change the port numbers to match the services file on the Unix Server. Make sure that the informix specific environment variables are set correctly when you run SetNet. Those environment variables DO NOT show up in the environment tab under System Properties and are separate for each user account under NT! ~Scott