Solved

Jet driver in IIS 7/ Windows Server 2008?

Posted on 2008-10-14
4
3,822 Views
Last Modified: 2012-05-05
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?

Thanks!
0
Comment
Question by:Pugglewuggle
  • 2
4 Comments
 
LVL 25

Expert Comment

by:kevp75
ID: 22758014
try a different connection string
http://www.connectionstrings.com/

also, you should probably try to get MDAC 2.8 installed.
0
 
LVL 12

Author Comment

by:Pugglewuggle
ID: 22782376
Does Windows Server 2008 need MDAC? I thought it uses a new engine for access file system DBs?
0
 
LVL 12

Accepted Solution

by:
Pugglewuggle earned 0 total points
ID: 22854121
Turns out you need "2007 Office System Driver: Data Connectivity Components" to use an Access database in Windows Server 2008.
http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An article on effective troubleshooting
Learn how to PXE Boot both BIOS & UEFI machines with DHCP Policies and Custom Vendor Classes
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

679 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