<% dim cn,rs,driver_name driver_name="Provider=MSDAORA.1;Password=pass;User ID=user;Data Source=afis;Persist Security Info=True" set cn = server.CreateObject("adodb.connection") cn.open driver_name set rs=server.CreateObject("adodb.recordset") rs.open "select * from table",cn,3,1 do while not rs.eof response.write rs("field") rs.movenext loop %> 检查用户/密码,连接字符串是否通,细心查看,连接ORACLE不会太难,你做了什么步骤,具体说出来
dim cn,rs,driver_name
driver_name="Provider=MSDAORA.1;Password=pass;User ID=user;Data Source=afis;Persist Security Info=True"
set cn = server.CreateObject("adodb.connection")
cn.open driver_name
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from table",cn,3,1
do while not rs.eof
response.write rs("field")
rs.movenext
loop
%> 检查用户/密码,连接字符串是否通,细心查看,连接ORACLE不会太难,你做了什么步骤,具体说出来
http://download.oracle.com/otn/other/ole-oo4o/OraOLEDB_92020.exe
http://download.oracle.com/otn/other/ole-oo4o/OraWin_92010.exe
http://download.oracle.com/otn/other/ole-oo4o/OraOLEDB_90101.exe
http://download.oracle.com/otn/other/ole-oo4o/OraOLEDB_81730.zip下载odbc驱动:
http://otn.oracle.com/software/tech/windows/odbc/content.html