e)OLE DB Provider for Oracle oConn.Open "Provider=msdaora; Data Source=OracleServer.world;" & _ "User Id=sa; Password=;"i)使用现有的Oracle ODBC Driver from Microsoft: oConn.Open "Driver={Microsoft ODBC for Oracle};" & _ "Server=OracleServer.world; Uid=demo; Pwd=demo;"
duckcn(duck) : 我按你的运行还是错:(Microsoft OLE DB Provider for Oracle (0x80004005) /testora.asp, 第 17 行Microsoft OLE DB Provider for ODBC Drivers (0x80004005) /testora.asp, 第 17 行
OLE DB Provider for Oracle: oConn.Open "Provider=OraOLEDB.Oracle.1;Password=JIGYO;Persist Security Info=True;User ID=JIGYO;Data Source=JIGYO;"
Password=密码 User ID=用户名 Data Source=服务名
新建一个DSN(Oracle ODBC Driver) Set OraSession = CreateObject("OracleInProcServer.XOraSession") Set OraDatabase = OraSession.DbOpenDatabase("dsn","user/pwd",0)
oConn.Open "Provider=msdaora; Data Source=OracleServer.world;" & _
"User Id=sa; Password=;"i)使用现有的Oracle ODBC Driver from Microsoft:
oConn.Open "Driver={Microsoft ODBC for Oracle};" & _
"Server=OracleServer.world; Uid=demo; Pwd=demo;"
我按你的运行还是错:(Microsoft OLE DB Provider for Oracle (0x80004005)
/testora.asp, 第 17 行Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
/testora.asp, 第 17 行
oConn.Open "Provider=OraOLEDB.Oracle.1;Password=JIGYO;Persist Security Info=True;User ID=JIGYO;Data Source=JIGYO;"
User ID=用户名
Data Source=服务名
Set OraSession = CreateObject("OracleInProcServer.XOraSession")
Set OraDatabase = OraSession.DbOpenDatabase("dsn","user/pwd",0)