Knowledge Base

Oracle IM006 Error Using SQLOPEN Function

Article ID: 124611

Article Last Modified on 8/15/2005

Microsoft Excel 95 Standard Edition
Microsoft Excel 5.0 Standard Edition
Microsoft Excel 5.0c
Microsoft Excel 5.0a for Macintosh

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:

SQLOpen Function

Additional query words: 5.00c xlodbc.xla msquery XL

Keywords: kbprogramming KB124611