locked
[Microsoft][ODBC Microsoft Access Driver] Disk or network error RRS feed

  • Question

  • User-964082872 posted

     

    Dear all,

    I am using Windows Vista and Access 2002. My website was working perfect. Now I have shifted to a new machine again on Windows Vista and Office 2007 Standard. I have loaded Access 2002 as Access is not available in the 2007 standard edition.

    Now in the new environment, I am not able to connect to the data base. My ASP page is giving error message as

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

    I have tried setting permission to the IUSR in my database directory.

    Can anyone help me what could be wrong in the new environment?

    Thank you in advance

    Jojy

    <!-- / message -->

    Tuesday, August 3, 2010 7:57 AM

Answers

All replies

  • User-1199946673 posted

    I have loaded Access 2002 as Access is not available in the 2007 standard edition
     

    You don't need Access to connect to an mdb in ASP.NET. But if you have Access you can use it

    Can anyone help me what could be wrong in the new environment?

    Don't use ODBC, but use OLEDB instead:

    http://www.mikesdotnetting.com/Article/78/AccessDataSource-SqlDataSource-and-connecting-to-Access-databases-in-ASP.NET

    And in the following article you can read on which permissions you need to give to which user:

    http://www.mikesdotnetting.com/Article/74/Solving-the-Operation-Must-Use-An-Updateable-Query-error

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, August 3, 2010 9:23 AM
  • User-964082872 posted

    Thanks for the immediate reply

    I have put my mdb file in C:\inetput\db directory and have given full control permission to IUSR on inetpub, db folders and the mdb file.

    I have also given full control permission to IUSR on %temp% directory.

    Still it is not working.

    The code that is giving problem is reproduced below.

    cnstring="DBQ=c:\inetpub\db\rc_master.mdb; DRIVER={Microsoft Access Driver (*.mdb)};"

    set cnn=Server.CreateObject("ADODB.Connection")

    cnn.open cnstring

    At this point it is giving the error message as

    Microsoft OLE DB Provider for ODBC Drivers error '80004005'

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

    /rc/jspbilldet.asp, line 197

    Please help

    Regards,

    Jojy
     

    Wednesday, August 4, 2010 3:15 AM
  • User-1199946673 posted

    Like I already siad, in a web environment you should better use OLEDB rather than ODBC. But since you're using classic asp (.asp) you should find another forum for further questions, since these forums are for ASP.NET (*.aspx) related questions only. Try

    http://forums.iis.net/1032.aspx 

    Wednesday, August 4, 2010 6:07 AM
  • User-964082872 posted

    Thanks for the guidance.

     

    Regards,

    Jojy 

    Wednesday, August 4, 2010 8:27 AM