keep gettin this error msg - its sposed to list
items from an access database.

Im using windows 98
ms PWS
and have mdac 2.7 installed

im not sure what else i can do to fix it
thanks for any help


ADODB.Connection error '800a0e7a'

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

/db.asp, line 34



Dim dbc
Dim strConn
Dim strpath

'this procedure is called wherever a connection is needed. Returns 'dbc' as active connection
sub openConn()
'use appropriate connection string
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.MapPath("admin/scart.mdb")

Set dbc = Server.CreateObject("ADODB.Connection")
dbc.open strConn (**line 34**)
end sub

sub closeConn()
if isobject(dbc) then
if dbc.State = adStateOpen then
dbc.Close
end if
set dbc = nothing
end if
end sub
%>

Try to register the driver you are using - I believe you are using the "MS Jet 4 ole db provider" -- if so, find the msjetoledb40.dll and register it manually. If this fails, reinstall mdac.

i didnt even have that dll but tracked down MS Jet containing that dll and installed it - now works

thanks

Happy to help.

FYI - If you continue having problems, reinstall mdac - this may be a result of an incomplete installation and might cause you more problems in the future.

I have the same problem as what rnealejr had. I tried to reinstall msjetoledb40.dll but i dont know how. I never installed any MDAC software. It comes with .net server or sql server i presume. Could anyone please tell me what i should do in order to solve this problem?

ADODB.Connection error '800a0e7a'

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

/connect.inc, line 3

Thanks.

oh..i forgot to mention that i do find msjetoledb40.dll in my computer. PLease let me know what are the steps to solve my problem. Thanks.

To install MDAC you can either use WindowsUpdate.com or download the file manually here http://www.microsoft.com/data/download.htm

Got it! thank you so much!