Microsoft OLE DB Provider for ODBC Drivers error '80004005'RSS

10 replies

Last post Jun 22, 2009 11:53 AM by Ejikeme

  • Microsoft OLE DB Provider for ODBC Drivers error '80004005'

    Jun 19, 2009 01:26 PM|curly101|LINK

     Hi,

    We're running Server 2003, and we have a number of websites on our server that are running Access Databases.

    For some reason, last week, none of the websites/web pages that have an ASP Access connection, are working. We've searched google for answers and all we get are "permission" settings...but for every website? We've checked the settings and they are fine. We've even uninstalled and reinstalled ASP.

    Here is the error:

    Microsoft OLE DB Provider for ODBC Drivers error '80004005'

    [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.

    /default.asp , line 9

    It points to the same line on every website: rsBio_cmd.ActiveConnection = MM_connMGW_STRING

    Any assistance would be appreciated. Thanks.
  • Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005'

    Jun 19, 2009 06:16 PM|curly101|LINK

     Thanks. I've seen you post that page before, and I've been to it. But it doesn't show me anything we haven't tried already. None of those options worked.

     

    Thanks.

  • Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005'

    Jun 22, 2009 09:42 AM|tomkmvp|LINK

    What is the connection string used?

    Does this involve anonymous access or authenticated users?

  • Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005'

    Jun 22, 2009 10:30 AM|Ejikeme|LINK

    My Form buttons do not work when i save as DataAccessPage.

     

    Before i even got to DataAccessPage my forms refused to save as webpage.

    when it finally saved as webpage the buttons wouldnt work.

    I received error messages like "the provider" being ms OLE provider.

    i have used ms script editor to edit vb command script.

    the response i get when i click the button is "stack 10 overflow"

    I have also been reading up on dhtml and it says that i can run vb command scripts with iis.

    this has led me to your forum.

    How do i install IIS to run my Buttons on DataAccessPage.

    Or is there something that i am not doing right to activate form buttons on dataAccessPage

     yOur advise will be appreciated

     

    Sincerely 

     

  • Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005'

    Jun 22, 2009 11:09 AM|tomkmvp|LINK

    I have no idea what you're talking about.  I am not familiar with a DataAccessPage.  Perhaps this is something for an MS Access forum?

  • Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005'

    Jun 22, 2009 11:15 AM|curly101|LINK

     Here is our connection...

     

    <%
    ' FileName="Connection_odbc_conn_dsn.htm"
    ' Type="ADO"
    ' DesigntimeType="ADO"
    ' HTTP="true"
    ' Catalog=""
    ' Schema=""
    Dim MM_connUrge_STRING
    MM_connUrge_STRING = "dsn=connUrge;"
    %>

     

    Anyone who goes to any MS Access page, on any of the sites, can't see it. They get the following error:

    Microsoft OLE DB Provider for ODBC Drivers error '80004005'

    [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.

    /default.asp, line 9

    Line 9: rsHomePageBody_cmd.ActiveConnection = MM_connUrge_STRING

     

  • Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005'

    Jun 22, 2009 11:21 AM|Ejikeme|LINK

    Dear friend they are all inter-twined.

    Form = ms acess

    howwever it stops being access when saved as a webpage.

    I received a message stating "provider" begin ms ole provider .

    I joined this forum when i had that you have been having problems with ole db provider approximately when i started converting my files to webpages.

     

    anyway thankyou for your time

     

    Sincerely

  • Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005'

    Jun 22, 2009 11:34 AM|Ejikeme|LINK

    Dear Curley

         I dont know if our problems are related, I dont know if its just a virus

    I had problems converting my forms to DataAcessPage,(ie re - register ole) message kept coming up.

    When i finally registered to microsoft ole db my forms were able to convert but my buttons dont work.

    is it a virus?, is it ms ole db provider .

    Are you farmilar with dataAccessPages and am i doing anything wrong.

     

    Sincerely

     

    Ejike 

  • Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005'

    Jun 22, 2009 11:43 AM|curly101|LINK

     Wish I could help you, but I am not sure what you are referring to. When you say "dataAccessPages", do you mean a web page with a Microsoft Access database on it? If so, you might want to check your buttons...are you setting it to Post, Get, and is your enctype correct? You should play with them and see what happens/works.

  • Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005'

    Jun 22, 2009 11:49 AM|Ejikeme|LINK

    yes its an ms access Form converted to a webpage but not yet published and the buttons dont work.

    I have been playing with them as suggested however i gave up to seek fresh ideas.

    My html and vb landguage is not too strong however i have tried various commands unsussefully.

    you suggested post and get can you elaborate on both languages so i can have another go.

     

    Sincerely

  • Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005'

    Jun 22, 2009 11:53 AM|Ejikeme|LINK

    Dear Curly

        I forgot to mention

    What do you mean by "enctype"

    thankyou Curley

     

    Sincerely