Set OraSession = CreateObject("OracleInProcServer.XOraSession") Set OraDatabase = OraSession.DbOpenDatabase("dsn","user/pwd",0) dsn=odbc dsn,user=username,pwd=password Set OraDynaset = WebOraDatabase.DbCreateDynaset(sSql,0)
Dim objconn Dim rs1 set objConn=Server.Createobject("adodb.connection") objConn.Open "odbcname","username","password" sql="select .....from ..." '查询语句 set objrs=server.createobject("adodb.recordset") objrs.open sql,objconn,1
<%
set cn=server.createobject(adodb.connection)
cn.open "Provider=MSDAORA.1;Password=12345;User ID=jy;Data Source=jy;Persist Security Info=True"
set rs=server.createobject(adodb.recordset)
orastr="select aa1 from aa.aa1"
rs.open orastr,cn,1,1
response.write rs("aa1")
rs.close
set rs=nothing
%>
提示“set cn=server.createobject(adodb.connection)”这一行有错误
set cn=server.createobject("adodb.connection")set rs=server.createobject("adodb.recordset")rs.CursorType = 0
rs.CursorLocation = 3
rs.LockType = 3记录集的属性最好设置
Set OraDatabase = OraSession.DbOpenDatabase("dsn","user/pwd",0)
dsn=odbc dsn,user=username,pwd=password
Set OraDynaset = WebOraDatabase.DbCreateDynaset(sSql,0)
有错误
set cn=server.createobject("adodb.connection")
cn.open "Provider=MSDAORA.1;Password=jy12345;User ID=sys;Data Source=jy;Persist Security Info=True"
set rs=server.createobject("adodb.recordset")
orastr="select aa1 from aa.aa1"
rs.open orastr,cn,1,1
response.write rs("aa1")
rs.close
set rs=nothing
时出现“Microsoft OLE DB Provider for Oracle (0x80004005)
/net/oracle.asp, 第 14 行”提示用
Set OraSession = CreateObject("OracleInProcServer.XOraSession")
Set OraDatabase = OraSession.DbOpenDatabase("jy","system/jy12345",0)
dsn=odbc dsn,user=username,pwd=password
sSql="select aa1 from aa.aa1"
Set OraDynaset = WebOraDatabase.DbCreateDynaset(sSql,0)
response.write rs("aa1")
时提示Set OraSession = CreateObject("OracleInProcServer.XOraSession")行的vbscript执行错误
aa1是表空间aa中的表
<!--#include file="Connections/conn.asp" -->
<%
set rs = Server.CreateObject("ADODB.Recordset")
rs.ActiveConnection = MM_conn_STRING
rs.Source = "SELECT employeeno,EMPLOYEE, SBTIME, XBTIME,to_char(sbtime,'hh24:mi:ss') as sb,to_char(xbtime,'hh24:mi:ss') as xb FROM TIMECARD.RECORDS where to_char(sbtime,'yyyy-mm-dd')=to_char(sysdate,'yyyy-mm-dd') ORDER BY SBTIME "
rs.CursorType = 0
rs.CursorLocation = 3
rs.LockType = 3
rs.Open()
%>
........
.........
<%
rs.Close()
rs.activeconnection=nothing
%>
不过我是实在没辙了,总是提示rs.ActiveConnection = MM_conn_STRING不对
看来你还是要看看连接数据库相关书籍!
MM_conn_STRING="Provider=MSDAORA.1;Password=jy12345;User ID=sys;Data Source=jy;Persist Security Info=True"
Dim rs1
set objConn=Server.Createobject("adodb.connection")
objConn.Open "odbcname","username","password"
sql="select .....from ..." '查询语句
set objrs=server.createobject("adodb.recordset")
objrs.open sql,objconn,1