Oninit cdi / Archive
Talk to an expert →

Help, Informix 7.3, ODBC, Cognos Impromptu

Posted in 1999

Topics: Installation, Setup & Upgrades, Connectivity: ODBC / JDBC / .NET

Antun Zirdum — — source: Informix-list mailing list archive (1991-1998)

I am a sys admin here, but do not regularly deal with Informix or Unix. We have an HP UX 11 with Informix 7.3. I have been charged (? - and perhaps will be arrested) with installing Cognos Impromptu V5 clients on Win95 and NT. I am not sure what is the best way to go about this. At this point any answers will be appreciated. Basically I would like to set up a 32bit ODBC driver, and have Cognos access the Informix Database through that. Can anyone suggest drivers (Does informix have one? Is it free?) Any others that are better / faster?

↪ replying to Antun Zirdum
Joe Cillis — — source: Informix-list mailing list archive (1991-1998)

We have Informix 7.2x (several different levels) under HP/UX 10.x (again different levels) and connect from Cognos' Impromptu v5 using both the Informix supplied ODBC drivers (CLI-32) and native drivers (I-Connect). I believe that both are now provided on the IDS distribution medium. I don't have my CD in front of me but I remember the directory names to be fairly obvious. I have not had a performance problem using either driver. I would warn you that the connection configuration using Setnet32 can be a little trying the first time through (I think you need setnet32 for both native and ODBC solutions) but once you crack the code, you're golden. Another gotcha, if you have a need to point Impromptu to different machines and/or databases, you will need to use Setnet32 to change your default server before starting Impromptu, otherwise, Impromptu will only see the default server and other connection attempts will fail. I Hope this helps. Joe Cillis Database Administrator The Golub Corporation (Price Chopper Supermarkets) jcillis@aol.com Antun Zirdum wrote in message <369d13cd.0@news.westel.com>... >I am a sys admin here, but do not regularly deal with Informix or Unix. >We have an HP UX 11 with Informix 7.3. >I have been charged (? - and perhaps will be arrested) with installing >Cognos Impromptu V5 clients on Win95 and NT. I am not sure what is the best >way to go about this. At this point any answers will be appreciated. > >Basically I would like to set up a 32bit ODBC driver, and have Cognos access >the Informix Database through that. > >Can anyone suggest drivers (Does informix have one? Is it free?) >Any others that are better / faster? > >

↪ replying to Antun Zirdum
Allan Gould — — source: Informix-list mailing list archive (1991-1998)

Antun Zirdum wrote: > > I am a sys admin here, but do not regularly deal with Informix or Unix. > We have an HP UX 11 with Informix 7.3. > I have been charged (? - and perhaps will be arrested) with installing > Cognos Impromptu V5 clients on Win95 and NT. I am not sure what is the best > way to go about this. At this point any answers will be appreciated. > > Basically I would like to set up a 32bit ODBC driver, and have Cognos access > the Informix Database through that. > > Can anyone suggest drivers (Does informix have one? Is it free?) > Any others that are better / faster? You could try our ODBC driver: SCO SQL-Retriever. We have quite a few users using Impromptu and it works fine. Take a look at http://www.sco.com/vision/products/sqlretriever/ for more information and a downloadable eval. We port for Informix7 on HP UX. Allan Gould (allang at sco dot com) (Please remove anti-spam measures if replying)