problems using mdb access database sbs 2008

Posted on 2009-02-13
Last Modified: 2012-05-06
I upgrade my sbs 2003 to sbs 2008 , and have a webpage with a microsoft access database that was working perfect in sbs 2003 but when I try to use it in sbs 2008 I got an error:

Server Error in '/' Application.
Provider cannot be found. It may not be properly installed.

I ran the ODBC in sbs 2008 an saw that there are only SQL drivers, I found on internet that I can run ODBC from C:\Windows\SysWOW64\odbcad32.exe, then I add my database there but still not working.

I  am atthaching the database connector :
' DATABASE = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=database.mdb"
Dim DATABASE As String
DATABASE = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Inetpub\wwwroot\database\database.mdb"

thinking that the web page was damaged by mistake I installed IIS in XP machine and ran the webpage same as before and it is working really well.

can somebody help me with this issue?
Question by:jomacapa
    LVL 16

    Expert Comment

    Can you see if the SBS server has the latest MDAC drivers installed.
    You can check the version of MDAC like this
    and the download latest drivers from if the box does not have it
    LVL 2

    Author Comment

    it  has the latest MDAC drivers, the problem is that MS ACCESS is not there, just SQL
    LVL 16

    Expert Comment

    Hmmm that may be the problem then I think I had faced the similar situation in one of my project but I was not using ms access directly but created a linked server to it from sql server
    LVL 2

    Accepted Solution

    go here and follow the instructions
    after that  open CMD and run
    %windir%\system32\inetsrv\appcmd.exe set config -section:system.webServer/httpCompression /-[name='xpress']

    PROBLEM SOLVED after 2 working days and nights

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Suggested Solutions

    Title # Comments Views Activity
    2 isp for one site 5 62
    IIS 8.5 state 1 65
    IIS 8.5 10 38
    Browser authentication 1 39
    Lync server 2013 Backup Service Error ID 4049 – After File Share Migration
    When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now