Problem Connecting to Remote Database 
Author Message
 Problem Connecting to Remote Database

I'm trying without success to set up a connection to a remote Informix
Dynamic Server 7.3 database.

Following the Administrator's Guide for Informix Dynamic Server, on
the remote host the administrator has added this line to his sqlhosts
file:

        informix_net    onsoctcp        risc6000        nettcp

(risc6000 and nettcp have corresponding entries in /etc/hosts and
/etc/services, respectively), and modified his onconfig file as
follows:

        DBSERVERNAME    informix_prod
        DBSERVERALIASES informix_net
        NETTYPE         ipcshm,1,100,CPU
        #NETTYPE        soctcp,1,50,NET

On my host (a Solaris 2.6 Sparc) I've installed the Client Development
Kit 2.40UC1, added entries to my /etc/hosts & /etc/services to point
to the risc6000 remote host at the nettcp port, and added this line to
my sqlhosts file:

        informix_net    onsoctcp        risc6000        nettcp

I can create a socket to the remote host at the required port, but
when I try to connect to the database itself (the store7 example
database), I get a 25507 error. According to the finderr utility,
+25507 means:

        25507 You specified an unknown service name or protocol.

        Tell your database administrator to examine the sqlhosts file
        entry.  Check that the NETTYPE settings in the ONCONFIG file
        match the NETTYPE settings in the sqlhosts file.

        If you are using the TCP/IP protocol, check that the correct
        service name appears in the /etc/services file. If you are
        using NFS, use ypmake to check the /etc/services
        file. Sometimes the daemon does not recognize service names
        that are added after a default boot.

I have an account on the remote host, and I'm using that logonid and
password when I'm attempting to connect to the database. The remote
administrator tells me I have been granted DBA authority to the
database.

I can't figure out what I'm doing wrong. Any advice? Thanks in
advance.

----
Michael Owens
(505) 827-2154



Wed, 18 Jun 1902 08:00:00 GMT
 Problem Connecting to Remote Database

Mike,

On your solaris box you need to use "onsoctli" rather than "onsoctcp".

HTH

ben


Quote:
> I'm trying without success to set up a connection to a remote Informix
> Dynamic Server 7.3 database.

> Following the Administrator's Guide for Informix Dynamic Server, on
> the remote host the administrator has added this line to his sqlhosts
> file:

>         informix_net    onsoctcp        risc6000        nettcp

> (risc6000 and nettcp have corresponding entries in /etc/hosts and
> /etc/services, respectively), and modified his onconfig file as
> follows:

>         DBSERVERNAME    informix_prod
>         DBSERVERALIASES informix_net
>         NETTYPE         ipcshm,1,100,CPU
>         #NETTYPE        soctcp,1,50,NET

> On my host (a Solaris 2.6 Sparc) I've installed the Client Development
> Kit 2.40UC1, added entries to my /etc/hosts & /etc/services to point
> to the risc6000 remote host at the nettcp port, and added this line to
> my sqlhosts file:

>         informix_net    onsoctcp        risc6000        nettcp

> I can create a socket to the remote host at the required port, but
> when I try to connect to the database itself (the store7 example
> database), I get a 25507 error. According to the finderr utility,
> +25507 means:

>         25507 You specified an unknown service name or protocol.

>         Tell your database administrator to examine the sqlhosts file
>         entry.  Check that the NETTYPE settings in the ONCONFIG file
>         match the NETTYPE settings in the sqlhosts file.

>         If you are using the TCP/IP protocol, check that the correct
>         service name appears in the /etc/services file. If you are
>         using NFS, use ypmake to check the /etc/services
>         file. Sometimes the daemon does not recognize service names
>         that are added after a default boot.

> I have an account on the remote host, and I'm using that logonid and
> password when I'm attempting to connect to the database. The remote
> administrator tells me I have been granted DBA authority to the
> database.

> I can't figure out what I'm doing wrong. Any advice? Thanks in
> advance.

> ----
> Michael Owens
> (505) 827-2154




Wed, 18 Jun 1902 08:00:00 GMT
 Problem Connecting to Remote Database
Thanks. That did the trick.
--
Michael Owens
(505) 827-2154



Wed, 18 Jun 1902 08:00:00 GMT
 Problem Connecting to Remote Database

Quote:

> Mike,

> On your solaris box you need to use "onsoctli" rather than "onsoctcp".

That should be "ontlitcp" rather than onsoctcp.

Art S. Kagel

Quote:

> HTH

> ben



> > I'm trying without success to set up a connection to a remote Informix
> > Dynamic Server 7.3 database.

> > Following the Administrator's Guide for Informix Dynamic Server, on
> > the remote host the administrator has added this line to his sqlhosts
> > file:

> >         informix_net    onsoctcp        risc6000        nettcp

> > (risc6000 and nettcp have corresponding entries in /etc/hosts and
> > /etc/services, respectively), and modified his onconfig file as
> > follows:

> >         DBSERVERNAME    informix_prod
> >         DBSERVERALIASES informix_net
> >         NETTYPE         ipcshm,1,100,CPU
> >         #NETTYPE        soctcp,1,50,NET

> > On my host (a Solaris 2.6 Sparc) I've installed the Client Development
> > Kit 2.40UC1, added entries to my /etc/hosts & /etc/services to point
> > to the risc6000 remote host at the nettcp port, and added this line to
> > my sqlhosts file:

> >         informix_net    onsoctcp        risc6000        nettcp

> > I can create a socket to the remote host at the required port, but
> > when I try to connect to the database itself (the store7 example
> > database), I get a 25507 error. According to the finderr utility,
> > +25507 means:

> >         25507 You specified an unknown service name or protocol.

> >         Tell your database administrator to examine the sqlhosts file
> >         entry.  Check that the NETTYPE settings in the ONCONFIG file
> >         match the NETTYPE settings in the sqlhosts file.

> >         If you are using the TCP/IP protocol, check that the correct
> >         service name appears in the /etc/services file. If you are
> >         using NFS, use ypmake to check the /etc/services
> >         file. Sometimes the daemon does not recognize service names
> >         that are added after a default boot.

> > I have an account on the remote host, and I'm using that logonid and
> > password when I'm attempting to connect to the database. The remote
> > administrator tells me I have been granted DBA authority to the
> > database.

> > I can't figure out what I'm doing wrong. Any advice? Thanks in
> > advance.

> > ----
> > Michael Owens
> > (505) 827-2154




Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. problem connecting a remote database

2. Problem connecting to SQL Database from Remote site

3. Problem connecting to remote SQL server database

4. Problem on VB6 Remote connect to SQL 7 Database

5. Problems Connecting to a remote Access Database

6. JDBC Problem connecting to a REMOTE database

7. Problems connecting Enterprise Manager to remote database...

8. Problem Connecting to a Remote Access Database from ASP

9. Connect local database to remote database

10. Connecting to remote database vs local database

11. Remote connect to database with database link

12. problem connecting to remote server


 
Powered by phpBB® Forum Software