Re: Help with INFORMIX NET-PC

In <29c3veINNbtk@emory.mathcs.emory.edu> randy@turq.b8.ingr.com (Randy Paries) writes: >Hi, > I am looking for some URGENT HELP... > I am trying to get this PC NET going. All my experince is > UNIX and star , so please excuse any terminology glitches. > What I am trying to do is have this stupid PC talk to an ONLINE > database on my UNIX box. > I have done the following. > created 2 files in \\pctcp\\etc directory > 1) services > In the services file I have the entry > sqlexec 1952/tcp > 2) hosts > In the hosts file I have > xxx.xxx.xxx.xxx Local host > xxx.xxx.xxx.xxx My Node Name > ^^^^^^^^^^^^^^^^^^^valid inet numbers here > I have INFORMIXDIR, FTP_ETC, set > After I boot up (I run ethdrv) in the autoexec.bat, > I run remsql. > I get no errors. > I then try running isql > I get the following error. > 854: Back end not found. Or back end is busy. > There is some stuff about the error in the docisql.410 but all > it says is , another application has terminated abnormally > Can any one help me out there?????? > thanks > >-- >--------------------------------------------------------------------------- >Randy Paries rtparies@turq.b8.ingr.com >x6191 cr041 Intergraph, Huntsville Alabama (B&B Rule Heh heh heh) >--------------------------------------------------------------------------- Randy: I can understand your frustration. Whether I can help you is a different matter. However, I'll give it a try. 1. REMSQL will never indicate an error. 2. The TCP port number you entered into your PC's c:\\pctcp\\etc\\services also needs to be in the /etc/services file in your Unix server. If these numbers are different between the two systems it won't work. 3. You need to make sure that the SQLEXEC daemon is running on your Unix server. (as root, got to $INFORMIXDIR/lib and run sqlexecd) 4. I suggest you separate your TCP connection diagnosis from your I-NET diagnosis. Do this by first testing if you can TELNET to your host from the PC. This is simply accomplished by typing: tn [your-host-name | xxx.xxx.xxx.xxx] If this works (you should see a login: prompt), then your PCTCP install is probably OK. Otherwise give the folks at FTP Software a call, their tech support is pretty good. Once you've done all this, chances are you will either access the database as expected or get a different message at your client. Make sure you properly entered the right host, username and password when you started REMSQL. (For diagnostic purposes, I would put them in DOS variables until you get it all working, this way you can actually see the values after the fact. Naturally, this is not recommeded for normal use.) Unfortunately, Informix does not provide a dumb client to test this all, so even if this is set properly, you may still have problems with the set-up of whatever client software you are using. If you need to talk someone, give us a call. Good Luck. =============================================================================== Carlos M. Recalde | The Client is always right. Internet Resources Corp.| crecalde@panix.com New York, NY 10036 | Client-Server Applications Design (212) 626-6886 | and Implementation