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.Cre ateObject("ADOD B.Connection")
conn.Provider=" Microsoft.Jet.O LEDB.4.0"
conn.Open(Serve r.Mappath("clog in.mdb"))
conn.CursorLoca tion = 3
set rs=Server.Creat eObject("ADODB. recordset")
sql="SELECT * FROM users"
rs.Open sql,conn
if rs.Supports(adA pproxPosition)= true then
i=rs.RecordCoun t
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 Ma***@AssetRese arch.Com
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 4 9167
Martin Franklin wrote: 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
Which one is line 17? 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.Cre ateObject("ADOD B.Connection") conn.Provider=" Microsoft.Jet.O LEDB.4.0" conn.Open(Serve r.Mappath("clog in.mdb")) conn.CursorLoca tion = 3
set rs=Server.Creat eObject("ADODB. recordset") sql="SELECT * FROM users" rs.Open sql,conn
if rs.Supports(adA pproxPosition)= true then
This is the wrong property to check for Supports. It's Bookmarkability that
determines whether or not the cursor supports recordcount. Anyways, you set
cursorLocation to 3 above, so you have a client-side cursor that
automatically supports recordcount because a client-side cursor is always a
Static cursor which supports recordcount.
i=rs.RecordCoun t response.write( "The number of records is: " & i) end if rs.Close conn.Close %>
Any help is this matter is greatly appreciated:)
As a guess, you have an Access97 database which uses Jet 3.51, and you are
using the Jet 4.0 provider to open it. I have never had a problem with this,
but then again, I never use the RecordCount property, so this error may have
been waiting in the wings for me all this time.
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Mr. Barrows
One thing I failed to mention in my original post is the fact that this code
works on my testing server. My problem arises when I try to run the same
page on my ISP's web server. I've actually tested this code on two of my own
web servers without any problems. Line 17 pertains one of the following
lines of code below. My development tool lists line 17 as 'rs.Open sql,
conn' but I believe the true offending line of code pertains to the line
below it 'i-rs.RecordCount' .
rs.Open sql,conn
i=rs.RecordCoun t
I've further trimmed my code as suggested by removing 'if
rs.Supports(adA pproxPosition)= true then' . Thanks for the catch. My new
complete code is...
<%
set conn=Server.Cre ateObject("ADOD B.Connection")
conn.Provider=" Microsoft.Jet.O LEDB.4.0"
conn.Open(Serve r.Mappath("clog in.mdb"))
conn.CursorLoca tion = 3
set rs=Server.Creat eObject("ADODB. recordset")
sql="SELECT * FROM users"
rs.Open sql, conn
i=rs.RecordCoun t
response.write( "The number of records is: " & i)
rs.Close
conn.Close
%>
Perhaps my question would be better suited for a form on IIS config. Any
further suggestions are greatly appreciated. Ma***@assetrese arch.com
Martin Franklin
"Bob Barrows [MVP]" <re******@NOyah oo.SPAMcom> wrote in message
news:uI******** ******@TK2MSFTN GP14.phx.gbl... Martin Franklin wrote: 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 Which one is line 17?
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.Cre ateObject("ADOD B.Connection") conn.Provider=" Microsoft.Jet.O LEDB.4.0" conn.Open(Serve r.Mappath("clog in.mdb")) conn.CursorLoca tion = 3
set rs=Server.Creat eObject("ADODB. recordset") sql="SELECT * FROM users" rs.Open sql,conn
if rs.Supports(adA pproxPosition)= true then
This is the wrong property to check for Supports. It's Bookmarkability
that determines whether or not the cursor supports recordcount. Anyways, you
set cursorLocation to 3 above, so you have a client-side cursor that automatically supports recordcount because a client-side cursor is always
a Static cursor which supports recordcount.
i=rs.RecordCoun t response.write( "The number of records is: " & i) end if rs.Close conn.Close %>
Any help is this matter is greatly appreciated:)
As a guess, you have an Access97 database which uses Jet 3.51, and you are using the Jet 4.0 provider to open it. I have never had a problem with
this, but then again, I never use the RecordCount property, so this error may
have been waiting in the wings for me all this time.
Bob Barrows
-- Microsoft MVP - ASP/ASP.NET Please reply to the newsgroup. This email account is my spam trap so I don't check it very often. If you must reply off-line, then remove the "NO SPAM"
Martin Franklin wrote: Mr. Barrows
One thing I failed to mention in my original post is the fact that this code works on my testing server. My problem arises when I try to run the same page on my ISP's web server. I've actually tested this code on two of my own web servers without any problems. Line 17 pertains one of the following lines of code below. My development tool lists line 17 as 'rs.Open sql, conn' but I believe the true offending line of code pertains to the line below it 'i-rs.RecordCount' .
Have you commented out the line to verify this belief? rs.Open sql,conn i=rs.RecordCoun t
I've further trimmed my code as suggested by removing 'if rs.Supports(adA pproxPosition)= true then' . Thanks for the catch. My new complete code is...
1> <%
2> set conn=Server.Cre ateObject("ADOD B.Connection")
3> conn.Provider=" Microsoft.Jet.O LEDB.4.0"
4> conn.Open(Serve r.Mappath("clog in.mdb"))
5> conn.CursorLoca tion = 3
6>
7> set rs=Server.Creat eObject("ADODB. recordset")
8> sql="SELECT * FROM users"
9> rs.Open sql, conn
10>
11> i=rs.RecordCoun t
12> response.write( "The number of records is: " & i)
13>
14> rs.Close
15> conn.Close
16> %> Perhaps my question would be better suited for a form on IIS config. Any further suggestions are greatly appreciated.
All I can suggest is an MDAC upgrade/repair on the server which is giving
you the problem..
Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Bob Barrows [MVP] wrote: *Martin Franklin wrote: Mr. Barrows
One thing I failed to mention in my original post is the fact that this code works on my testing server. My problem arises when I try to run the same page on my ISP's web server. I've actually tested this code on two of my own web servers without any problems. Line 17 pertains one of the following lines of code below. My development tool lists line 17 as 'rs.Open sql, conn' but I believe the true offending line of code pertains to the line below it 'i-rs.RecordCount' .
Have you commented out the line to verify this belief?
rs.Open sql,conn i=rs.RecordCoun t
I've further trimmed my code as suggested by removing 'if rs.Supports(adA pproxPosition)= true then' . Thanks for the catch.
My new complete code is... 1> <% 2> set conn=Server.Cre ateObject("ADOD B.Connection") 3> conn.Provider=" Microsoft.Jet.O LEDB.4.0" 4> conn.Open(Serve r.Mappath("clog in.mdb")) 5> conn.CursorLoca tion = 3 6> 7> set rs=Server.Creat eObject("ADODB. recordset") 8> sql="SELECT * FROM users" 9> rs.Open sql, conn 10> 11> i=rs.RecordCoun t 12> response.write( "The number of records is: " & i) 13> 14> rs.Close 15> conn.Close 16> %> Perhaps my question would be better suited for a form on IIS
config. Any further suggestions are greatly appreciated.
All I can suggest is an MDAC upgrade/repair on the server which is giving you the problem..
Bob Barrows -- Microsoft MVP -- ASP/ASP.NET Please reply to the newsgroup. The email account listed in my From header is my spam trap, so I don't check it very often. You will get a quicker response by posting to the newsgroup. *
Update: 3/25/05
Found the problem to the 'class not registered' error. I had to extend
the IUSR permissions on the directories that were pointed to by the
TEMP and TMP system variables.
"Note The Microsoft Jet database engine uses the System Temp and Tmp
environment
variables to specify the location of temporary files that are created
during Jet operations."
Posted by Martin Franklin ma***@assetrese arch.com
--
mmfranklin
------------------------------------------------------------------------
Posted via http://www.webservertalk.com
------------------------------------------------------------------------
View this thread: http://www.webservertalk.com/message933177.html This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: carlos seramos |
last post by:
I've got two IIS servers. One public and one staging. On the public
server the ASP code works fine however on the staging server I've
started getting this error recently:
error '8002801d'
Library not registered.
/default.asp, line 4
|
by: Dayron |
last post by:
Hi, I use ASP code to generate report that I retrieve about 100,000 to
800,000 records from database using ADODB.Recordset. But when i run the
code, it show me the following error.
Provider error '8007000e'
Not enough storage is available to complete this operation.
/e-survey/progress3.asp, line 192
Here is my code:
|
by: Nobody |
last post by:
<!--#include file="CommonServer.aspx"-->
<script language="VB" runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
CheckConnection()
end sub
</script>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<TITLE></TITLE>
|
by: Ryan |
last post by:
A binding navigator control adds the following code for when the Save button is clicked:
Me.Validate()
Me.UserBindingSource.EndEdit()
Me.UserTableAdapter.Update(Me.UserDataSet.User)"
You can add code to the column changing event for the dataset by using the dataset designer, for example:
Private Sub UserDataTable_ColumnChanging(ByVal sender As System.Object, ByVal e As System.Data.DataColumnChangeEventArgs) Handles Me.ColumnChanging
If...
|
by: dba123 |
last post by:
My web site is definitely configured as an application in IIS. So what else
could it be? I had added some of our code to this 3rd party's web.config
shown below. So I don't know if it's the 3rd party app that's done in .NET
1.1 that can't handle it or it's some other thing I'm missing here:
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<appSettings>
| |
by: Ted |
last post by:
In WSAT, I get the following error when trying to set up my provider:
Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site
Administration tool, use the aspnet_regsql command-line utility to
create and configure the database, and then return to this tool to set
the provider.
On Windows XP Pro, I am using MS Visual Studio 2005, and I am using
the developer's edition of...
|
by: jobs |
last post by:
Works great on my client when I test from vs.net 2005.
Howevever, when I deploy to the web server, I get this error: remotely
and local from the web server.
An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the
fact that under the default settings SQL Server does not allow remote
connections. (provider: SQL Network Interfaces, error: 26 - Error...
|
by: aboutjav.com |
last post by:
Hi,
I need some help. I am getting this error after I complete the asp.net
register control and click on the continue button. It crashed when it
tries to get
it calls this Profile property
((string)(this.GetPropertyValue("Address1")));
|
by: Prakash Paul |
last post by:
Hi All,
I need your help regarding Linked server.
We have two different locations for our two servers and I want to transfer my data from one server to another server every day. For that I used linked server.
Both are SQL Server 2005 and operating system 2008.
If I transfer data say about 10000 records it works fine.
But when I am trying to send more then 10000 rows then I am getting some error after 30 to 40 min.
Below is the error...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |