Oninit cdi / Archive
Talk to an expert →

RE: Running dbaccess remotely problem

Posted in 1999

Topics: Installation, Setup & Upgrades, Server Administration, Networking & sqlhosts Configuration, Platform-Specific Issues, Versions, Editions & End-of-Life

Murray Wood — — source: Informix-list mailing list archive (1991-1998)

You have to install IDS on the client machine, then complete the sqlhosts and services tables, in order to get dbaccess runing across machines. Set INFROMIXSERVER to the entry in your (local) sqlhosts table, INFORMIXDIR to your (local) Informix directory and presto! Murray Wood PS You can then delete SOME of the informix from your client machine - but not too mich!! You do not need to do anything with the engine just installed. -----Original Message----- From: cyewmeng@my-deja.com [SMTP:cyewmeng@my-deja.com] Sent: Thursday, June 24, 1999 1:57 PM To: informix-list@iiug.org Subject: Running dbaccess remotely problem Hi, I'm trying to setup a linux machine (redhat) to access Informix IDS 7.3 on another linux machine (redhat) using dbaccess. While running dbaccess on my client machine, I get the error: "Unknown error message 1202". Following is my IDS server's settings: sqlhosts: --------- pump onipcshm pump_host sqlshm pump_tcp onsoctcp punp_host sqltcp etc/services: ------------- sqltcp 1526/tcp onconfig: --------- DBSERVERNAME = pumpDBSERVERALIAS= pump_tcp NETTYPE ipcshm,1,50,CPU NETTYPE soctcp,1,50,NET On the client side (which is also running RedHat), I did the following: 1. installed informix-connect v2.1, 2. copied dbaccess from the server machine over, 3. set the env INFORMIXDIR, PATH, TERM accordingly. 4. add an entry in /etc/services: sqltcp 1536/tcp. Any idea why I cannot get dbaccess running on the client machine? Also can we just copy dbaccess from 1 machine to another (same OS) and expect it to work? Is this correct? Any help is greatly appreciated. Thanks !!! Yew Meng Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.

↪ replying to Murray Wood
cyewmeng@my-deja.com — — source: Informix-list mailing list archive (1991-1998)

Hi, Is it mandatory for me to install IDS on the client machine in order to get DBAccess to run the client machine? This would create a license problem for me - I only have 1 copy of Informix IDS.... Thanks, YM In article <7kuhql$46j$1@news.xmission.com>, "murray@quanta.co.nz" <murray@quanta.co.nz> wrote: > > > You have to install IDS on the client machine, then complete the sqlhosts > and services tables, in order to get dbaccess runing across machines. > Set INFROMIXSERVER to the entry in your (local) sqlhosts table, INFORMIXDIR > to your (local) Informix directory and presto! > > Murray Wood > > PS You can then delete SOME of the informix from your client machine - but > not too mich!! You do not need to do anything with the engine just > installed. > > -----Original Message----- > From: cyewmeng@my-deja.com [SMTP:cyewmeng@my-deja.com] > Sent: Thursday, June 24, 1999 1:57 PM > To: informix-list@iiug.org > Subject: Running dbaccess remotely problem > > Hi, > > I'm trying to setup a linux machine (redhat) to access Informix IDS 7.3 > on another linux machine (redhat) using dbaccess. While running > dbaccess on my client machine, I get the error: > > "Unknown error message 1202". > > Following is my IDS server's settings: > > sqlhosts: > --------- > pump onipcshm pump_host sqlshm > pump_tcp onsoctcp punp_host sqltcp> > etc/services: > ------------- > sqltcp 1526/tcp > > onconfig: > --------- > DBSERVERNAME = pump> DBSERVERALIAS= pump_tcp > NETTYPE ipcshm,1,50,CPU > NETTYPE soctcp,1,50,NET> > On the client side (which is also running RedHat), I did the following: > 1. installed informix-connect v2.1, > 2. copied dbaccess from the server machine over, > 3. set the env INFORMIXDIR, PATH, TERM accordingly. > 4. add an entry in /etc/services: sqltcp 1536/tcp. > > Any idea why I cannot get dbaccess running on the client machine? Also > can we just copy dbaccess from 1 machine to another (same OS) and > expect it to work? Is this correct? > > Any help is greatly appreciated. Thanks !!! > > Yew Meng > > Sent via Deja.com http://www.deja.com/ > Share what you know. Learn what you don't. > > Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.

