Oninit cdi / Archive
Talk to an expert →

Please help clarify 4gl/SE connectivity

Posted in 1999

Topics: Connectivity: ESQL/C, 4GL & Embedded SQL, Networking & sqlhosts Configuration

Roy Terry — — source: Informix-list mailing list archive (1991-1998)

I'm working with about 20 SE databases on a series of SCO machines on an intranet. Using latest versions of SE and compiled 4gl. QUESTION: Can I set sqlhosts, etc. up so that I can connect to any database from within a 4gl program? E.g., database dbname@node1 .... database dbname@node2 .... etc. I've been experimenting with sqlhosts files and restarting the SQL server processes. So far only success I've had is if I redefine the INFORMIXSERVER variable before I start the process. Is there a way to get generalized connectivity w/o resetting INFORMIXSERVER? Any suggestions or referrals to FAQ's welcome. -Roy

↪ replying to Roy Terry
Art S. Kagel — — source: Informix-list mailing list archive (1991-1998)

Roy Terry wrote: > > I'm working with about 20 SE databases on > a series of SCO machines on an intranet. Using latest > versions of SE and compiled 4gl. > > QUESTION: > Can I set sqlhosts, etc. up so that I can connect > to any database from within a 4gl program? E.g., > database dbname@node1 > .... > database dbname@node2 I'm not sure if this is still the case but SE used to only support an older syntax for remote servers: database "//servername/dbname" Art S. Kagel

↪ replying to Art S. Kagel
Jonathan Leffler — — source: Informix-list mailing list archive (1991-1998)

Art S. Kagel wrote: > > Roy Terry wrote: > > > > I'm working with about 20 SE databases on > > a series of SCO machines on an intranet. Using latest > > versions of SE and compiled 4gl. > > > > QUESTION: > > Can I set sqlhosts, etc. up so that I can connect > > to any database from within a 4gl program? E.g., > > database dbname@node1 > > .... > > database dbname@node2 > > I'm not sure if this is still the case but SE used to only support an > older syntax for remote servers: > > database "//servername/dbname" It is still the case - I found out the hard way on Linux. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>

Glossary