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

Jet driver in IIS 7/ Windows Server 2008?

Hi, I just moved a web app we're working on over to an IIS 7.0/Windows Server 2008 server.

We are getting this error:

ADODB.Connection error '800a0e7a'
Provider cannot be found. It may not be properly installed.
/global/includes/declare.inc, line 26
Here is my code on the related lines, trying to open a connection to an MDB file with the MS Jet DB driver.
24:> Set CTLconn = Server.CreateObject("ADODB.Connection")
25:> Set CTLrs = Server.CreateObject("ADODB.Recordset")
26:> CTLconn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/db/mdb.mdb")

Do I seriously need to install MDAC on WS 2008 or is this something else altogether? Is it still called MDAC in 2008?
Without using SQL Server, is there any better way to access a plain MDB file in IIS7?

  • 2
1 Solution
try a different connection string

also, you should probably try to get MDAC 2.8 installed.
PugglewuggleAuthor Commented:
Does Windows Server 2008 need MDAC? I thought it uses a new engine for access file system DBs?
PugglewuggleAuthor Commented:
Turns out you need "2007 Office System Driver: Data Connectivity Components" to use an Access database in Windows Server 2008.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

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