Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3842
  • 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?

Thanks!
0
Pugglewuggle
Asked:
Pugglewuggle
  • 2
1 Solution
 
kevp75Commented:
try a different connection string
http://www.connectionstrings.com/

also, you should probably try to get MDAC 2.8 installed.
0
 
PugglewuggleAuthor Commented:
Does Windows Server 2008 need MDAC? I thought it uses a new engine for access file system DBs?
0
 
PugglewuggleAuthor Commented:
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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

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