asp连数据库的问题 - Web 开发 / ASP

asp连接oracle时报错： ADODB.Connection (0x800A0E7A) 未找到提供程序。该程序可能未正确安装。
asp中的代码如下：
VBScript code:

Dim MM_conora_STRING
MM_conora_STRING = "Provider=OraOLEDB.Oracle.1;User ID=lan;password=lan"
dim conn ,rs ,sql
set conn = server.CreateObject("adodb.connection")
conn.open MM_conora_STRING
set rs = server.CreateObject("adodb.recordset")
sql = "select * from users"
rs.open sql,conn,3
if rs.eof = false then
response.Write(rs("name") & "" & rs("pwd"))
end if



但如下代码在VB中却能正常运行：
VB code:

Dim conn As Object
Dim rs As Object
Dim sql As String
sql = "select * from users"
Set conn = CreateObject("adodb.connection")
Set rs = CreateObject("adodb.recordset")
conn.Open "Provider=OraOLEDB.Oracle.1;User ID=lan;password=lan"
rs.Open sql, conn, 3
If rs.EOF = False Then
Debug.Print rs("name") & "" & rs("pwd")
End If



这是为什么？

---

MM_conora_STRING = "Provider=OraOLEDB.Oracle.1;User ID=lan;password=lan"