SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Jul 2005
    Posts
    0
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    [Microsoft][ODBC Microsoft Access Driver] Disk or network error

    Im trying to get IIS7 running classic asp. I got Vista Home premium and MS access 2000, Im getting this error

    Microsoft OLE DB Provider for ODBC Drivers error '80004005'
    [Microsoft][ODBC Microsoft Access Driver] Disk or network error.

    This is the code>>>>>>>>>>>>>>>>>>>>


    <%
    Set oConn = Server.CreateObject("ADODB.Connection")
    oConn.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("weather.mdb"))

    sSQL = "SELECT * FROM temperatures ORDER BY City"
    set oRS = oConn.Execute(sSQL)

    Response.Write("<table border=1 cellpadding=1 cellspacing=1 style='font-family:arial; font-size:10pt;'>")
    Response.Write("<tr bgcolor=black style='color:white;'>")
    Response.Write("<td>City</td>")
    Response.Write("<td>Temperature</td></tr>")

    Do While NOT oRS.EOF
    Response.Write("<tr><td>" & oRS("City") & "</td>")
    Response.Write("<td>" & oRS("Temperature") & "</td></tr>")
    oRS.MoveNext
    Loop

    Response.Write("</table><br><br>")

    oConn.Close
    Set oRS = Nothing
    Set oConn = Nothing
    %>


    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
    There is a problem with the second line.
    ive read other articials that said it was something to do with permissions. Ive tried all the suggestions, but if anyone has any more suggestions they would be appriciated...the more detailed the better

  2. #2
    SitePoint Guru SSJ's Avatar
    Join Date
    Jan 2007
    Posts
    830
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •