Solved

Jet driver in IIS 7/ Windows Server 2008?

Posted on 2008-10-14
4
3,827 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Don't Miss ATEN at InfoComm 2017!

Visit booth #2167 to see the  new ATEN VM3200 32 x 32 Modular Matrix Switch. Other highlights include the VE8950 4K HDMI Over IP Extender, VS1912 12-Port DP Video Wall Media Player  and VK2100 ATEN Control System. Register now with Free Pass Code ATEN288!

Question has a verified solution.

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

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

734 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