Microsoft KB Archive/135007

= SQLOpen May Not Be Able to Connect to Oracle Databases =

Article ID: 135007

Article Last Modified on 8/19/2003

-

APPLIES TO


 * Microsoft Excel 5.0c

-



This article was previously published under Q135007



SYMPTOMS
If you use the SQLOpen macro function in a Visual Basic procedure, you may be unable to connect to an Oracle 7.0 database and you may receive the following error message:

S1000

12154

[Oracle][Oracle ODBC Driver][Oracle OCI]ORA-12154: TNS: could not resolve database name.



CAUSE
This problem occurs when you run the SQLOpen function in a Visual Basic procedure while there are several workbooks open in Microsoft Excel. Open workbooks include add-ins, hidden files, Personal.xls, Xl5galry.xls, and any other files opened from the Xlstart folder.



RESOLUTION
To avoid this problem, close any other 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.

