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. = =========================================================================