ho trovato come farlo e ora funziona, però ho un altro errore: mi dice che l'oggetto è chiuso...

ADODB.Connection error '800a0e78'
Operation is not allowed when the object is closed.

ecco il codice:

codice:
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "File Name = \Connessione\prova.udl"

Set objRs = objConn.Execute("SELECT * FROM TEST_MATTEO")
Response.Write "<table border=1 cellpadding=4>"
Response.Write "<tr>"
For I = 0 To objRS.Fields.Count - 1
    Response.Write "<td>" & objRS(I).Name & "</td>"
Next
Response.Write "</tr>"
Do While Not objRS.EOF
    Response.Write "<tr>"
    For I = 0 To objRS.Fields.Count - 1
        Response.Write "<td>" & objRS(I) & "</td>"
    Next
    Response.Write "</tr>"
    objRS.MoveNext
Loop
Response.Write "</table>"
objRs.Close
objConn.Close
come faccio?