↪ replying to cyewmeng@my-deja.com
Dirk Liesch — — source: Informix-list mailing list archive (1991-1998)

Hi, as far as I know, it is enough to install Informix Connect on your client machine. If this is installed you have to configure your sqlhost-file on client-side. If your remote server is called "server" and its located on server_machine "computerx" and your "/etc/services"-file got an entry like: port_server 2000/tcp #my remote informix server than your sqlhost configuration on client should have an entry like: server ontlitcp computerx port_server bye Dirk cyewmeng@my-deja.com schrieb: > Hi, > > Is it mandatory for me to install IDS on the client machine in order to > get DBAccess to run the client machine? This would create a license > problem for me - I only have 1 copy of Informix IDS.... > > Thanks, > YM > > In article <7kuhql$46j$1@news.xmission.com>, > "murray@quanta.co.nz" <murray@quanta.co.nz> wrote: > > > > > > You have to install IDS on the client machine, then complete the > sqlhosts > > and services tables, in order to get dbaccess runing across machines. > > Set INFROMIXSERVER to the entry in your (local) sqlhosts table, > INFORMIXDIR > > to your (local) Informix directory and presto! > > > > Murray Wood > > > > PS You can then delete SOME of the informix from your client machine > - but > > not too mich!! You do not need to do anything with the engine just > > installed. > > > > -----Original Message----- > > From: cyewmeng@my-deja.com [SMTP:cyewmeng@my-deja.com] > > Sent: Thursday, June 24, 1999 1:57 PM > > To: informix-list@iiug.org > > Subject: Running dbaccess remotely problem > > > > Hi, > > > > I'm trying to setup a linux machine (redhat) to access Informix IDS > 7.3 > > on another linux machine (redhat) using dbaccess. While running > > dbaccess on my client machine, I get the error: > > > > "Unknown error message 1202". > > > > Following is my IDS server's settings: > > > > sqlhosts: > > --------- > > pump onipcshm pump_host sqlshm > > pump_tcp onsoctcp punp_host sqltcp> > > > etc/services: > > ------------- > > sqltcp 1526/tcp > > > > onconfig: > > --------- > > DBSERVERNAME = pump> > DBSERVERALIAS= pump_tcp > > NETTYPE ipcshm,1,50,CPU > > NETTYPE soctcp,1,50,NET> > > > On the client side (which is also running RedHat), I did the > following: > > 1. installed informix-connect v2.1, > > 2. copied dbaccess from the server machine over, > > 3. set the env INFORMIXDIR, PATH, TERM accordingly. > > 4. add an entry in /etc/services: sqltcp 1536/tcp. > > > > Any idea why I cannot get dbaccess running on the client machine? Also > > can we just copy dbaccess from 1 machine to another (same OS) and > > expect it to work? Is this correct? > > > > Any help is greatly appreciated. Thanks !!! > > > > Yew Meng > > > > Sent via Deja.com http://www.deja.com/ > > Share what you know. Learn what you don't. > > > > > > Sent via Deja.com http://www.deja.com/ > Share what you know. Learn what you don't.

↪ replying to cyewmeng@my-deja.com
Dirk Liesch — — source: Informix-list mailing list archive (1991-1998)

