Re: Not Oracle!
Posted in 1999
Topics: Installation, Setup & Upgrades, Connectivity: ODBC / JDBC / .NET, Server Administration, Networking & sqlhosts Configuration, Platform-Specific Issues
From: "Effrem Norwood" <eff@neoa.com>
>
>We have a mixed shop of NT, Linux, and Solaris. When we started looking at
>buying our first RDBMS, we inquired about Oracle and followed the Oracle
>NG.
>There was a very long thread about which RDBMS was the 'best' and the
>answer
>was resoundingly Informix. So, after following this newsgroup for a while,
>we purchased Informix 7.30.UC7-2 for Linux, and have tried and tried to
>install it, but it doesn't like us.
>
>I rpm'd it into RedHat 6.1, set my environment variables, configured
>onconfig and sqlhosts, said onstat and it keeps telling me it can't find
>the
>server. My sqlhosts file says:
>
>lepidoptera onipcshm 192.168.1.137 lepidoptera>
>The onconfig names DBSERVERNAME as lepidoptera. So, what am I missing here?
>The goal is to communicate with a database we will create from an NT www
>server using either ODBC or JDBC.
Please post your onconfig, sqlhosts and output from set...
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
Obnoxio The Clown wrote:
> From: "Effrem Norwood" <eff@neoa.com>
> >
> >We have a mixed shop of NT, Linux, and Solaris. When we started looking at
> >buying our first RDBMS, we inquired about Oracle and followed the Oracle
> >NG.
> >There was a very long thread about which RDBMS was the 'best' and the
> >answer
> >was resoundingly Informix. So, after following this newsgroup for a while,
> >we purchased Informix 7.30.UC7-2 for Linux, and have tried and tried to
> >install it, but it doesn't like us.
> >
> >I rpm'd it into RedHat 6.1, set my environment variables, configured
> >onconfig and sqlhosts, said onstat and it keeps telling me it can't find
> >the
> >server. My sqlhosts file says:
> >
> >lepidoptera onipcshm 192.168.1.137 lepidoptera> >
> >The onconfig names DBSERVERNAME as lepidoptera. So, what am I missing here?
> >The goal is to communicate with a database we will create from an NT www
> >server using either ODBC or JDBC.
>
> Please post your onconfig, sqlhosts and output from set...
I would not expect to use the i/p address in the hostname field. I would expect
to use
the FQDN (fully qualified domain name) as available from uname -n (on Linux).
Also,
for olipcshm connections, the database must be on the same machine as the
application.
--
Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net)
Guardian of DBD::Informix v0.62 -- see http://www.perl.com/CPAN
#include <disclaimer.h>