Re: Paranoia and Secrecy SQL -932 error

The getservbyname I believe is a function that tries to get the server ip-adress from the name you have spesified for the machine where your database is located. Normally you either select dhcp support in your MS Windows TCP/IP setup or you will have to locate the HOSTS file (somwhere under your WINDOWS directory I tink) and add your server name and it's IP adress to that file. Your services file should be in the same directory, and I assume you have set up a proper service specification in that according to the instruction in the installation manual. As you connect via an internet service provider I would assume your server is behind a firewall. In that case this will not be possible (as far as I know). What you then have to do is to create a whole in the firewall on the port you have specified that Informix use (in /etc/services on Unix and in your services file on MS Windows). You may have to know the protocol used by Informix as well. When this is done I think (don't realy know, but someone should) you connect to the firewall (not to your Unix server) on that port. The firewall should then translate incoming connections on this port to whatever IP adress your Unix server have. This might work, it might not. I haven't ever tried with Informix software. You may also have created a big security whole in your firewall that may not be acceptable to anyone. Probably you have. This is all I know. May be someone else could comment further. On 8 May 1998 20:27:47 GMT, "Martin Acaster" <martinacaster@sprintmail.com> wrote: >Here it is again > >well here is what I have. An HP Pavilion running Windows 95 4.00.950.b. >The Database i am trying to access is hosted by the Oregon Water Resources >Department. I can telnet to the database server i can ping them they can >ping me. I am using any one of three internet connections. Sprint internet >passport, Compuserve, or Teleport (a local ISP). i use Win 95 dial up >networking to connect. at present the only winsock files active on my >machine are winsock.dll in my C:\\windows directory and wsock32.dll in my >C:\\windows and C:\\Informix\\Bin directories. My problem has been narrowed >down to the informix layer. my network layer as I stated above (based on >ping and telnet results) seems OK. I get the error when I try to login >using ILogin.exe or when usingthe Grid program itself. Grid uses >informix-net 5.01 in conjunction with powerbuilder deployment kit 4.0 to >attempt to access the database using my internet connection. I >consistently get the SQL -932 error when I try the Grid login. When I >attempt ILogin I get SQL -932 followed by the WSANO_DATA getservbyname >error. > >any help would be appreciated >let me know if you need more info. > >Marty Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: http://www.iiug.org/techinfo/faq/faq_top.html (Now with ODBC info under "Third party products".)