|
 |
asp_web_howto thread: ADODB.Recordset error '800a0bb9'
Message #1 by "Andy" <andy@t...> on Sat, 22 Feb 2003 03:05:57 +0800
|
|
Hello,
I have created a recordset as follow on one of the ASP page :
With rsAuthors
.Source = "tblTest"
.ActiveConnection = strConn
.CursorType = adOpenDynamic
.LockType = adLockOptimistic ----> Line where error occur
.Options = adCmdtext
.Open
.AddNew
.Fields("username")= Session("username")
.Fields("email") = Session("email")
.Fields("priority") = Priority
.Fields("category") = Category
.Fields("subject") = Subject
.Fields("description") = Description
.Fields("ticdate") = Now()
.Fields("url") = Url
.Update
End With
When I click on the page that contains this code , I get :
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.
How do I solve this?
Thanks
Andy
Message #2 by "suhailkaleem" <suhailkaleem@p...> on Sat, 22 Feb 2003 00:14:11 +0500
|
|
Hi !
Make sure the variable which you are using for db connection is correct
ActiveConnection = strConn
Please double check the variable strConn . did you include the connection
file or did you define the connection ???
Thanks
Suhailkaleem
----- Original Message -----
From: "Andy" <andy@t...>
To: "ASP Web HowTo" <asp_web_howto@p...>
Sent: Saturday, February 22, 2003 12:05 AM
Subject: [asp_web_howto] ADODB.Recordset error '800a0bb9'
> Hello,
>
> I have created a recordset as follow on one of the ASP page :
>
> With rsAuthors
> .Source = "tblTest"
> .ActiveConnection = strConn
> .CursorType = adOpenDynamic
> .LockType = adLockOptimistic ----> Line where error occur
> .Options = adCmdtext
> .Open
>
> .AddNew
> .Fields("username")= Session("username")
> .Fields("email") = Session("email")
> .Fields("priority") = Priority
> .Fields("category") = Category
> .Fields("subject") = Subject
> .Fields("description") = Description
> .Fields("ticdate") = Now()
> .Fields("url") = Url
> .Update
> End With
>
> When I click on the page that contains this code , I get :
>
>
> ADODB.Recordset error '800a0bb9'
>
> Arguments are of the wrong type, are out of acceptable range, or are in
> conflict with one another.
>
>
> How do I solve this?
>
> Thanks
>
>
>
> Andy
>
>
>
>
>
>
>
Message #3 by "Andy" <andy@t...> on Sat, 22 Feb 2003 04:27:14 +0800
|
|
Oopss..I forgot to include the adovbs.inc file in my connection file.Sorry
for that as I am too excited to test my scripts.this solve the issue and
came out another .When I submit the page with all the details to be stored
in the database,I am getting :
Microsoft OLE DB Provider for SQL Server error '80040e21'
Multiple-step OLE DB operation generated errors. Check each OLE DB status
value, if available. No work was done.
.AddNew
.Fields("username")= Session("username") ---- > Line error occur
.Fields("email") = Session("email")
.Fields("priority") = Priority
.Fields("category") = Category
.Fields("subject") = Subject
.Fields("description") = Description
.Fields("ticdate") = Now()
.Fields("url") = Url
.Update
End With
I have checked on the server column that the width to store is enough for it
as I have set it as Varchar(25)
Thanks
Andy
----- Original Message -----
From: "suhailkaleem" <suhailkaleem@p...>
To: "ASP Web HowTo" <asp_web_howto@p...>
Sent: Saturday, February 22, 2003 3:14 AM
Subject: [asp_web_howto] Re: ADODB.Recordset error '800a0bb9'
> Hi !
>
> Make sure the variable which you are using for db connection is correct
>
> ActiveConnection = strConn
>
> Please double check the variable strConn . did you include the
connection
> file or did you define the connection ???
>
> Thanks
> Suhailkaleem
>
> ----- Original Message -----
> From: "Andy" <andy@t...>
> To: "ASP Web HowTo" <asp_web_howto@p...>
> Sent: Saturday, February 22, 2003 12:05 AM
> Subject: [asp_web_howto] ADODB.Recordset error '800a0bb9'
>
>
> > Hello,
> >
> > I have created a recordset as follow on one of the ASP page :
> >
> > With rsAuthors
> > .Source = "tblTest"
> > .ActiveConnection = strConn
> > .CursorType = adOpenDynamic
> > .LockType = adLockOptimistic ----> Line where error occur
> > .Options = adCmdtext
> > .Open
> >
> > .AddNew
> > .Fields("username")= Session("username")
> > .Fields("email") = Session("email")
> > .Fields("priority") = Priority
> > .Fields("category") = Category
> > .Fields("subject") = Subject
> > .Fields("description") = Description
> > .Fields("ticdate") = Now()
> > .Fields("url") = Url
> > .Update
> > End With
> >
> > When I click on the page that contains this code , I get :
> >
> >
> > ADODB.Recordset error '800a0bb9'
> >
> > Arguments are of the wrong type, are out of acceptable range, or are in
> > conflict with one another.
> >
> >
> > How do I solve this?
> >
> > Thanks
> >
> >
> >
> > Andy
> >
> >
> >
> >
> >
> >
> >
>
>
>
>
Message #4 by "suhailkaleem" <suhailkaleem@p...> on Sat, 22 Feb 2003 13:00:29 +0500
|
|
Hi !
Increase the width to 100 and then try .
Suhail kaleem
----- Original Message -----
From: "Andy" <andy@t...>
To: "ASP Web HowTo" <asp_web_howto@p...>
Sent: Saturday, February 22, 2003 1:27 AM
Subject: [asp_web_howto] Re: ADODB.Recordset error '800a0bb9'
> Oopss..I forgot to include the adovbs.inc file in my connection file.Sorry
> for that as I am too excited to test my scripts.this solve the issue and
> came out another .When I submit the page with all the details to be stored
> in the database,I am getting :
>
>
> Microsoft OLE DB Provider for SQL Server error '80040e21'
>
> Multiple-step OLE DB operation generated errors. Check each OLE DB status
> value, if available. No work was done.
>
> .AddNew
> .Fields("username")= Session("username") ---- > Line error occur
> .Fields("email") = Session("email")
> .Fields("priority") = Priority
> .Fields("category") = Category
> .Fields("subject") = Subject
> .Fields("description") = Description
> .Fields("ticdate") = Now()
> .Fields("url") = Url
> .Update
> End With
>
>
> I have checked on the server column that the width to store is enough for
it
> as I have set it as Varchar(25)
>
>
>
> Thanks
>
>
>
> Andy
>
> ----- Original Message -----
> From: "suhailkaleem" <suhailkaleem@p...>
> To: "ASP Web HowTo" <asp_web_howto@p...>
> Sent: Saturday, February 22, 2003 3:14 AM
> Subject: [asp_web_howto] Re: ADODB.Recordset error '800a0bb9'
>
>
> > Hi !
> >
> > Make sure the variable which you are using for db connection is correct
> >
> > ActiveConnection = strConn
> >
> > Please double check the variable strConn . did you include the
> connection
> > file or did you define the connection ???
> >
> > Thanks
> > Suhailkaleem
> >
> > ----- Original Message -----
> > From: "Andy" <andy@t...>
> > To: "ASP Web HowTo" <asp_web_howto@p...>
> > Sent: Saturday, February 22, 2003 12:05 AM
> > Subject: [asp_web_howto] ADODB.Recordset error '800a0bb9'
> >
> >
> > > Hello,
> > >
> > > I have created a recordset as follow on one of the ASP page :
> > >
> > > With rsAuthors
> > > .Source = "tblTest"
> > > .ActiveConnection = strConn
> > > .CursorType = adOpenDynamic
> > > .LockType = adLockOptimistic ----> Line where error occur
> > > .Options = adCmdtext
> > > .Open
> > >
> > > .AddNew
> > > .Fields("username")= Session("username")
> > > .Fields("email") = Session("email")
> > > .Fields("priority") = Priority
> > > .Fields("category") = Category
> > > .Fields("subject") = Subject
> > > .Fields("description") = Description
> > > .Fields("ticdate") = Now()
> > > .Fields("url") = Url
> > > .Update
> > > End With
> > >
> > > When I click on the page that contains this code , I get :
> > >
> > >
> > > ADODB.Recordset error '800a0bb9'
> > >
> > > Arguments are of the wrong type, are out of acceptable range, or are
in
> > > conflict with one another.
> > >
> > >
> > > How do I solve this?
> > >
> > > Thanks
> > >
> > >
> > >
> > > Andy
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
> >
> >
>
>
>
Message #5 by "Andy" <andy@t...> on Sat, 22 Feb 2003 17:34:39 +0800
|
|
Hello,
I have change the code and it is now working .
rsAuthors.Open "tblTest",adoConn,adOpenDynamic,adLockOptimistic,adCmdTable
rsAuthors.AddNew
rsAuthors("username") = Username
rsAuthors("email") = Email
rsAuthors("priority") = Priority
rsAuthors("category") = Category
rsAuthors("subject") = Subject
rsAuthors("description") = Description
rsAuthors("ticdate") = Now()
rsAuthors("url") = Url
rsAuthors.Update
Just don't know why the original codes does not work.Thanks anyway.
Andy
----- Original Message -----
From: "suhailkaleem" <suhailkaleem@p...>
To: "ASP Web HowTo" <asp_web_howto@p...>
Sent: Saturday, February 22, 2003 4:00 PM
Subject: [asp_web_howto] Re: ADODB.Recordset error '800a0bb9'
> Hi !
> Increase the width to 100 and then try .
> Suhail kaleem
> ----- Original Message -----
> From: "Andy" <andy@t...>
> To: "ASP Web HowTo" <asp_web_howto@p...>
> Sent: Saturday, February 22, 2003 1:27 AM
> Subject: [asp_web_howto] Re: ADODB.Recordset error '800a0bb9'
>
>
> > Oopss..I forgot to include the adovbs.inc file in my connection
file.Sorry
> > for that as I am too excited to test my scripts.this solve the issue and
> > came out another .When I submit the page with all the details to be
stored
> > in the database,I am getting :
> >
> >
> > Microsoft OLE DB Provider for SQL Server error '80040e21'
> >
> > Multiple-step OLE DB operation generated errors. Check each OLE DB
status
> > value, if available. No work was done.
> >
> > .AddNew
> > .Fields("username")= Session("username") ---- > Line error occur
> > .Fields("email") = Session("email")
> > .Fields("priority") = Priority
> > .Fields("category") = Category
> > .Fields("subject") = Subject
> > .Fields("description") = Description
> > .Fields("ticdate") = Now()
> > .Fields("url") = Url
> > .Update
> > End With
> >
> >
> > I have checked on the server column that the width to store is enough
for
> it
> > as I have set it as Varchar(25)
> >
> >
> >
> > Thanks
> >
> >
> >
> > Andy
> >
> > ----- Original Message -----
> > From: "suhailkaleem" <suhailkaleem@p...>
> > To: "ASP Web HowTo" <asp_web_howto@p...>
> > Sent: Saturday, February 22, 2003 3:14 AM
> > Subject: [asp_web_howto] Re: ADODB.Recordset error '800a0bb9'
> >
> >
> > > Hi !
> > >
> > > Make sure the variable which you are using for db connection is
correct
> > >
> > > ActiveConnection = strConn
> > >
> > > Please double check the variable strConn . did you include the
> > connection
> > > file or did you define the connection ???
> > >
> > > Thanks
> > > Suhailkaleem
> > >
> > > ----- Original Message -----
> > > From: "Andy" <andy@t...>
> > > To: "ASP Web HowTo" <asp_web_howto@p...>
> > > Sent: Saturday, February 22, 2003 12:05 AM
> > > Subject: [asp_web_howto] ADODB.Recordset error '800a0bb9'
> > >
> > >
> > > > Hello,
> > > >
> > > > I have created a recordset as follow on one of the ASP page :
> > > >
> > > > With rsAuthors
> > > > .Source = "tblTest"
> > > > .ActiveConnection = strConn
> > > > .CursorType = adOpenDynamic
> > > > .LockType = adLockOptimistic ----> Line where error occur
> > > > .Options = adCmdtext
> > > > .Open
> > > >
> > > > .AddNew
> > > > .Fields("username")= Session("username")
> > > > .Fields("email") = Session("email")
> > > > .Fields("priority") = Priority
> > > > .Fields("category") = Category
> > > > .Fields("subject") = Subject
> > > > .Fields("description") = Description
> > > > .Fields("ticdate") = Now()
> > > > .Fields("url") = Url
> > > > .Update
> > > > End With
> > > >
> > > > When I click on the page that contains this code , I get :
> > > >
> > > >
> > > > ADODB.Recordset error '800a0bb9'
> > > >
> > > > Arguments are of the wrong type, are out of acceptable range, or are
> in
> > > > conflict with one another.
> > > >
> > > >
> > > > How do I solve this?
> > > >
> > > > Thanks
> > > >
> > > >
> > > >
> > > > Andy
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > >
> >
> >
> >
>
>
>
>
Message #6 by "Paul Beaulieu" <paulbeaulieu@s...> on Wed, 26 Feb 2003 07:50:10 -0500
|
|
Increase your column size or use the Trim(session("variable")) might work as
well.
Paul.
----- Original Message -----
From: "suhailkaleem" <suhailkaleem@p...>
To: "ASP Web HowTo" <asp_web_howto@p...>
Sent: Saturday, February 22, 2003 3:00 AM
Subject: [asp_web_howto] Re: ADODB.Recordset error '800a0bb9'
> Hi !
> Increase the width to 100 and then try .
> Suhail kaleem
> ----- Original Message -----
> From: "Andy" <andy@t...>
> To: "ASP Web HowTo" <asp_web_howto@p...>
> Sent: Saturday, February 22, 2003 1:27 AM
> Subject: [asp_web_howto] Re: ADODB.Recordset error '800a0bb9'
>
>
> > Oopss..I forgot to include the adovbs.inc file in my connection
file.Sorry
> > for that as I am too excited to test my scripts.this solve the issue and
> > came out another .When I submit the page with all the details to be
stored
> > in the database,I am getting :
> >
> >
> > Microsoft OLE DB Provider for SQL Server error '80040e21'
> >
> > Multiple-step OLE DB operation generated errors. Check each OLE DB
status
> > value, if available. No work was done.
> >
> > .AddNew
> > .Fields("username")= Session("username") ---- > Line error occur
> > .Fields("email") = Session("email")
> > .Fields("priority") = Priority
> > .Fields("category") = Category
> > .Fields("subject") = Subject
> > .Fields("description") = Description
> > .Fields("ticdate") = Now()
> > .Fields("url") = Url
> > .Update
> > End With
> >
> >
> > I have checked on the server column that the width to store is enough
for
> it
> > as I have set it as Varchar(25)
> >
> >
> >
> > Thanks
> >
> >
> >
> > Andy
> >
> > ----- Original Message -----
> > From: "suhailkaleem" <suhailkaleem@p...>
> > To: "ASP Web HowTo" <asp_web_howto@p...>
> > Sent: Saturday, February 22, 2003 3:14 AM
> > Subject: [asp_web_howto] Re: ADODB.Recordset error '800a0bb9'
> >
> >
> > > Hi !
> > >
> > > Make sure the variable which you are using for db connection is
correct
> > >
> > > ActiveConnection = strConn
> > >
> > > Please double check the variable strConn . did you include the
> > connection
> > > file or did you define the connection ???
> > >
> > > Thanks
> > > Suhailkaleem
> > >
> > > ----- Original Message -----
> > > From: "Andy" <andy@t...>
> > > To: "ASP Web HowTo" <asp_web_howto@p...>
> > > Sent: Saturday, February 22, 2003 12:05 AM
> > > Subject: [asp_web_howto] ADODB.Recordset error '800a0bb9'
> > >
> > >
> > > > Hello,
> > > >
> > > > I have created a recordset as follow on one of the ASP page :
> > > >
> > > > With rsAuthors
> > > > .Source = "tblTest"
> > > > .ActiveConnection = strConn
> > > > .CursorType = adOpenDynamic
> > > > .LockType = adLockOptimistic ----> Line where error occur
> > > > .Options = adCmdtext
> > > > .Open
> > > >
> > > > .AddNew
> > > > .Fields("username")= Session("username")
> > > > .Fields("email") = Session("email")
> > > > .Fields("priority") = Priority
> > > > .Fields("category") = Category
> > > > .Fields("subject") = Subject
> > > > .Fields("description") = Description
> > > > .Fields("ticdate") = Now()
> > > > .Fields("url") = Url
> > > > .Update
> > > > End With
> > > >
> > > > When I click on the page that contains this code , I get :
> > > >
> > > >
> > > > ADODB.Recordset error '800a0bb9'
> > > >
> > > > Arguments are of the wrong type, are out of acceptable range, or are
> in
> > > > conflict with one another.
> > > >
> > > >
> > > > How do I solve this?
> > > >
> > > > Thanks
> > > >
> > > >
> > > >
> > > > Andy
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > >
> >
> >
> >
>
>
|
|
|
View Cart
