Informix connectivity on Solaris

Posted in 2004

Topics: Installation, Setup & Upgrades, Connectivity: ODBC / JDBC / .NET, Platform-Specific Issues

Ruturaj Kalgaonkar — Sat, 3 Jan 2004 15:25:53 +0530 — source: Usenet: comp.databases.informix

--453643009-1348997042-1073123753=:1408 Content-Type: TEXT/PLAIN; CHARSET=US-ASCII My informix 7.30 database is on solaris 2.6 and I have installed reporting tool on different solaris 8.0 machine. Now I want to connect to solaris 2.6 from solaris 8 machine. I have used iconnect/odbc and successfully connected to from w2k to solaris2.6 database. But I don\\'t know how to connect from solaris machine to solaris database. Thanks in adv. Regards, Ruturaj ------ --453643009-1348997042-1073123753=:1408 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 7bit This message (including any attachments) contains confidential information intended for a specific individual recipient and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. --453643009-1348997042-1073123753=:1408-- sending to informix-list

↪ replying to Ruturaj Kalgaonkar

Art S. Kagel — Mon, 05 Jan 2004 08:57:33 -0500 — source: Usenet: comp.databases.informix

On Sat, 03 Jan 2004 04:55:53 -0500, Ruturaj Kalgaonkar wrote: > My informix 7.30 database is on solaris 2.6 and I have installed reporting > tool on different solaris 8.0 machine. Now I want to connect to solaris 2.6 > from solaris 8 machine. I have used iconnect/odbc and successfully connected > to from w2k to solaris2.6 database. But I don\\'t know how to connect from > solaris machine to solaris database. Pretty much the same way. Get either iConnect or iSDK for Solaris 8, install. You will get native Informix connectivity for 4GL, esql/C-C++, or Java apps and odbc for any odbc enabled apps. If you need to develop, then install the iSDK which include iConnect plus the development tools and libraries for all of the above including ODBC development. For native Informix connections you just have to set up the INFORMIXDIR, INFORMIXSERVER, and LD_LIBRARY_PATH environment variables in each user's environment (usually by creating a 'dot' script you can run in /etc/profile or which users can call from their .profile) and install a copy of the sqlhosts file in the $INFORMIXDIR/etc directory (or in another location specified by $INFORMIXSQLHOSTS) and making the required port entries into /etc/services. For ODBC just set up an appropriate .odbc.ini file in each user's home directory. Art S. Kagel > Thanks in adv. > > Regards, > Ruturaj