Microsoft KB Archive/124611

= Oracle IM006 Error Using SQLOPEN Function =

Article ID: 124611

Article Last Modified on 8/15/2005

-

APPLIES TO


 * 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.

