Re: ODBC for Informix v5

Malcolm Whitfield wrote: > > I want to send SQL queries from web pages on our Intranet to a > database we have runnning under Informix v5 on a UNIX box. > > I will be using MS FrontPage to develop the web pages and .IDC/.HTX > files, and our web server is NT4 with IIS3, running on an Intel > platform. > > I have the following questions: > > 1. Do Informix have an ODBC driver for version 5 ? Yes they do. It is called Informix CLI. You will also need Informix Connect on the NT machine. > > 2. If so is it going to be expensive as this is going to be a bit of a > development idea without any budget for any expensive drivers? I believe list price is about $100/node for each product. > > 3. I am right in assuming that there is no inherent problem in > accessing the database from our Intranet web server, even though our > Informix database is on a different platform (UNIX) and connected over > our internal network ? It won't know the difference. I do it all the time. Not to say there are no problems with the connection. We are currently experiencing weirdness when a Visual Basic program using DAO to query Informix5. It appears not to want to release the license it grabs until you shut down the application. Otherwise, it works fine. > > Any feedback will be much appreciated. > Hope it helps. > -- > Malcolm Whitfield > malcolm@mrwhit.demon.co.uk -- Matthew C. Reprogle Delco Electronics - IC Integrated Manufacturing phone: (765)451-9651 Internet: mcreprog@mail.delcoelect.com FAX: (765)451-8230