Problem with using ASP to connect to access database

Siddharth_1

EXTREME
I am having some problem with the ASP code that i am using to connect with access DB
Here is the code:
Code:
<html>
<head>
<link href="theme/iframe_style.css" rel="stylesheet" type="text/css"  />
<%
Dim objConn, strConn, objRS
Set objConn = Server.CreateObject("ADODB.Connection")
strConn = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source= db\softwares.accdb"
objConn.Open strConn
Set objRS = Server.CreateObject("ADODB.RecordSet")
objRS.Open "softwares",objConn
%>
</head>
<body>
<table border=0>
<% While NOT objRS.EOF %>
<tr>
<td><%=objRS("softname")%></td>
<td></td>
</tr>
<%
objRS.MoveNext
Wend
objRS.Close
objConn.Close
Set objConn=Nothing
Set objRS=Nothing
%>
</table>
</body>
</html>

The error i am getting is this:
ADODB.Connection error '800a0e7a'

Provider cannot be found. It may not be properly installed.

/files/dbconnecttest.asp, line 8

Line 8 is ' objConn.Open strConn '.
PLS HELP!!
 

shar_yogi

Broken In
Have you installed Access Database Engine .
For using the ACCDB access database, you will have to download and install the driver on your server/system.
You can get it from here Download Microsoft Access Database Engine 2010 Redistributable from Official Microsoft Download Center.
 
OP
Siddharth_1

Siddharth_1

EXTREME
Using win7 x64.

At last i have solved the problem with the help of this thread in a microsoft forum-
LINK

"Enable 32-bit applications" needs to be enabled in the connection pool for the website, within IIS Manager 7.
 
Top Bottom