asked on

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?

sunithnair

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

jomacapa

ASKER

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

sunithnair

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

ASKER CERTIFIED SOLUTION

jomacapa

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial