codice:
<%
sqlServer_name = "xxxxxx"
sqlServer_db = "xxxxxx"
sqlServer_login = "xxxxxx"
sqlServer_password = "xxxxxx"
connString = "Provider=sqloledb;" &_
"Network Library=DBMSSOCN;" &_
"Encrypt=yes;" &_
"Data Source=" & sqlServer_name & ";" &_
"Initial Catalog=" & sqlServer_db & ";" &_
"User Id=" & sqlServer_login &";" &_
"Password=" & sqlServer_password & ";"
set conn = server.createObject("ADODB.Connection")
conn.open connString
sql = "SELECT * FROM tabella1"
set rs = server.createObject("ADODB.Recordset")
rs.open sql, conn, 3, 1
if not rs.eof then
response.write "<table border=""1"">" & vbCrLf
response.write " <tr>" & vbCrLf
for i = 0 to (rs.fields.count - 1)
response.write " <td>" & rs(i).name & "</td>" & vbCrLf
next
response.write " </tr>" & vbCrLf
do until rs.eof
response.write " <tr>" & vbCrLf
for i = 0 to (rs.fields.count - 1)
response.write " <td>" & rs(i) & "</td>" & vbCrLf
next
rs.moveNext
response.write " </tr>" & vbCrLf
loop
response.write "</table>" & vbCrLf
end if
rs.close
set rs = nothing
conn.close
set conn = nothing
%>