« Previous Next »

• 06-19-2009, 1:26 PM

  curly101 Joined on 06-19-2009, 3:52 PM Posts 4

  Microsoft OLE DB Provider for ODBC Drivers error '80004005' Reply Contact  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.

• 06-19-2009, 3:52 PM

  In reply to

  tomkmvp Joined on 03-20-2003, 10:27 AM Central NJ Posts 6,061	Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005' Reply Contact http://tutorials.aspfaq.com/8000xxxxx-errors/80004005-errors.html Tom Kaminski IIS MVP http://mvp.support.microsoft.com/ http://blogs.iis.net/tomkmvp/ http://www.linkedin.com/pub/8/690/408 http://www.bluesrepublic.org/

• 06-19-2009, 6:16 PM

  In reply to

  curly101 Joined on 06-19-2009, 3:52 PM Posts 4	Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005' Reply Contact  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.

• 06-22-2009, 9:42 AM

  In reply to

  tomkmvp Joined on 03-20-2003, 10:27 AM Central NJ Posts 6,061	Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005' Reply Contact What is the connection string used? Does this involve anonymous access or authenticated users? Tom Kaminski IIS MVP http://mvp.support.microsoft.com/ http://blogs.iis.net/tomkmvp/ http://www.linkedin.com/pub/8/690/408 http://www.bluesrepublic.org/

• 06-22-2009, 10:30 AM

  In reply to

  Ejikeme Joined on 06-22-2009, 10:11 AM Posts 5

  Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005' Reply Contact 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

• 06-22-2009, 11:09 AM

  In reply to

  tomkmvp Joined on 03-20-2003, 10:27 AM Central NJ Posts 6,061	Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005' Reply Contact 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? Tom Kaminski IIS MVP http://mvp.support.microsoft.com/ http://blogs.iis.net/tomkmvp/ http://www.linkedin.com/pub/8/690/408 http://www.bluesrepublic.org/

• 06-22-2009, 11:15 AM

  In reply to

  curly101 Joined on 06-19-2009, 3:52 PM Posts 4

  Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005' Reply Contact  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

• 06-22-2009, 11:21 AM

  In reply to

  Ejikeme Joined on 06-22-2009, 10:11 AM Posts 5

  Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005' Reply Contact 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

• 06-22-2009, 11:30 AM

  In reply to

  tomkmvp Joined on 03-20-2003, 10:27 AM Central NJ Posts 6,061

  Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005' Reply Contact curly101: MM_connUrge_STRING = "dsn=connUrge;" So you're using a DSN.  I can't tell the details of the connection from that. Why don't you do it this way? http://databases.aspfaq.com/database/what-should-my-connection-string-look-like.html Tom Kaminski IIS MVP http://mvp.support.microsoft.com/ http://blogs.iis.net/tomkmvp/ http://www.linkedin.com/pub/8/690/408 http://www.bluesrepublic.org/

• 06-22-2009, 11:34 AM

  In reply to

  Ejikeme Joined on 06-22-2009, 10:11 AM Posts 5

  Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005' Reply Contact 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

• 06-22-2009, 11:43 AM

  In reply to

  curly101 Joined on 06-19-2009, 3:52 PM Posts 4

  Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005' Reply Contact  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.

• 06-22-2009, 11:49 AM

  In reply to

  Ejikeme Joined on 06-22-2009, 10:11 AM Posts 5

  Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005' Reply Contact 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

• 06-22-2009, 11:53 AM

  In reply to

  Ejikeme Joined on 06-22-2009, 10:11 AM Posts 5	Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005' Reply Contact Dear Curly     I forgot to mention What do you mean by "enctype" thankyou Curley   Sincerely