<%
set rs1 = Server.CreateObject("ADODB.Recordset")
rs1.ActiveConnection = MM_conn_STRING
rs1.Source = "SELECT DEPARTMENT, DEPARTMENTNO, EXPERTNAME, EXPERTNO, IMAGE, SYNOPSIS, TYPENUM, ZC, SPECNAME, SPECNO FROM ZDWY.EXPERT_VIEW1 WHERE TYPENUM = '1' AND SPECNO='" + Replace(v_specno, "'", "''") + "'"
rs1.CursorType =2
rs1.CursorLocation = 3
rs1.LockType = 3
rs1.Open()
%>注明一点,是用odbc连接oracle。
<% rs1.PageSize=5
。%>
把此属性设为3就可以使用了rs1.CursorLocation = 3
set rs1 = Server.CreateObject("ADODB.Recordset")
rs1.ActiveConnection = MM_conn_STRING
rs1.Source = "SELECT DEPARTMENT, DEPARTMENTNO, EXPERTNAME, EXPERTNO, IMAGE, SYNOPSIS, TYPENUM, ZC, SPECNAME, SPECNO FROM ZDWY.EXPERT_VIEW1 WHERE TYPENUM = '1' AND SPECNO='" + Replace(v_specno, "'", "''") + "'"
rs1.CursorType =2
rs1.CursorLocation = 3
rs1.LockType = 3
rs1.Open()
%>注明一点,是用odbc连接oracle。
<% rs1.PageSize=5
。%>
把此属性设为3就可以使用了rs1.CursorLocation = 3
rs1.CursorLocation = 3
rs1.LockType = 3
"Provider=MSDAORA.1;Password=zdwy;User ID=zdwy;Data Source=bosweb;Persist Security Info=True"
这种连接字符串也可行,找天分别讨论在三种连接字符串不同点。
1、odbc
2、oledb
3、msdaora.1