XL: Oracle IM006 Error Using SQLOPEN Function

WINDOWS         | MACINTOSH

The information in this article applies to:

• Microsoft Excel for Windows, versions 5.0, 5.0c
• Microsoft Excel for the Macintosh, versions 5.0, 5.0a
• Microsoft Excel for Windows NT, version 5.0
• Microsoft Excel for Windows 95, version 7.0

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