SQL Toolkit function DBPutRecord returns error msg from Microsoft Access 2.0 ODBC DriverPrimary Software: LabWindows/CVI Add-ons>>Enterprise Connectivity ToolsetPrimary Software Version: 1.0 Primary Software Fixed Version: N/A Secondary Software: N/A
Problem: When trying to update a record in a MS Access 2.0 database, the following error message is returned. [Microsoft][ODBC Access Driver] Jet error -1003 returned This error code means that an invalid API parameter has been passed. The error occurs with the ODBC driver from the Access 2.0 package that comes with Microsoft Office's Professional Edition version 4.3. So far the error will occur with number type columns, either INTEGER or DOUBLE. This error does not occur if the SELECT statement only has text type columns (strings). This problem has been duplicated outside of CVI with Visual C++ using the Intersolv / Q+E Database library QELIB.DLL.. MS Access 2.0 ODBC driver that comes with MS Visual C++ version 1.52 does not exhibit this problem. This driver is defined as the MS ODBC Desktop Driver Pack, 16-bit ODBC driver for Access 2.0. This driver has Level 2 ODBC functionality so the functions that the QELIB.DLL uses are different. Also tried the 32-bit Access driver that comes with Visual C++ 2.0 and had no problems. Solution: The Tier Driver that ships with Access 2.0 is dated 3/31/94 and was not the final version of the MS Access drivers. The latest drivers can be purchased from Microsoft by calling their Fulfillment Operations at 800 360 7561. Request the MS ODBC Desktop Driver Pack, 16-bit ODBC driver for Access 2.0. The cost is $10 should take 2-3+ weeks. You can also install the later versions of VC++ to get this driver pack. Related Links: Attachments:
Report Date: 09/12/1995 Last Updated: 12/05/2004 Document ID: 0DBDEJTL |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
