set SqlConn=server.CreateObject("ADODB.CONNECTION")
SqlConn.Provider="OraOLEDB.Oracle.1"
SqlConn.Open "server=198.168.0.100;Password=wasuser;Persist Security Info=True;User ID=was;Data Source=was"
End function
SqlConn.Provider="OraOLEDB.Oracle.1"
SqlConn.Open "server=198.168.0.100;Password=wasuser;Persist Security Info=True;User ID=was;Data Source=was"
End function
cn.Provider="MSDAORA.1"
cn.Open "password=wasuser;persist security info=true;user id=was;data source=was"
set rs=server.CreateObject("adodb.recordset")
' rs.CursorLocation=adUseserver
rs.CursorType=adOpenForwardOnly
strsql="select rname,frompage from wv_archcontent " & _
"where archid=(select getidbypos((select arcloc from regyzdata where cqxz='2007072341')) from dual) " & _
"order by frompage"
rs.Open strsql,cn本来可以 运行的,但是每次重启服务器,就报“http500内部服务器错误”
=============================
需要定义本地服务名称,不能直接使用ip地址