OraOLEDB (0x80004005) 求解
asp页面代码
<%
Dim Conn
Dim ConnStr
Set Conn = Server.CreateObject("ADODB.Connection")
ConnStr = "Provider=OraOLEDB.Oracle.1;Password=SHOPMAN;Persist Security Info=True;User ID=SHOPMAN;Data Source=orcl "
Conn.Open ConnStr
%>
提示:
错误类型:
OraOLEDB (0x80004005)
ORA-12154: TNS: 无法解析指定的连接标识符
/oracle/ConnDB.asp, 第 6 行
orcle的配置:
# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
ORCLSERVER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 08FFD6C7499D459)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 58.199.20.19)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)