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,424
    Provided Answers: 8
    After the
    DATA_PATH = ......

    Response.write(DATA_PATH)

    That should answer your question
    hope this help

    See clear as mud


    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 based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  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,424
    Provided Answers: 8
    Not u iis should have read write
    hope this help

    See clear as mud


    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 based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  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
  •