Problem with using ASP to connect to access database

7 posts · originally from https://geek.digit.in/community/threads/problem-with-using-asp-to-connect-to-access-database.165876/

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!!

Pls guys help.

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.

i hav this installed already.

which OS and Access version r u using (64bit or 32bit).

I think the DB object is not being created. Can you debug that variable..?

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.