Oracle IM006 Error Using SQLOPEN Function (124611)
The information in this article applies to:
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows NT 5.0
- Microsoft Excel for Windows 5.0c
- Microsoft Excel for the Macintosh 5.0a
This article was previously published under Q124611 SYMPTOMS
When you use the SQLOpen function in a Visual Basic procedure in
Microsoft Excel, you may receive the following SQL error message:
IM006 [Microsoft][ODBC.DLL] SQLSetConnectOption Failed
CAUSE
This error occurs when you run the procedure that contains the SQLOpen
function while three workbooks are open in Microsoft Excel. The problem
occurs if the SQLOpen function establishes a connection to an Oracle 6 or
Oracle 7 data source.
Note that this problem also occurs in Microsoft Excel version 5.0c
while four workbooks are open. Open workbooks include add-ins, hidden
files, PERSONAL.XLS, XL5GALRY.XLS, and any other files opened from
the XLSTART directory.
WORKAROUND
To avoid this error message, close any additional open workbooks, and
delete any unneeded worksheets within the workbook that contains the
procedure before you run the procedure.
Additionally, you may need to close other applications that are
running, and take standard troubleshooting steps to make more memory
available.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article. We are researching this problem
and will post new information here in the Microsoft Knowledge Base as it
becomes available.
REFERENCES
For more information about the SQLOpen Function, choose the Search
button in the Visual Basic Reference and type:
| Modification Type: | Minor | Last Reviewed: | 8/15/2005 |
|---|
| Keywords: | kbProgramming KB124611 |
|---|
|