Microsoft KB Archive/104452
Article ID: 104452
Article Last Modified on 8/9/2004
- Microsoft Access 1.0 Standard Edition
- Microsoft Access 1.1 Standard Edition
- Microsoft Access 2.0 Standard Edition
This article was previously published under Q104452
Advanced: Requires expert coding, interoperability, and multiuser skills.
When running a query against an ORACLE table, or updating a record in an ORACLE table, the error message
is displayed if the table and field names are very long or the query is very complex.
This is a problem with Sqora.dll, the ORACLE ODBC Driver.
Obtain and install the updated driver, or use queries to do updates, rather than updating records while the ORACLE table is in Datasheet view. The query should yield only the columns to be updated.
For complex queries, reduce the number of tables or joins in the query and reduce the number of fields used or shown in the query.
These workarounds reduce the length of the SQL statements.
Microsoft has confirmed this to be a problem in the ORACLE ODBC driver shipped with Microsoft Access versions 1.1 and 2.0 and Visual Basic for Windows version 3.0 - Professional Edition. An updated driver that corrects this specific problem is available from Microsoft.
Obtaining the Updated Driver
The following file is available for download from the Microsoft Download Center:
The Ora110.exe file contains the files indicated in the "File Contents" section. For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:
119591 How to Obtain Microsoft Support Files from Online Services
Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file. NOTE: This driver is for use only by registered owners of Microsoft Access versions 1.1 and 2.0 and Visual Basic for Windows version 3.0 - Professional Edition. By installing these files, you are indicating that you own one of these products.
The following files are found on the Ora110.exe file:
Readme.txt Btrv110.dll Oracle.txt Sqora.dl_ Sqorastp.dl_ Odbc.inf Setup.exe
NOTE: The Setup.exe file is called by the ODBC Control Panel facility. It will not run as a standalone file.
The following two files will actually be updated:
Old New ------------------------------------------- Sqora.dll Version: 1.00.2816 Version: 1.00.3112 Size: 143,600 bytes Size: 144,096 bytes Date: 4/16/93 Date: 7/12/93 Sqorastp.dll Version: 1.00.2403 Version: 1.00.3106 Size: 9,328 bytes Size: 9,632 bytes Date: 5/7/93 Date: 7/6/93
The Readme.txt file documents both the changes to the Btrieve and ORACLE drivers and the installation procedures for each.
The third-party products discussed here are manufactured by vendors independent of Microsoft; we make no warranty, implied or otherwise, regarding these products' performance or reliability.
Additional query words: Ora110 exe
Keywords: kberrmsg kbdownload kbbug kbgraphxlinkcritical kbfile kb3rdparty KB104452