Ho provato due metodi di connessione ad un database, mi potreste spiegare le differenze, a prima vista danno lo stesso risultato?
1.
<%
set conn = server.createobject ("ADODB.Connection")
conn.open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & server.mapPath("database\archivio.mdb")
sql = "SELECT * FROM film ORDER BY IDFILM DESC"
set rs = conn.execute(sql)
do until rs.eof
%>
FILM: <%=rs("film")%>
<%
rs.moveNext
loop
rs.close
set rs = nothing
conn.close
set conn = nothing
%>
2.
<%
Dim Conn, rs, strConn
Set Conn=Server.CreateObject("ADODB.Connection")
strConn="driver={Microsoft Access Driver (*.mdb)}; "
strConn=strConn & " DBQ=" & Server.MapPath("database/archivio.mdb")
Conn.Open strConn
sql = "SELECT * FROM film order by IDFILM DESC"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sql, conn ,3,3
do while not (rs.EOF)
%>
FILM: <%=rs("film")%>
<%
rs.movenext
loop
rs.Close
set rs = Nothing
Conn.close
set Conn = Nothing
%>
Grazie.
Rispondi quotando
