what does this error mean? 1

Guest_imported · Jul 3, 2001

Hi, I get this error when trying out my forum script. I don't understand what it means/why it isn't working... can you guys tell?

============================================================
ADODB.Recordset error '800a0cb3'

Object or provider is not capable of performing requested operation.

/new/testforum.asp, line 90
============================================================

jasonsalas · Jul 3, 2001

I get this too when trying to run services dependent on NT or Windows 200-based Web servers (i.e., IIS). Are you implementing this on an IIS server or Personal Web server?

Guest_imported · Jul 3, 2001

It means that the ADODB Provider doesn't provide the functionality needed for the given operation. What does that mean? It could be many things

If you are sure the script works then try the following:

(Assuming an access database)

- an older MSADO (try using 2.6)
- changing you connection string to use another access method (provider) Try a system dsn instead of a file dsn
- set temp variables for the system account
- grant read/write access for the IUSR_MACHINE for the temp directory and the database directory - some operations on a JET DB require temp files such as order by etc.

I am guessing that it probably is some kind of acReadOnly/Move operation when opening a RecordSet which is blowing up your script - but without code it really hard to help. Try posting a snippet with the offending line (ie. line 90) when asking a question!

CaribLos · Aug 24, 2001

When I try an application in my web site this is the error I get. Please help...

ADODB.Field error '800a0cb3'

The operation requested by the application is not supported by the provider.

/change_password.asp, line 12

The following is a snipet of the code in question:

!-- #include file="/_include/conn.asp" -->
<html>
<head>
<title>Change Password</title>
</head>
<%
if request.form("btnChange&quot

= "Change" then
if request.form("txtnewpass&quot

= request.form("txtnewpass2&quot

then
login()
SQL = "Select password, username from Accessgranted where username='" & request("ssn&quot

& "'"
rsud.open sql, connud, 0, 2
rsud("password&quot

= request("txtnewpass&quot

rsud.update
rsud.close
connud.close
set connud = nothing
set rsud = nothing
%>
<script language=vbscript>
MSGBOX "YOU CAN NOW LOGIN WITH YOU NEW PASSWORD. THANK YOU."

Any suggestions?

CaribLos · Aug 24, 2001

When I try to run an application within a website I receive the following error:

ADODB.Field error '800a0cb3'

The operation requested by the application is not supported by the provider.

/change_password.asp, line 12

The following is a snipet of the code in question
!-- #include file="/_include/conn.asp" -->
<html>
<head>
<title>Change Password</title>
</head>
<%
if request.form("btnChange&quot

= "Change" then
if request.form("txtnewpass&quot

= request.form("txtnewpass2&quot

then
login()
SQL = "Select password, username from Accessgranted where username='" & request("ssn&quot

& "'"
rsud.open sql, connud, 0, 2
rsud("password&quot

= request("txtnewpass&quot

rsud.update
rsud.close
connud.close
set connud = nothing
set rsud = nothing
%>
<script language=vbscript>
MSGBOX "YOU CAN NOW LOGIN WITH YOU NEW PASSWORD. THANK YOU."

WhiteTiger · Aug 24, 2001

Stupid double posts...sure hope your forum is better than this one...make sure to include the ability to edit and delete your posts! Regards,
Anth

ny
----------------------------------------
"You say [red]insanity[/red] like it's a BAD THING!"

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

what does this error mean? 1

Guest_imported

New member

jasonsalas

IS-IT--Management

Guest_imported

New member

CaribLos

IS-IT--Management

CaribLos

IS-IT--Management

WhiteTiger

Programmer

Similar threads

Part and Inventory Search

Sponsor