• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 804
  • Last Modified:

problems using mdb access database sbs 2008

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?
  • 2
  • 2
1 Solution
Can you see if the SBS server has the latest MDAC drivers installed.
You can check the version of MDAC like this http://support.microsoft.com/kb/301202
and the download latest drivers from http://www.microsoft.com/downloads/details.aspx?familyid=6c050fe3-c795-4b7d-b037-185d0506396c if the box does not have it
jomacapaAuthor Commented:
it  has the latest MDAC drivers, the problem is that MS ACCESS is not there, just SQL
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
jomacapaAuthor Commented:
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

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now