Re: Attempt to connect to database server (mydbSer
Posted in 2007
Topics: Server Administration, Networking & sqlhosts Configuration
That's very odd. I've never had to add a shared memory port to /etc/services.
indeed the manual says:
Because this is a shared-memory connection, no entries in network configuration
files are required. For a shared-memory connection, you can choose arbitrary
values for the hostname and servicename fields of the sqlhosts file or SQLHOSTS
registry key.
Art S. Kagel
----- Original Message -----
From: Paul Gathogo <ids@iiug.org>
At: 1/17 2:25:03
Marcus, Kagel,
I did as per your recommendations, this how my sqlhosts looks like
suse_shm onipcshm servername ows_shm
suse_ows onsoctcp servername my_srv
Then exported INFORMIXSERVER=suse_shm
NOTE: ows_shm dummy got to be there(slqhosts file only) otherwise onspaces
freezes in time!
But now i cannot be able to do dbaccess from the clients, the thing takes
forever to connect then throws this error:
"Attempt to connect to database server (suse_ows) failed "
we are headed somewhere ,,
Any more ideas..
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
On 1/17/07, ART KAGEL, BLOOMBERG/ 731 LEXIN <kagel@bloomberg.net> wrote: > That's very odd. I've never had to add a shared memory port to /etc/services. > indeed the manual says: > > Because this is a shared-memory connection, no entries in network > configuration files are required. For a shared-memory connection, you > can choose arbitrary values for the hostname and servicename fields > of the sqlhosts file or SQLHOSTS registry key. You do not need anything in the services file for a the entry that appears in the service name field (4th column) of the sqlhosts file. The name must be unique across the shared memory connections in use on the machine - but that's all. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/