ASP为什么连不上ORACLE 数据库?
hwfth 2008-04-21 08:39:10 ASP与ORACLE数据库连接,报错!PLSQL与PB都能连接成功!
ADODB.Connection 错误 '800a0e7a'
未找到提供程序。该程序可能未正确安装。
/INI.ASP,行 47
INI.ASP代码:
Sub GetConnection(connDBC, byval in_sDatabaseName, byval in_sUserName,byval in_sPassword)
Dim CnString
Set connDBC= Server.CreateObject("ADODB.Connection")
CnString="PROVIDER=OraOLEDB.Oracle.1;Password=ora9;Persist Security Info=True;User ID=ora9;Data Source=ytzczx"
connDBC.CursorLocation=3
connDBC.Open CnString
End Sub
tns配置:
ytzczx =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 134.226.9.87)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ytzczx)
)
)
请高手指点!!谢谢