ACC: SQORA.DLL Does Not Allow Lengthy SQL Statements (104452)
The information in this article applies to:
- Microsoft Access 1.0
- Microsoft Access 1.1
- Microsoft Access 2.0
This article was previously published under Q104452 Advanced: Requires expert coding, interoperability, and multiuser skills.
SYMPTOMS
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.
Modification Type: | Minor | Last Reviewed: | 8/9/2004 |
---|
Keywords: | kbdownload kb3rdparty kbbug kberrmsg kbfile kbgraphxlinkcritical KB104452 |
---|
|