Jet driver in IIS 7/ Windows Server 2008?
Posted on 2008-10-14
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?