Hi, as far as I know, it is enough to install Informix Connect on your client machine. If this is installed you have to configure your sqlhost-file on client-side. If your remote server is called "server" and its located on server_machine "computerx" and your "/etc/services"-file got an entry like: port_server 2000/tcp #my remote informix server than your sqlhost configuration on client should have an entry like: server ontlitcp computerx port_server bye Dirk cyewmeng@my-deja.com schrieb: > Hi, > > Is it mandatory for me to install IDS on the client machine in order to > get DBAccess to run the client machine? This would create a license > problem for me - I only have 1 copy of Informix IDS.... > > Thanks, > YM > > In article <7kuhql$46j$1@news.xmission.com>, > "murray@quanta.co.nz" <murray@quanta.co.nz> wrote: > > > > > > You have to install IDS on the client machine, then complete the > sqlhosts > > and services tables, in order to get dbaccess runing across machines. > > Set INFROMIXSERVER to the entry in your (local) sqlhosts table, > INFORMIXDIR > > to your (local) Informix directory and presto! > > > > Murray Wood > > > > PS You can then delete SOME of the informix from your client machine > - but > > not too mich!! You do not need to do anything with the engine just > > installed. > > > > -----Original Message----- > > From: cyewmeng@my-deja.com [SMTP:cyewmeng@my-deja.com] > > Sent: Thursday, June 24, 1999 1:57 PM > > To: informix-list@iiug.org > > Subject: Running dbaccess remotely problem > > > > Hi, > > > > I'm trying to setup a linux machine (redhat) to access Informix IDS > 7.3 > > on another linux machine (redhat) using dbaccess. While running > > dbaccess on my client machine, I get the error: > > > > "Unknown error message 1202". > > > > Following is my IDS server's settings: > > > > sqlhosts: > > --------- > > pump onipcshm pump_host sqlshm > > pump_tcp onsoctcp punp_host sqltcp> > > > etc/services: > > ------------- > > sqltcp 1526/tcp > > > > onconfig: > > --------- > > DBSERVERNAME = pump> > DBSERVERALIAS= pump_tcp > > NETTYPE ipcshm,1,50,CPU > > NETTYPE soctcp,1,50,NET> > > > On the client side (which is also running RedHat), I did the > following: > > 1. installed informix-connect v2.1, > > 2. copied dbaccess from the server machine over, > > 3. set the env INFORMIXDIR, PATH, TERM accordingly. > > 4. add an entry in /etc/services: sqltcp 1536/tcp. > > > > Any idea why I cannot get dbaccess running on the client machine? Also > > can we just copy dbaccess from 1 machine to another (same OS) and > > expect it to work? Is this correct? > > > > Any help is greatly appreciated. Thanks !!! > > > > Yew Meng > > > > Sent via Deja.com http://www.deja.com/ > > Share what you know. Learn what you don't. > > > > > > Sent via Deja.com http://www.deja.com/ > Share what you know. Learn what you don't.

↪ replying to Dirk Liesch
Art S. Kagel — — source: Informix-list mailing list archive (1991-1998)

