M
Martin Franklin
I am trying to get a total record count on a Acess 97 mdb database. However
I get the following error when I try to load the page:
Provider error '80040154' Class not registered
http://www.assetresearch.com/clog/count.asp
I believe permissions for the IUSR_machine are correct as I am able to add
and delete records from the database through other ASP pages in the site.
Any ideas on what Class needs to be re-registered. If so, how do I do it?
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("clogin.mdb"))
conn.CursorLocation = 3
set rs=Server.CreateObject("ADODB.recordset")
sql="SELECT * FROM users"
rs.Open sql,conn
if rs.Supports(adApproxPosition)=true then
i=rs.RecordCount
response.write("The number of records is: " & i)
end if
rs.Close
conn.Close
%>
Any help is this matter is greatly appreciated
--
Best Regards,
Martin Franklin
(e-mail address removed)
Asset Research Services, Inc.
PO Box 7562
Chandler, Arizona 85246
Phone (800) 783-9636 or (480) 940-4290
Extension 213
Fax (888) 496-5736 or (480) 496-5735
Web: WWW.AssetResearch.Com
I get the following error when I try to load the page:
Provider error '80040154' Class not registered
http://www.assetresearch.com/clog/count.asp
I believe permissions for the IUSR_machine are correct as I am able to add
and delete records from the database through other ASP pages in the site.
Any ideas on what Class needs to be re-registered. If so, how do I do it?
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("clogin.mdb"))
conn.CursorLocation = 3
set rs=Server.CreateObject("ADODB.recordset")
sql="SELECT * FROM users"
rs.Open sql,conn
if rs.Supports(adApproxPosition)=true then
i=rs.RecordCount
response.write("The number of records is: " & i)
end if
rs.Close
conn.Close
%>
Any help is this matter is greatly appreciated
--
Best Regards,
Martin Franklin
(e-mail address removed)
Asset Research Services, Inc.
PO Box 7562
Chandler, Arizona 85246
Phone (800) 783-9636 or (480) 940-4290
Extension 213
Fax (888) 496-5736 or (480) 496-5735
Web: WWW.AssetResearch.Com