Adodb connection ошибка 800a0e7a

So I am going back to a project I created in College, so I can transfer it to PHP. I orginally coded it in ASP Classic.

I am on Windows 8 and running Access 2013.

I am currently getting the following error

ADODB.Connection error ‘800a0e7a’
Provider cannot be found. It may not be properly installed.
/PROJECT!Better/verifyuser.asp, line 11

and this is my connection string code.

Dim vPath, pPath, Conn

vPath = ".dbComic.accdb"
pPath = Server.MapPath( vPath )

objConn = "PROVIDER=Microsoft.ACE.OLEDB.12.0;DATA SOURCE=" & pPath & ";"
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open objConn

any help that you can provide would be awesome!

edit: I already have the enable 32-bit applications in IIS Activated

Hey guys….can someone help me please
i’m running an asp application on a windows 7 home premium (64 bit)
and i keep getting this error over and over ADODB.Connection error ‘800a0e7a’ Provider cannot be found. It may not be properly installed. (line 68)

here is the code :

dim fname, lname, minitial, email, phone, dob, grade
dim CardNumber, PWord, reminder, fullname, fixm
dim ActiveP, Resident, FriendsExp, prob, holdcard
dim fnx, lnx, mnx, rs, pIndex, Fdate, DobDate
dim adding
dim fdatedata, dobdatedata
dim Name, City, State, Contacted, lastEmailed, SecondToLastEmailed, Comments
dim MuseumPasses, Title

pIndex = Request.Form(«pIndex»)
contacted = Request.Form(«iActive»)
MuseumPasses = Request.Form(«iResident»)
LastEmailed = Request.Form(«iFriendsExDate»)
name = Request.Form(«iTitle»)
email = Request.Form(«iEmail»)
SecondToLastEmailed = Request.Form(«iDOB»)
Comments = Request.Form(«iCardNumber»)
City = Request.Form(«iPassword»)
State = Request.Form(«iReminder»)
adding = request.form («adding»)

Title = Request.Form («Title»)
prob = name
prob = Replace(prob, » «, » «)
holdcard = request.form(«holdcard»)

if NOT IsValidEmail(email) Then
response.write «Bad Email Address, not updated»
response.end
end if

if len(state) > 2 then

state = left(state,2)
end if
if request.form(«Submit») = «Delete Prospect Information» then
response.write «<center><FORM Action=’mlremove.asp’ Method=’POST’ Name=’ATA’>»
response.write «Are you sure you want to delete: » & name & » » & email & «?»
response.write «<P><input type=’submit’ name=’yes’ value=’yes’>&nbsp;&nbsp;&nbsp;»
response.write «<input type=’submit’ name=’no’ value=’no’>»
response.write «<input type=’hidden’ name=’indexer’ value=» & pIndex & «>»
Response.write «</form></center>»
response.end
end if

if MuseumPasses = 1 then
MuseumPasses = myTrue
else
MuseumPasses = myFalse
end if

if Contacted = 1 then
Contacted = myTrue
else
Contacted = myFalse
end if

set dbconn = Server.CreateObject(«ADODB.Connection»)
dbconn.ConnectionString = strConn
dbconn.Open (thats the line where i get the error)

IF request.Form(«update») <> «update» then

set rs = Server.CreateObject(«ADODB.recordset»)
rs.CursorLocation = 3
sql = «SELECT name, email FROM MailList WHERE email = ‘» & email & «‘;»
rs.open sql, dbconn
if rs.RecordCount <> 0 then
fnx = rs(«name»)
rs.close
set rs = nothing
dbconn.close
set dbconn = nothing
response.redirect «mlAdd.asp?bd=6&per=» & escape(prob) & «&cn=» & email
end if
rs.close
set rs = nothing
sql=»»

the connection string that im using to connect to my Microsot Sql Server 2012 database is the following :

strConn=»Provider=SQLNCLI;Server=*****;Database=** ***;Trusted_Connection=yes;»

So i was thinking probably the provider is not correct ?
I need help guysssssssssssssss pleaseeeeeeeeeeeee thats an end of study project for my school

Article ID: 1441, Created: May 26, 2013 at 11:41 PM, Modified: May 26, 2013 at 11:41 PM

Solution 1

Check the site’s Application Pool in IIS / Application Pools / YourPool / Advanced Settings :

• Advanced / Enable 32-Bit Applications: True

There’s some anecdotal evidence to suggest you do this too:

• Managed Pipeline Mode : Classic

Solution 2

You should use the provider available in your machine.

1. Goto Control Panel
2. Goto Administrator Tools
3. Goto Data Sources (ODBC)
4. Click the «Drivers» tab.
5. Do you see something called «SQL Server Native Client»?

See the attached screen shot. Here my provider will be SQLNCLI11.0

Solution 3

I got the same issue and It got solved by installing Oracle 11g client in my machine..

I have not installed any excclusive drivers for it. I am using windows7 with 64 bit. Interestignly, when I navigate into the path Start > Settings > Control Panel > Administrative Tools > DataSources(ODBC) > Drivers. I found only SQL server in it

Related videos on Youtube