Re: Connecting to different DBMS's with isql
It looks very much like someone did an impromper installation of
Informix on your machine.
You might want to post a list of the /usr/informix directory and it's
subdirectories (something like ls -lR or simply ls -R if the -lR is to
big to post). We'll find out from that what you have.
If it isn't properly installed using the Informix installation
procedure you might want to check with your supplier and possibly with
Informix as to why this is the case.
herschel@iui.com (Herschel Chandler) wrote:
:Thanks for the ideas.. Unfortunately we don't even have tbstat or even a
:/usr/informix/etc directory. Just a bin, lib and msg with nothing of
:consequence.. Just dbschema and isql. The vendor isn't providing any
:help either..
:Does anyone know exactly what is allowed with a run time license? Could
:we have things like tbstat or is it restricted to just isql and dbschema
:(or should we have even that?)
:On Mon, 30 Sep 1996, Tracy Nedd wrote:
:} Date: Mon, 30 Sep 96 7:53:21 EDT
:} From: Tracy Nedd <tracyn@asd.banctec.com>
:} To: herschel@iui.com
:} Cc: Informix Mailing List <informix-list@rmy.emory.edu>
:} Subject: Re: Connecting to different DBMS's with isql
:}
:} Herschel,
:}
:} You can try the following. Telnet to your STORE123 machine. Type the
:} command "tbstat -c " This command prints a copy of the configuration
:} file to the screen. You should probably redirect the output to a file.
:}
:} There is a entry in the configuration called DBSERVERNAME. This is the
:} name that the "...@dbserver" is looking for. You might need to set up a
:} sqlhosts file which matches the DBSERVERNAME in order for connectivity to
:} work. Email me back if you need help doing this.
:}
:} Also if after executing the "tbstat" command, it returns "command not
:} found" then you are probably running SE. You can type the command
:} "set" to see the environment variables. Find INFORMIXDIR, go to that
:} dir. There should be a subdir called "release". In that dir is info
:} on the Informix products installed. This should help alot. Also the
:} configuration file which is printed by the "tbstat -c" command resides
:} in the $INFORMIXDIR/etc dir.
:}
:} Hope this helps,
:}
:} Tracy
:}
:} p.s. Forgive the earlier blank reply. My finger slipped while typing.
:}
:} >
:} > I want to connect to different DBMSs from one host.
:} >
:} > I've been told by Informix that the format is
:} >
:} > isql dbname@dbserver.
:} >
:} > The DBMSs I'm connecting to are set up by a third party software
:} > vendor and all we have is a run time license (we've got isql and
:} > dbschema only.) We don't currently have any sort of development
:} > environment.
:} >
:} > I looked on the various hosts for the DBSERVER environment
:} > variable. It is not set. I tried using the hostname instead, to no
:} > avail.
:} >
:} > I am using Informix SQL version 4.10.UC2. As far as the name of the
:} > Informix server installation -- I dunno.. I've just seen Informix.. No
:} > SE or Online or anything...
:} >
:} > Anyone able to give me some ideas? I want to connect to a database
:} > called test on a host named STORE123.
:} >
:} > Telneting to STORE123 and typing isql test works fine.
:} >
:} > Thanks!
:} >
:} > Herschel
:} >
:}
:}
:} --
:} =========================================================================
:} = Tracy W. Nedd =
:} = Banctec Inc. - DBA =
:} = Silver Spring, Md =
:} = tracyn@banctec.clark.net or tracyn@asd.banctec.com =
:} =========================================================================
:} = ALL RIGHTS RESERVED. =
:} = This posting is copyright and may be used only for the purposes =
:} = of professional study, or the professional exchange of information. =
:} = Use of this posting by any commercial organization for the purposes =
:} = of vilifying another is explicitly prohibited. =
:} =========================================================================
:}
Nils.Myklebust@idg.no
NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway
My opinions are those of my company
The Informix FAQ is at http://www.iiug.org