Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Jet driver in IIS 7/ Windows Server 2008?

Posted on 2008-10-14
4
Medium Priority
?
3,841 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

Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

Question has a verified solution.

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

In the absence of a fully-fledged GPO Management product like AGPM, the script in this article will provide you with a simple way to watch the domain (or a select OU) for GPOs changes and automatically take backups when policies are added, removed o…
The article covers five tools all IT professionals should know about, as they up productivity by a great deal!
This Micro Tutorial will give you a basic overview of Windows DVD Burner through its features and interface. This will be demonstrated using Windows 7 operating system.
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…

971 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