Fwd: Re: ODBC /Informix

Received: from ns.bju.edu ([158.158.239.1]) by bju.edu; Mon, 02 Nov 1998 09:50:50 -0500 Received: from bjuprdev.BJU.EDU. (bjuprdev.bju.edu [158.158.240.2]) by ns.bju.edu (2.5 Build 2639 (Berkeley 8.8.6)/8.8.4) with SMTP id JAA20858; Mon, 02 Nov 1998 09:58:11 -0500 Received: from cs2080.bju.edu (dmcnight.BJU.EDU) by bjuprdev.BJU.EDU. (4.1/SMI-4.1) id AA09298; Mon, 2 Nov 98 10:10:13 EST Message-Id: <363DC6C6.178C@bju.edu> Date: Mon, 02 Nov 1998 09:50:46 -0500 From: Dave McNight <dmcnight@bju.edu> Reply-To: 1700@bju.edu, Wade@bju.edu, Hampton@bju.edu, Blvd@bju.edu, Greenville@bju.edu, SC@bju.edu, 29614@bju.edu Organization: Bob Jones University X-Mailer: Mozilla 3.01 (Win95; I) To: "Bernstein, Rick" <rbernste@alarismed.com> Cc: dmcnight@bju.edu Subject: Re: ODBC /Informix References: <71fidp$c1j$1@news.xmission.com> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Disposition: inline Thank you for your response :-) We are not getting past your step 1. We receive system error 126 when trying to create the user or system DSN within the MS ODBC Administrator. We have added INFORMIXDIR=c:\\informix,and added c:\\informix\\bin and c:\\informix\\system to the PATH in the System environment variables on NT with no avail. Thanks for your assistance! Dave McNight Unix Administrator Bob Jones University Bernstein, Rick wrote: > > The following procedure should allow you to access Informix database tables > using MS Access 97: > 1. Create a User DSN (or System DSN) using the ODBC Data Source > Administrator > from the Control panel. > 2. Within MS ACCESS: > a. Select File -> New Database > b. Double click on Blank Database > c. Click on Create > d. Select File -> Get External Data -> Link Tables... > e. Select ODBC under "Files of type:" > f. Click on the "Machine Data Source" tab > g. Double click on the desired "Data Source Name" > h. Select the names of Informix tables which you want to access. > i. Click OK and wait for links to be built. > > We just went through this procedure yesterday. > Good luck. > > -----Original Message----- > From: Dave McNight [mailto:dmcnight@bju.edu] > Sent: Friday, October 30, 1998 10:48 > To: informix-list@iiug.org > Subject: ODBC /Informix > > We are using MS Access Office 97 and want to access an Informix 7.24 > > database using the Intersolv ODBC driver supplied on the Informix Client > > SDK. We installed the ODBC driver and it shows up under Microsoft's > > ODBC Adminstrator tool. We have also installed Informix ESQL/C 7.23 TC9 > > software to provide the TCP/IP connectivity to the Informix db engine > > from the WIN NT 4.0 workstation. We created a hosts file and a services > > file on the WIN NT 4.0 Work station. We created the setnet32 entries and > > ran the ilogin32 program. We made a successful connection to the > > Informix database on our Unix server. > > When we go into the MS ODBC Adminstrator and try to add a File DSN > > data source using the Intersolv ODBC driver, we are unable to make a > > connection. The message we receive was "The setup routines for the > > Intersolve 3.10 32-bit (IVINF913.dll) Informix 9 ODBC driver could not > > be loaded due to system error code 126. Could not load the setup or > > translator library". Any ideas of what to try next? Do all of the > > Informix setnet32 values saved in the ndx files need to be added > > somewhere? Thanks for your assistance!