Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2006
    Posts
    72

    Unanswered: Error '80004005': could not find file

    Hello

    I am getting the following error using a simple type of script:

    Microsoft OLE DB Provider for ODBC Drivers error '80004005'

    [Microsoft][ODBC Microsoft Access Driver] Could not find file '(unknown)'.

    /sendit.asp, line 20
    The relevant part of sendit.asp looks like this:

    Code:
    Dim DATA_PATH, objDC, objRS, email, user, pass, sendmail,smtpserver,yourpassword,youremail,myCopy
    
    'Maps to database. 
    DATA_PATH=Server.Mappath("USERS.mdb")
       
    ' Create and establish data connection
    Set objDC = Server.CreateObject("ADODB.Connection")
    objDC.ConnectionTimeout = 15
    objDC.CommandTimeout = 30
    
    objDC.Open "DBQ=" & DATA_PATH & ";Driver={Microsoft Access Driver (*.mdb)}; DriverId=25;MaxBufferSize=8192;Threads=20;", "admin", "password" 
    
    
    'objDC.Open "DBQ=" & DATA_PATH & ";Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\inetpub\vhosts\mySite.com\httpdocs\private\USERS.mdb;"
    
    Set objRS = Server.CreateObject("ADODB.Recordset")
    email=request.form("email")
     
    objRS.Open "SELECT * FROM USERS WHERE email = '" & _
               email & "'", objDC, 0, 1
    %>
    What am I doing wrong, please?

    Many thanks.

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,468
    Provided Answers: 10
    After the
    DATA_PATH = ......

    Response.write(DATA_PATH)

    That should answer your question
    hope this help

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
    DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
    THEY'RE BEHIND YOU FOR A REASON

  3. #3
    Join Date
    Feb 2006
    Posts
    72
    Hello myle

    Many thanks for that. It gave me a more specific idea of what to look for (which was it cannot find the path to the database or that the database was corrupt), but I have double checked things and it seem to be what it should be.

    I have checked the file permission of the server and given myself control, read, write etc, but that didn't work out.

    I will contact my Web hosting service in case it is related to 'DATA_PATH=Server.Mappath("USERS.accdb")' which I know they don't like, or I will ask about the 'OLE DB Provider for ODBC Drivers error' which I know amost nothing about!

    Thanks again.

  4. #4
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,468
    Provided Answers: 10
    Not u iis should have read write
    hope this help

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
    DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
    THEY'RE BEHIND YOU FOR A REASON

  5. #5
    Join Date
    Feb 2006
    Posts
    72
    Oh, right, thanks.

    I will check again, thanks.

Posting Permissions

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