473,803 Members | 3,306 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Error Type:ADODB.Reco rdset (0x800A0CC1) -URGENT

9 New Member
Hi Friends,
Wen I am rying to run my asp application.... i am ending up with this following error...

Error Type:
ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested name or ordinal.
/assistdev/INCLUDES/GEN_INCLUDES/DSB_EN_HHSTU_cr tAP_HHSTU_001.a sp, line 92

and the code on line 92 is...

m_strDSBMealPla n = m_rstGroupRepea tData.Fields("M ealPlan").Value


please help me ASAP...THANKS
Mar 7 '08 #1
3 2885
idsanjeev
241 New Member
Hi dotnetdev1
check your select statements fields thats you wants to display from table is in your table.
query not found your fields in table
thanks
Mar 8 '08 #2
dotnetdev1
9 New Member
Hi Sanjeev...Thank you very much for the reply...It will be great if you can tell me how can I check the fileds whether they are in my table...because I have added a columnn but not sure if it is correct or wrong...Please guide me in this

Thanks
Mar 10 '08 #3
idsanjeev
241 New Member
Hi dotnetdev1
You can easily check your table the column is added or not write code in sql editor
Expand|Select|Wrap|Line Numbers
  1. desc tablename
or
Expand|Select|Wrap|Line Numbers
  1. select *from tablename;
Thanks
jha
Mar 14 '08 #4

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

Similar topics

2
10504
by: Tom Petersen | last post by:
I have been copying and pasting code and this has been working, but now I get this error: Error Type: ADODB.Recordset (0x800A0E7D) Operation is not allowed on an object referencing a closed or invalid connection. /forms/maintreqresults1.asp, line 26. I'm sure I'm missing something simple, but I am at a loss with this. The code is below, the URL string appears to be valid:
3
4995
by: Fredrik/Sweden | last post by:
Hi folks ! got this problem... i have a table 'Accounts' in my database, which contains a bunch of users. From the main menu i choose "edit user" and all users in the db are presented in a table. The first column 'Pnr' is a unique ID for each user that i made appear as a link. clicking on one userID should present a form where the picked users userdata is already filled in so i can easily edit it and then move on to submit the form to...
1
6847
by: Chuck | last post by:
Hi! I have a ASP page that generates an excel report. It works fine if there are records found, however, if no records are found I would like to call the below listed function instead of getting the following error that I am presently receiving: Error Type: ADODB.Recordset (0x800A0BCD) Either BOF or EOF is True, or the current record has been deleted. Requested
1
1088
by: fruddy | last post by:
Hi everyone, I'm getting the following error: ADODB.Recordset (0x800A0CC1) Item cannot be found in the collection corresponding to the requested name or ordinal. Now we all know that it means I'm trying to refer to a column that does not exist in the DB (SQL Server), yet it definitely, absolutely exists....
8
5268
by: Drew | last post by:
This is a weird error, it seems if we reboot the web server, which is also the SQL server, I get this error, ADODB.Recordset (0x800A0E7A) Provider cannot be found. It may not be properly installed. /swvtc/CliDrAppts/detailDrAppts.asp, line 31 Now line 31 of my asp page is the connection string, so there is nothing that I can do to get my apps working again.
2
2174
by: ramia1983 | last post by:
All i am doing is trying to write info to a access database but iget this error Error Type: ADODB.Recordset (0x800A0BCD) Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. /AF_Load_Process_Registration.asp, line 40 here is my code: <%
3
5696
by: pooja1982 | last post by:
Hi, I m getting this message after executing the following code <% CALL OPENDATACON DIM RS SET RS=SERVER.CreateObject ("ADODB.RECORDSET") s="select * from dbpassenger order by ref_no" CALL OPENRS(RS,S) DIM RS1 dim aa
1
8891
by: DragonFields | last post by:
I'm hoping someone can help me. I keep receiving the ADODB.Command error '800a0cc1' error (Item cannot be found in the collection corresponding to the requested name or ordinal.) I found a couple similar errors on the discussions but am not tracking how to apply the fixes into my code, which of course is slightly different...I'm using Visual Interdev 6.0 with MS SQL Enterprise Mgr 8.0. I'm linking an .asp page to a stored procedure and I've...
0
1369
by: dgil2004 | last post by:
I am a real newbie when it comes to scripting, coding, etc We have a site were people go and load text documents. I can load the text document fine with no problems. But someone from another location loads it and gets this error ADODB. Comman error '800a0d5d' Application uses a value of the wrong type for the current operation. D:\NOTICE\ADMIN\PUBLICS\.../.../include/i_dbutils.asp, line 46 Please help.
1
3373
by: shivasusan | last post by:
Hi Friends! Please Help me! How i can solve this error? Please explain me, what is the error and how to solve? Error Type: ADODB.Recordset (0x800A0E7D) The connection cannot be used to perform this operation. It is either closed or invalid in this context. /H3finalresult/include/accept_reject2.asp, line 18
0
9700
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9564
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10068
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9121
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6841
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5498
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4275
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3796
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2970
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.