Re: MS Access 2003: Linked Tables

"scottishpoet" <dryburghj@yahoo.com> schrieb: >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. Is it possible to use the OLE DB driver without first having run this script? I seem to remember getting error messages to that effect, but it has been a while. Regards, Richard

Richard Spitz wrote: > Is it possible to use the OLE DB driver without first having run this script? > I seem to remember getting error messages to that effect, but it has been > a while. Well we've been using it for years... Ben.

Richard Spitz <Richard.Spitz@med.uni-muenchen.de> schrieb: >Is it possible to use the OLE DB driver without first having run this script? >I seem to remember getting error messages to that effect, but it has been >a while. Just found out that it is indeed possible to use OLE DB without having run the script against sysmaster. Bummer! There are several OLEDB-related scripts that come with CSDK. One to create OLEDB support (coledbp.sql), one to remove it (doledbp.sql) and two to update the supported versions: uoledbp2021.sql and uoledbp2125.sql. The manual only mentions the former two but not the latter, and the instructions for upgrading from previous versions say to first run the remove script and then the create script. So what are the latter two for? Does installation of OLEDB support through the script mentioned above only affect native OLEDB access to the database, or could the Informix ODBC driver also be affected? Regards, Richard

You can run it however the manual does say : "After installation, you must run the script coledbp.sql on the Informix server against the sysmaster database as user informix. IBM Informix OLE DB Provider requires the stored procedures added to the server by the coledbp.sql script. The script is located in the INFORMIXDIR\\etc directory." http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.oledb.doc/oledbmst29.htm