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
