set objconn=server.createobject("adodb.connection")
constr="Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=mlm;Password=asd123;Data Source=alias"
objconn.Open constrSQL="select * from test"
set objrs=objconn.execute(SQL)试试
constr="Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=mlm;Password=asd123;Data Source=alias"
objconn.Open constrSQL="select * from test"
set objrs=objconn.execute(SQL)试试
Active Server Pages (0x8002802B)
创建对象 'OraSession' 时出错。
咳!哪为高手能帮我指点迷津,我真是不知道该怎么感谢他才好!
你觉得还有什么可能使我不能成功?
可是我这样做,就不会出现这个命令。这是为什么呢。是我安装缺少什么吗?
<%
set conn=server.createobject("adodb.connection")
constr="Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=mlm;Password=asd123;Data Source=alias"
conn.Open constrSQL="insert into test(a) values(sysdate)"
set rs=conn.execute(SQL)set rs=nothing
conn.close
set conn=nothingset conn=server.createobject("adodb.connection")
dns="Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=mlm;Password=asd123;Data Source=alias"conn.Open dnsSQL="select to_char(a,'hh24:mi:ss') from test"
set rs=conn.execute(SQL)
%>
<table border=1><tr>
<%
i=1
do while (not rs.eof)
%>
<td><%=rs.fields(0).value%></font></td>
<%
if i mod 13 =0 then response.write "<tr></tr>"
i=i+1
rs.movenext
loop
%></tr>
</table>
<%
rs.close
set rs=nothing
conn.close
set conn=nothing
%>