Oninit cdi / Archive
Talk to an expert →

Re: MS Access 2003: Linked Tables

Posted in 2005

Topics: Connectivity: ODBC / JDBC / .NET, Versions, Editions & End-of-Life

Richard Spitz — — source: Usenet: comp.databases.informix

Dear Informixers, a while ago I posted a question about a problem linking IDS 7.31UD8 tables into MS Access 2003 using the Informix ODBC driver from I-Connect 2.81TC3. This driver is in the file "iclit09b.dll" in the INFORMIXDIR\\bin directory and has version # 3.82.0.11811. In the meantime, I found that the ODBC driver from the previous Connect version 2.81TC2 works; it has version # 3.82.0.11600. Just copying the older dll over the newer one did the job. I still wonder why IBM/Informix cannot get their act together and supply ODBC drivers that just work. From sporadic postings in this group, I gather that even the ODBC driver from the newest 2.90 program suite still has problems, especially with Access. However, from the low number of postings about this topic, I assume that not many peoply bother using Informix's driver... Regards, Richard

↪ replying to Richard Spitz
Ben Thompson — — source: Usenet: comp.databases.informix

Richard Spitz wrote: > I still wonder why IBM/Informix cannot get their act together and > supply ODBC drivers that just work. From sporadic postings in this > group, I gather that even the ODBC driver from the newest 2.90 > program suite still has problems, especially with Access. However, > from the low number of postings about this topic, I assume > that not many peoply bother using Informix's driver... I don't use the ODBC drivers with Access so can't comment on your original problem. I somewhat agree with the sentiment about CSDK. We have a serious problem with updating blob values through OLE DB where the driver leaks memory very quickly and the executable performing the operation can grow to hundreds of megabytes within seconds. It was confirmed as a bug in 2.81 when we had direct access to IBM Technical Support. It's still a problem in 2.90.TC1 and we are trying to get OpenPSL to exert what pressure they can on IBM to fix it. Whether our experience is typical or not I don't know. Ben.

↪ replying to Ben Thompson
scottishpoet — — source: Usenet: comp.databases.informix

ben, do you have the bug number?

↪ replying to scottishpoet
scottishpoet — — source: Usenet: comp.databases.informix

There was a CSDK problem related to a memory leak.This is bug 169500. This problem should be resolved if you run the coledb.sql script. Do you know if you have run this script?

Glossary