Microsoft KB Archive/112446

= PRB: SQORA.DLL Does Not Allow Lengthy SQL Statements in VB 3.0 =

Article ID: 112446

Article Last Modified on 8/5/2004

-

APPLIES TO


 * Microsoft Visual Basic 3.0 Professional Edition
 * Microsoft Access 1.1 Standard Edition

-



This article was previously published under Q112446



SYMPTOMS
If the table and field names are long or the query is complex, executing a query or updating a record in an Oracle table results in the following error message:

Statement was longer then allowable maximum 2000+ chars



CAUSE
This occurs because of a problem with SQORA.DLL, the Oracle ODBC driver.



RESOLUTION
Obtain and install the updated driver (instructions are provided in the More Information section below), or use queries to do updates rather than updating records with the Oracle table in Datasheet view. The query should yield only the columns to be updated. For complex queries, reduce both the number of tables or joins in the query and the number of fields used or shown in the query. This reduces the lengths of SQL statements.



STATUS
Microsoft has confirmed this to be a problem in the Oracle ODBC driver shipped with Microsoft Access version 1.1 and the Professional Edition of Microsoft Visual Basic version 3.0. An updated driver that corrects this specific problem is available for owners of Microsoft Access version 1.1 or the Professional Edition of Microsoft Visual Basic version 3.0.



How to Obtain the Updated Driver
The updated Oracle ODBC driver (SQORA.DLL) is available for use by registered owners of:


 * Microsoft Access version 1.1
 * Professional Edition of Visual Basic version 3.0

By downloading the new driver, you are indicating that you own one or both of these two products. To obtain the updated driver, download and then run ORA110.EXE, a self-extracting file.

The following file is available for download from the Microsoft Download Center:

Ora110.exe

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.

Contents of ORA110.EXE
README.TXT - a copy of this article ORACLE.TXT SQORA.DL_ SQORASTP.DL_ ODBC.INF SETUP.EXE NOTE: The SETUP.EXE file is called by the ODBC control panel facility and will not run as a stand-alone file.

How to Install the Updated Driver

 * 1) Start Windows if it is not running.
 * 2) * If you are running Windows 3.1, open Control Panel.
 * 3) * If you are running Windows 3.0 or NT, select the ODBC program group.
 * 4) Double-click the ODBC icon.
 * 5) From the Data Sources dialog, select the Drivers... button.
 * 6) From the Drivers dialog, select Add...
 * 7) Enter the drive letter and directory from which you are installing.
 * 8) Select Oracle from the list of available drivers, and choose OK. ODBC setup will install the driver at this point. If an ODBC Oracle driver of the same version number or higher exists on the hard disk, ODBC setup will ask if you want to replace it. In most cases, you will want to stay with the most recent version.
 * 9) Choose close, and you are finished.

What ODBC Setup Installed
The ODBC installation installed a new SQORA.DLL, a new SQORASTP.DLL, and a new ORACLE.TXT to your Window's system directory.                          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 Oracle drivers are manufactured by Oracle Corporation and Btrieve drivers by Btrieve Technologies, Inc. These two vendors are independent of Microsoft; we make no warranty, implied or otherwise, regarding these products' performance or reliability.

Additional query words: 1.10 3.00 softlib

Keywords: kbdownload kbfile kbprb kb3rdparty kbsample KB112446

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.