Re: MS Access 2003: Linked Tables
Richard Spitz asked whether the Informix OLE DB provider can be used in MS Access 2003 without first running the sysmaster script. Ben Thompson said they had used it for years, and Richard confirmed it worked without the script, asking what the CSDK update scripts (uoledbp2021.sql, uoledbp2125.sql) do. scottishpoet quoted the manual saying coledbp.sql must be run. The extra scripts' purpose was left unanswered.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
"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