Correct and Informix Connect is a FREE license on all platforms. Art S. Kagel Dirk Liesch wrote: > > Hi, > > as far as I know, it is enough to install Informix Connect on your client > machine. If this is installed you have to configure your sqlhost-file on > client-side. > > If your remote server is called "server" and its located on server_machine > "computerx" and your "/etc/services"-file got an entry like: > > port_server 2000/tcp #my remote informix server > > than your sqlhost configuration on client should have an entry like: > > server ontlitcp computerx port_server> > bye Dirk > > cyewmeng@my-deja.com schrieb: > > > Hi, > > > > Is it mandatory for me to install IDS on the client machine in order to > > get DBAccess to run the client machine? This would create a license > > problem for me - I only have 1 copy of Informix IDS.... > > > > Thanks, > > YM > > > > In article <7kuhql$46j$1@news.xmission.com>, > > "murray@quanta.co.nz" <murray@quanta.co.nz> wrote: > > > > > > > > > You have to install IDS on the client machine, then complete the > > sqlhosts > > > and services tables, in order to get dbaccess runing across machines. > > > Set INFROMIXSERVER to the entry in your (local) sqlhosts table, > > INFORMIXDIR > > > to your (local) Informix directory and presto! > > > > > > Murray Wood > > > > > > PS You can then delete SOME of the informix from your client machine > > - but > > > not too mich!! You do not need to do anything with the engine just > > > installed. > > > > > > -----Original Message----- > > > From: cyewmeng@my-deja.com [SMTP:cyewmeng@my-deja.com] > > > Sent: Thursday, June 24, 1999 1:57 PM > > > To: informix-list@iiug.org > > > Subject: Running dbaccess remotely problem > > > > > > Hi, > > > > > > I'm trying to setup a linux machine (redhat) to access Informix IDS > > 7.3 > > > on another linux machine (redhat) using dbaccess. While running > > > dbaccess on my client machine, I get the error: > > > > > > "Unknown error message 1202". > > > > > > Following is my IDS server's settings: > > > > > > sqlhosts: > > > --------- > > > pump onipcshm pump_host sqlshm > > > pump_tcp onsoctcp punp_host sqltcp> > > > > > etc/services: > > > ------------- > > > sqltcp 1526/tcp > > > > > > onconfig: > > > --------- > > > DBSERVERNAME = pump> > > DBSERVERALIAS= pump_tcp > > > NETTYPE ipcshm,1,50,CPU > > > NETTYPE soctcp,1,50,NET> > > > > > On the client side (which is also running RedHat), I did the > > following: > > > 1. installed informix-connect v2.1, > > > 2. copied dbaccess from the server machine over, > > > 3. set the env INFORMIXDIR, PATH, TERM accordingly. > > > 4. add an entry in /etc/services: sqltcp 1536/tcp. > > > > > > Any idea why I cannot get dbaccess running on the client machine? Also > > > can we just copy dbaccess from 1 machine to another (same OS) and > > > expect it to work? Is this correct? > > > > > > Any help is greatly appreciated. Thanks !!! > > > > > > Yew Meng > > > > > > Sent via Deja.com http://www.deja.com/ > > > Share what you know. Learn what you don't. > > > > > > > > > > Sent via Deja.com http://www.deja.com/ > > Share what you know. Learn what you don't.

↪ replying to Art S. Kagel
Jonathan Leffler — — source: Informix-list mailing list archive (1991-1998)

Art S. Kagel wrote: > Correct and Informix Connect is a FREE license on all platforms. Does I-Connect include DB-Access? I suspect not -- I think not. If I-Connect does not include DB-Access, then you do, strictly, need a server on your machine to get a legitimate copy of DB-Access to run. I'm suspicious because we just got warned off for rewriting some I4GL demo installation scripts to use DB-Access, and the concern was raised that if you only have I-Connect on the machine, you do not get DB-Access, so you couldn't run the demo installs, so you'd have problems. If I-Connect does have DB-Access, then we're in the clear. I'll have to investigate anyway... > Dirk Liesch wrote: > > as far as I know, it is enough to install Informix Connect on > > your client machine. If this is installed you have to configure > > your sqlhost-file on client-side. > > > > If your remote server is called "server" and its located on > > server_machine "computerx" and your "/etc/services"-file got > > an entry like: > > > > port_server 2000/tcp #my remote informix server > > > > than your sqlhost configuration on client should have an entry like: > > > > server ontlitcp computerx port_server > > cyewmeng@my-deja.com schrieb: > > > Is it mandatory for me to install IDS on the client machine in > > > order to get DBAccess to run the client machine? This would > > > create a license problem for me - I only have 1 copy of Informix > > > IDS.... > > > Murray Wood <murray@quanta.co.nz> wrote: > > > > You have to install IDS on the client machine, then complete > > > > the sqlhosts and services tables, in order to get dbaccess > > > > running across machines. > > > > Set INFORMIXSERVER to the entry in your (local) sqlhosts > > > > table, INFORMIXDIR to your (local) Informix directory and > > > > presto! > > > > > [...snip...] -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>

Glossary