| :: Error #:-2147467259 :: show all messages | Post a New Message | Post a Reply |
 Re: Error #:-2147467259 | Post a Reply |
from: Washington, DC
The first thing to do is make sure that your database connection is working. To do that, run the sample code below in a blank ASP page on your server.
Dim objConn, objRS, strConn
'TODO: Change Table1 below to an existing table name in your database
strSQL = "SELECT * FROM Table1"
strConn = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=Y:\database.mdb;"
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open strConn
Set objRS = objConn.Execute(strSQL)
If Not objRS.EOF Then
Do While Not objRS.EOF
Response.Write objRS(0) & "<br>"
objRS.MoveNext
Loop
objRS.Close
End If
Set objRS = Nothing
objConn.Close
Set objConn = Nothing
Let me know if you get any errors
-------------------------
Ghost