Re: ODBC and Informix

In article <669odg$1cgi@central.MTS.Net>, Shawn Lawe <slawe@beyondtv.net> wrote: >Hi, > Hi Shawn, You need to get ahold of either IConnect 9.12.TC2 or IConnect 2.00.TC1. Both of these packages contain the Informix CLI (ODBC) driver along with the ODBC Admin tools for 32 bit Windows systems. This particular ODBC driver operates on top of the standard Informix Connectivity libraries and so you either need to use SETNET32 or to specify Setnet-like parameters to the CLI driver. Just a quick note, the version 2.00.TC1 is the follow-on version to 9.12.TC2 but has been renumbered since it is now generic. I.e. it works against 7.X, 8.X and 9.X Informix Server products. These Informix products are important for the Universal option for the Online Dynamic Server (formerly IUS) since this ODBC driver is the only one that recognizes extended data types. Now, as to your question about "remote access" of the database. Do you have any access to it? i.e. can you connect to it via SQLEditor or some other package on your client machine? Check what the exposed interface to the server is by checking in $INFORMIXDIR/etc/sqlhosts for any entries that use 'ontlitcp'. When you do, grep /etc/services for the socket and that is where you need to point your client machine to connect. I believe that these need to be set up. I am also assuming that you have an account on the machine in question, and that you are connecting via that username and password. Since I can't think of anything else off the top of my head, I hope this helps. Al >I have a question for all of you. I'm currently working with both Oracle >databases, and Informix databases. The biggest problem I'm having is that >our system does not have informix set up for "remote access" or "ODBC" >access. Currently the only way to access any of the Informix tables is to >do it from the local machine. > >Our Informix Unviversal Server is running on a Solaris box. I did not do >the installation, and I have no idea how to set it up to handle ODBC. Can >anyone give me any information about this? > >Also, where can I find Informix ODBC drivers for Windows 95? > >Thanks for any help you can give me! > >Sincerely, >Shawn Lawe > > ==================================================================== Albert Landeck, DataBlade Development Group (510) 628-3813 Informix Software, Inc. (510) 628-3880 (fax) 300 Lakeside Drive, Suite 2700 landeck@informix.com Oakland, California 94612 ====================================================================