|
 |
asp_databases thread: Please help me with the recordset error.
Message #1 by Eugene TSE <eugene_tse@y...> on Sat, 24 Mar 2001 23:48:09 -0800 (PST)
|
|
DearSir/Madam,
I have tried to use the example application provided
in Ch15 "Writing an Appplication" in Beginning
ASP3.0. However, after uploading the files, when I
enter all the registration information as a new user
and click submit, I have got the below error:
ADODB.Recordset error '800a0bb9'
The application is using arguments that are of the
wrong type, are out of acceptable range, or are in
conflict with one another.
/teknion/eugene/AddUser.asp, line 5
The following is the code for AddUser.asp, which is a
file with no user interface, and just putting the form
information into the database.
-------------------------------------------------------
<!--#include file="Clssfd.asp"-->
<%
Dim rsUsers
Set rsUsers = Server.CreateObject("ADODB.Recordset")
rsUsers.Open "User", objConn, adOpenForwardOnly,
adLockOptimistic, adCmdTable 'this is the line with
err
-------------------------------------------------------
(all the codes are uploaded as is, except I have
changed the location of the classified_2000.mdb to
where it is located, in the "Clssfd.asp".
Could someone nice please tell me the way to get
around with this problem?
( I have tried several host that support ASP, but the
error is the same.
Thank you very much for your attention, help, and
prompt reply.
Your Sincerely,
Eugene
Message #2 by "Daniel O'Dorisio" <dodorisio@h...> on Sun, 25 Mar 2001 08:00:32 -0500
|
|
Did you include adovbs.inc??
Daniel
-----Original Message-----
From: Eugene TSE [mailto:eugene_tse@y...]
Sent: Sunday, March 25, 2001 2:48 AM
To: ASP Databases
Subject: [asp_databases] Please help me with the recordset error.
DearSir/Madam,
I have tried to use the example application provided
in Ch15 "Writing an Appplication" in Beginning
ASP3.0. However, after uploading the files, when I
enter all the registration information as a new user
and click submit, I have got the below error:
ADODB.Recordset error '800a0bb9'
The application is using arguments that are of the
wrong type, are out of acceptable range, or are in
conflict with one another.
/teknion/eugene/AddUser.asp, line 5
The following is the code for AddUser.asp, which is a
file with no user interface, and just putting the form
information into the database.
-------------------------------------------------------
<!--#include file="Clssfd.asp"-->
<%
Dim rsUsers
Set rsUsers = Server.CreateObject("ADODB.Recordset")
rsUsers.Open "User", objConn, adOpenForwardOnly,
adLockOptimistic, adCmdTable 'this is the line with
err
-------------------------------------------------------
(all the codes are uploaded as is, except I have
changed the location of the classified_2000.mdb to
where it is located, in the "Clssfd.asp".
Could someone nice please tell me the way to get
around with this problem?
( I have tried several host that support ASP, but the
error is the same.
Thank you very much for your attention, help, and
prompt reply.
Your Sincerely,
Eugene
---
SoftArtisans helps developers build robust, scalable Web applications!
Excel Web reports, charts: http://www.softartisans.com/excelwriter.html
File uploads: http://www.softartisans.com/saf.html
Transactional file management: http://www.softartisans.com/saf1.html
Scalability: http://www.softartisans.com/saxsession.html
ASPstudio value pack: http://www.softartisans.com/aspstudiosuite.html
$subst('Email.Unsub')
Message #3 by "Ken Schaefer" <ken@a...> on Mon, 26 Mar 2001 10:39:30 +1000
|
|
www.adOpenStatic.com/faq/800a0bb9.asp
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: I have tried to use the example application provided
: in Ch15 "Writing an Appplication" in Beginning
: ASP3.0. However, after uploading the files, when I
: enter all the registration information as a new user
: and click submit, I have got the below error:
:
: ADODB.Recordset error '800a0bb9'
:
: The application is using arguments that are of the
: wrong type, are out of acceptable range, or are in
: conflict with one another.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Message #4 by "Tomm Matthis" <matthis@b...> on Mon, 26 Mar 2001 09:36:52 -0500
|
|
ARe you including ADOVBS.INC in the pages somewhere or putting a metatag
reference to ADO in the Global.ASA?
Tomm
> -----Original Message-----
> From: Eugene TSE [mailto:eugene_tse@y...]
> Sent: Sunday, March 25, 2001 2:48 AM
> To: ASP Databases
> Subject: [asp_databases] Please help me with the recordset error.
>
>
> DearSir/Madam,
>
> I have tried to use the example application provided
> in Ch15 "Writing an Appplication" in Beginning
> ASP3.0. However, after uploading the files, when I
> enter all the registration information as a new user
> and click submit, I have got the below error:
>
> ADODB.Recordset error '800a0bb9'
>
> The application is using arguments that are of the
> wrong type, are out of acceptable range, or are in
> conflict with one another.
>
> /teknion/eugene/AddUser.asp, line 5
>
> The following is the code for AddUser.asp, which is a
> file with no user interface, and just putting the form
> information into the database.
>
> -------------------------------------------------------
> <!--#include file=3D"Clssfd.asp"-->
> <%
> Dim rsUsers
> Set rsUsers =3D Server.CreateObject("ADODB.Recordset")
> rsUsers.Open "User", objConn, adOpenForwardOnly,
> adLockOptimistic, adCmdTable 'this is the line with
> err
> -------------------------------------------------------
> (all the codes are uploaded as is, except I have
> changed the location of the classified_2000.mdb to
> where it is located, in the "Clssfd.asp".
>
> Could someone nice please tell me the way to get
> around with this problem?
>
> ( I have tried several host that support ASP, but the
> error is the same.
>
> Thank you very much for your attention, help, and
> prompt reply.
>
> Your Sincerely,
>
> Eugene
>
>
>
|
|
|
View Cart
