Article ID: 135007
Article Last Modified on 8/19/2003
APPLIES TO
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.
REFERENCES
For more information about the SQLOpen Function, choose the Search
button in the Visual Basic Reference and type:
Additional query words: xlodbc.xla msquery XL5
Keywords: kberrmsg KB135007