Re: Cannot connect to Database via ODBC
On 29 Jul 1998 09:59:34 GMT, "Joseph Fiorentino" <joseph.d.fiorentino@magnet.mt> wrote: >Hi, > >We've got an Informix database on a Unix NCR machine. I am trying to access >this database through ODBC and all my efforts have been in vain. >I've installed "Informix Client Software Developer's Kit for Microsoft >Windows Environments" on my Windows 95 PC. This software is on CD Rom. Its >got various options to install - such as ODBC Driver Manager Version 2.5 or >3.0 . Its also got two versions of ODBC drivers - Informix-CLI Version 2.80 >or INTERSOLV Version 3.0.1. > I even removed the default Microsoft ODBC Driver Manager (Ver 3.0) to >install Driver Manager Ver. 2.5 - as instructed in the SDK README document. > >I've tried all combinations. All failed. I tried to access the database >using ILogin. I ran Visual Basic 5.0 and tried to access it from there. > >Most times the program from where I try the connection hangs. > >Can anybody please help ?! Yes. 1. Throw out the shit. It isn't even wirth the CD it came on. As you have foud out it's realy hard to install. Do try to deinstall it in a nice way, and hope that the right Microsoft ODBC Driver Manager remains on your machine. (If not install it from some source.) 2. Go to http://www.openlinksw.com and download their ODBC drivers. Make sure you get the server based version. A 2 user version is free. 3. Install the server part of it on your NCR machine. Use simple defaults for the first install. 4. Install the simple client part of it on your PC. 5. Configure an ODBC datasource via the ODBC manager in your control panel. 5. Start up MS Access. (If you don't allready have it you will want to get hold of a copy anyway. It's a great ad hoc query tool for your database.) 6. Select File, Get external data, Link tables (may be some different menu choices on other versions - this is MS Access for Windows 95 ver. 7.00 7. Find file type ODBC data source. You should be able to do it alone from here. When you have done all this you might want to tell your Informix sales rep why their product was thrown into the garbage can. You gained security options and many other features you will probably need with this exercise as well. PS. It's possible to get the Informix product to work, but it isn't worth the effort except possibly under some special circumstances. Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: http://www.iiug.org/techinfo/faq/faq_top.html (Now with ODBC info under "Third party products".)