ACC: SQORA.DLL Does Not Allow Lengthy SQL Statements

 Last reviewed: October 21, 1997
Article ID: Q104452
The information in this article applies to:
  • Microsoft Access versions 1.0, 1.1, 2.0

SYMPTOMS

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 

   Statement was longer then allowable maximum 2000+ chars
is displayed if the table and field names are very long or the query is very complex.

CAUSE

This is a problem with SQORA.DLL, the ORACLE ODBC Driver.

RESOLUTION

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.

STATUS

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.

MORE INFORMATION

Obtaining the Updated Driver

 ~ ORA110.EXE (size: 125490 bytes) 

   is available for download from the Microsoft Software Library. It
   contains the files indicated in the "Disk Content" section.
For more information about downloading files from the Microsoft Software Library, please see the following article in the Microsoft Knowledge Base: 

   ARTICLE-ID: Q119591
   TITLE     : How to Obtain Microsoft Support Files from Online Services
If you are unable to download the file, Microsoft Technical Support can provide the data on disk, which also includes an updated Btrieve driver.

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.

Disk Contents

The following files are found on the disk: 

   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 on the disk 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: softlib
Keywords : OdbcOthr Softlib kb3rdparty kberrmsg kbfile
Version : 1.0 1.1 2.0
Platform : WINDOWS
Hardware : x86
Issue type : kbbug
Solution Type : kbworkaround

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: October 21, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.