473,405 Members | 2,185 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,405 software developers and data experts.

ASP Error :: ADODB.Recordset error '800a0bb9'

nitindel
Hi All,

I am using DbCom Handler for my DataBase Connectivity.
But the Query is not firing i.e recordset is not getting populated...

it is Showing the error as follows:

ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.



Please tell wat are the Possible causes ...and how to trouble shoot it???

Please tell..its vry very Urgent..!!!


Thanks & Regards
Nitin Sharma
Software Engineer
Dec 20 '07 #1
4 3125
shweta123
692 Expert 512MB
Hi,

Please refer this Article .
Also , tell us more details about your code to rectify the error.


Hi All,

I am using DbCom Handler for my DataBase Connectivity.
But the Query is not firing i.e recordset is not getting populated...

it is Showing the error as follows:

ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.



Please tell wat are the Possible causes ...and how to trouble shoot it???

Please tell..its vry very Urgent..!!!


Thanks & Regards
Nitin Sharma
Software Engineer
Dec 20 '07 #2
jhardman
3,406 Expert 2GB
print out the query, usually this will shed light on the problem.

Jared
Dec 21 '07 #3
HEY even i m having the same problem so if u got the solution then plz send me that
Jan 20 '08 #4
It was a SQL error actually that is why Recordset was not population..
I looked it on laters..
Usually it also happens when you pass differnet parameters to the recordset when you update or delete or insert or uses where clause in the query...

That is It...
Bbye nc tc..

Happy Coding..

Nitin Sharma
Software Engineer
Jan 21 '08 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: DC | last post by:
Im getting the error ADODB.Fields error '800a0bb9' Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. In the following script to copy and...
1
by: Beau | last post by:
Hi all, thanks in advance. Ok, heres the story. What is happening...... -------------------------------- I've got an ASP page that loops. It loops in order to get data in different,...
2
by: wolverine1654 | last post by:
I have an application that we are moving to a 2003 server using IIS6. Currently, it works fine with IIS5 on a NT server. When I try to log into the application and connect to an Oracle DB, I get...
2
by: Shailaindra Sharma | last post by:
The Following code generates Error while compiling: Private Sub datPrimaryRS_MoveComplete(ByVal adReason As ADODB.EventReasonEnum, ByVal pError As ADODB.Error, adStatus As ADODB.EventStatusEnum,...
10
by: Kasp | last post by:
When I try and save out a recordset from an ASP page as XML I get the following error (the code is below) - I have ADO 2.8 installed and this is running on win XP sp2 : ...
3
by: Kosmos | last post by:
Hey ya'll...I can't seem to figure out why I'm getting this error message, but it all started when I added the new line of code with the recSet5.AddNew --- when I ran the first line, the logic worked...
7
by: Big Moxy | last post by:
I'm getting this error on my asp/access page. It's a sql error triggered by Recordset1.open sql,conn,1,1. The sql is constructed from user input on a search page. ADODB.Recordset error...
1
by: cwfontan | last post by:
I am uploading a file renaming it with text from input here is the sql insert code and error im getting. If you need more of the code let me know.. This exact code is working when inserting into...
12
by: janetopps | last post by:
I am trying to migrate from an MS access to MySQL and am having problems. I have an asp pages on my website. <% ' Dim SQL_REC, RS_REC, NID, TITLE, POSTED, NEWS_LISTING, SHOW_HL, MyConn_REC,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
jinu1996
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...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.