|
 |
asp_databases thread: ADODB.Command error '800a0bb9'
Message #1 by rrrabe@y... on Fri, 15 Dec 2000 08:55:07 -0000
|
|
Hello!
Can anyone give me an idea what does this mean?
ADODB.Command 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.
Hoping for your kind help
merci,
Bay
---
FREE SOFTWARE DEVELOPMENT CODE, CONTENT, AND
INSIGHTS IN YOUR INBOX!
Get the latest and best C++, Visual C++, Java, Visual Basic, and XML tips, tools, and
developments from the experts. Sign up for one or more of EarthWeb?s
FREE IT newsletters at http://www.earthweb.com today!
---
You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com
Message #2 by "Dallas Martin" <dmartin@z...> on Fri, 15 Dec 2000 07:25:30 -0500
|
|
without seeing the error causing code, the message implies a datatype
mismatch between the
value in your query string and the datatype of the field.
I encountered a similar error when I've either created a tiny int,
smallmoney, or smalldate field
and then tried to insert a larger value such as an int, money, or datetime.
Also, there is the obvious datatype mismatch. Trying to insert a date in an
int field or something
similar. Or watch your SELECTS for implied conversions, such as trying to
concantenate string
and number incorrectly., ie."SELECT codename + id",where codename is string
and ID is
integer.
hth,
Dallas
----- Original Message -----
From: <rrrabe@y...>
To: "ASP Databases" <asp_databases@p...>
Sent: Friday, December 15, 2000 3:55 AM
Subject: [asp_databases] ADODB.Command error '800a0bb9'
> Hello!
>
> Can anyone give me an idea what does this mean?
>
> ADODB.Command 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.
>
> Hoping for your kind help
>
> merci,
> Bay
>
>
---
NEED TECHNICAL TIPS, TOOLS, AND INSIGHTS? Is FREE okay?
Visit EarthWeb for the latest in IT Management, Software Development,
Web Development, Networking & Communications, and Hardware & Systems.
Click on http://www.earthweb.com for FREE articles, tutorials,
and discussions from the experts.
---
You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com
Message #3 by "peter" <ph@t...> on Tue, 19 Dec 2000 18:55:44 -0000
|
|
The following error was generated from running a stored procedure. What
does it mean? as we've checked the types, range etc and canny find any
obvious problems.
cheers
peter
ADODB.Command error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.
---
FREE WEB DEVELOPMENT CODE, CONTENT, AND INSIGHTS
IN YOUR INBOX!
Get the latest and best HTML, XML, and JavaScript tips, tools, and
developments from the experts. Sign up for one or more of EarthWeb's
FREE IT newsletters at http://www.earthweb.com today!
---
You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com
Message #4 by "Ken Schaefer" <ken@a...> on Wed, 20 Dec 2000 12:59:35 +1100
|
|
http://www.adopenstatic.com/faq/800a0bb9.asp
(probably need to look at Step 2)
Cheers
Ken
----- Original Message -----
From: "peter" <ph@t...>
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, December 20, 2000 5:55 AM
Subject: [asp_databases] ADODB.Command error '800a0bb9'
> The following error was generated from running a stored procedure. What
> does it mean? as we've checked the types, range etc and canny find any
> obvious problems.
>
> cheers
>
> peter
>
>
> ADODB.Command error '800a0bb9'
>
> Arguments are of the wrong type, are out of acceptable range, or are in
> conflict with one another.
---
FREE SOFTWARE DEVELOPMENT CODE, CONTENT, AND
INSIGHTS IN YOUR INBOX!
Get the latest and best C++, Visual C++, Java, Visual Basic, and XML tips, tools, and
developments from the experts. Sign up for one or more of EarthWeb?s
FREE IT newsletters at http://www.earthweb.com today!
---
You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com
Message #5 by Tim Brooks <TBrooks@c...> on Tue, 19 Dec 2000 17:56:46 -0500
|
|
if you have string data make sure it is properly enclosed in quotes.
-----Original Message-----
From: peter [mailto:ph@t...]
Sent: Tuesday, December 19, 2000 1:56 PM
To: ASP Databases
Subject: [asp_databases] ADODB.Command error '800a0bb9'
The following error was generated from running a stored procedure. What
does it mean? as we've checked the types, range etc and canny find any
obvious problems.
cheers
peter
ADODB.Command error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.
---
FREE SOFTWARE DEVELOPMENT CODE, CONTENT, AND
INSIGHTS IN YOUR INBOX!
Get the latest and best C++, Visual C++, Java, Visual Basic, and XML tips, tools, and
developments from the experts. Sign up for one or more of EarthWeb?s
FREE IT newsletters at http://www.earthweb.com today!
---
You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com
Message #6 by "Dallas Martin" <dmartin@z...> on Tue, 19 Dec 2000 20:26:59 -0500
|
|
It means what it says. Check your stored proc.
Make sure you add your Commad params in the same order as the proc.
Make sure that you use the enumerated datatype (ADOVBS.INC)
to describe your parameter.
Make sure the passed parameter value is of the expected datatype
and within range for the datatype.
I've made countless errors trying to pass DateTime when smalldatetime was
expected,
or Money when smallmoney was expected or INT for tiny int. AND on and on.
Most of us have done the same thing as you. Just work through it.
Also, don't forget the very useful VBScript conversion functions: CStr,
CCur, CDate, etc.
It may paid to use these functions on your variables before assigning to the
command object.
Check for return values from the functions to see if its the intended range
for the datatype.
It's extra coding, but it will help to bulletproof your code.
DM
----- Original Message -----
From: "peter" <ph@t...>
To: "ASP Databases" <asp_databases@p...>
Sent: Tuesday, December 19, 2000 1:55 PM
Subject: [asp_databases] ADODB.Command error '800a0bb9'
> The following error was generated from running a stored procedure. What
> does it mean? as we've checked the types, range etc and canny find any
> obvious problems.
>
> cheers
>
> peter
>
>
> ADODB.Command error '800a0bb9'
>
> Arguments are of the wrong type, are out of acceptable range, or are in
> conflict with one another.
---
FREE SOFTWARE DEVELOPMENT CODE, CONTENT, AND
INSIGHTS IN YOUR INBOX!
Get the latest and best C++, Visual C++, Java, Visual Basic, and XML tips, tools, and
developments from the experts. Sign up for one or more of EarthWeb?s
FREE IT newsletters at http://www.earthweb.com today!
---
You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com
|
|
|
View Cart
