no remote access with dbaccess

Hello! I am trying to connect remotely to an Informix Server but I do not make it. Can anybody give me a hint? I assume this is nothing but a configuration problem. The situation is as follows. Server: IDS 2000 on Linux. The server is up and running and I can do whatever I want as long as I use dbaccess locally on the machine on which the server runs. Excerpt from server-machine's /etc/services: informix 5432/tcp # Informix Dynamic Server 2000 Excerpt from server-machine's $INFORMIXDIR/etc/sqlhosts: sun onsoctcp sun.brave.de informix Client: Linux as well with an installed Server IDS 7.3. The Server is NOT RUNNING! Excerpt from client's $INFORMIXDIR/sqlhosts: sun onsoctcp sun.brave.de informix The first attempt to connect from the client by dbaccess yields the error message "931: Cannot locate informix service/tcp service in /etc/services" Strange, but OK. I add the entry "informix 5432/tcp # Informix Dynamic Server 2000" to /etc/services of the client machine. Second try: The connection attemp runs for a while and ends up in the error message "908: Attempt to connect to database server (sun) failed. ISAM error: record is locked." What happens? What else do I have to do in order to establish a connection to a remote server? Thanks in advance for your help. Norbert Heidbrink

Hi, Please try to use ontlitcp on the client side (in sqlhosts). Did you configure the name of the server (sun) in sqlhosts file as DBSERVERALIASES in both onconfig files ? Please try as well, i guess if you use the real DBSERVERNAME it is connected to onipcshm on teh server side. Before you start dbaccess please set INFORMIXSERVER to the DBSERVERALIASES value on the client side. Please let me know your progress cu Martin Norbert.Heidbrink@home.of.the.brave.de schrieb: > Hello! > > I am trying to connect remotely to an Informix Server but I do not make > it. > Can anybody give me a hint? I assume this is nothing but a configuration > problem. > > The situation is as follows. > Server: > IDS 2000 on Linux. > The server is up and running and I can do whatever I want as long as I > use dbaccess locally on the machine on which the server runs. > > Excerpt from server-machine's /etc/services: > informix 5432/tcp # Informix Dynamic > Server 2000 > > Excerpt from server-machine's $INFORMIXDIR/etc/sqlhosts: > sun onsoctcp sun.brave.de informix> > Client: > Linux as well with an installed Server IDS 7.3. > The Server is NOT RUNNING! > > Excerpt from client's $INFORMIXDIR/sqlhosts: > sun onsoctcp sun.brave.de informix> > The first attempt to connect from the client by dbaccess yields the > error message > "931: Cannot locate informix service/tcp service in /etc/services" > > Strange, but OK. > I add the entry > "informix 5432/tcp # Informix Dynamic Server 2000" > to /etc/services of the client machine. > > Second try: > The connection attemp runs for a while and ends up in the error message > "908: Attempt to connect to database server (sun) failed. > ISAM error: record is locked."> > What happens? What else do I have to do in order to establish a > connection to a remote server? > > Thanks in advance for your help. > Norbert Heidbrink