Informix over network

Posted in 1999

jshaley@my-dejanews.com — Wed, 20 Jan 1999 00:14:49 GMT — source: Informix-list mailing list archive (1991-1998)

Is it possible to access an Informix database over a network without running the Informix server on the local box? We have an Oracle application that queries a vendor's database, and we don't have Oracle server on our system. So far, I don't see that this is possible with Informix. Thanks, Jay Haley -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

↪ replying to jshaley@my-dejanews.com

Richard Troy — Tue, 19 Jan 1999 17:31:48 -0800 — source: Informix-list mailing list archive (1991-1998)

jshaley@my-dejanews.com wrote: > > Is it possible to access an Informix database over a network without > running the Informix server on the local box? We have an Oracle > application that queries a vendor's database, and we don't have Oracle > server on our system. So far, I don't see that this is possible > with Informix. > > Thanks, Jay Haley Yes, Jay, it's trivially easy. You _do_ need to install the Informix client tools if you wish to use the Informix SQL editor, and other tools. But you can use ODBC or JDBC if you want and these don't require a database engine either. Regards, RT Richard Troy Chief Scientist, Berkeley Earth Science Tools corporation rtroy@ScienceTools.com, 510-567-9957 and Co-Investigator, OceanESIP, Earth System Information Partner Federation Team Leader, BigSur, The NASA EOS-DIS Alternative Architecture project. rtroy@cs.berkeley.edu, 510-643-1016 (the other number is better)

↪ replying to Richard Troy

Allan Gould — Wed, 20 Jan 1999 08:52:19 +0000 — source: Informix-list mailing list archive (1991-1998)

Richard Troy wrote: > > jshaley@my-dejanews.com wrote: > > > > Is it possible to access an Informix database over a network without > > running the Informix server on the local box? We have an Oracle > > application that queries a vendor's database, and we don't have Oracle > > server on our system. So far, I don't see that this is possible > > with Informix. > > > > Thanks, Jay Haley > > Yes, Jay, it's trivially easy. > > You _do_ need to install the Informix client tools if you wish to use > the Informix SQL editor, and other tools. But you can use ODBC or JDBC > if you want and these don't require a database engine either. You could try our ODBC driver: SCO SQL-Retriever; we do drivers for Informix (v4,5,6 & 7 SE & OnLine) and Oracle (7) on several UNIX platforms: single vendor solution! No need for the RDBMS vendor's networking software (sqlnet or INet either). Take a look at http://www.sco.com/vision/products/sqlretriever/ for more information and a downloadable eval. Allan Gould SCO CID Support, Leeds, UK (allang at sco dot com) (Please remove anti-spam measures if replying)