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. > Somewhere in the NT file system there is a file called SERVICES. On Win95, it is in C:\\WINDOWS. You need to find out from your DBA or Unix Sys Admin what is the service number for the Informix db server. Put an entry in the NT SERVICES file for that service like: ifmx 1923/tcp # this is the service for my database server This must match the entry in the /etc/services file on the Unix DB box. Run SETNET32 as well and create proper entries for your server and host. This should have been covered in the I-Connect setup. Reboot and go. This will not necessarily make JDBC work. That must be properly configured as well. But if your only problem is not finding the service, then you should be all right. > thanks, > Steve Pringle Hope it helps. -- Matt Reprogle IS Engineer, Delphi Delco Electronics Systems phone:(765)451-9651 FAX: (765)451-8230 mcreprog@ictest.delcoelect.com