Error 800a0cc1 1

[rtshort]

I really don't know what forum to put this in but since all of my Google searches have mostly led to ASP pages, I thought this may be the place. Granted that I'm "wore out" since I've been working on this for about 5 hours now.

Most all of the results (Google) suggest is a spelling error of a table column or something. I don't think this is that case with me. The page actually worked for a while, but after more information was added, it quit working. None of the code was changed on the asp page. I even replaced it with a page from a working backup.

I have an asp page that makes a call to another asp page via Remote Scripting. It has several Combo Boxes on it. When you click on one Combo Box, it fills the next one with information via SQLDB and Remote Scripting. This page has 4 different "categories" on it. All of them work as they should except the problem category. It works fine on my LocalHost though using the same database. (on my local machine)

I've checked and rechecked the names on the pages a GaZillion times. I've even copied and pasted the SQL Statement into the Query Analizer and it works fine. Of course I have to change the name of the variable to the actual name, but it works. I've even put a message box on the page to ensure that the variable is correct before passing it via Remote Scripting. It is.

I've checked the IIS log and it has this error number listed along with "Item cannot be found in the collection corresponding to the requested name or ordinal". I can see in the log that it's passing the varible correctly.

The error is coming from the remote page, I'm almost sure, but that is the page that I copied and pasted the query from.

Someone have any idea while I still have a little hair left. LOL



Rob
Just my $.02.

 

[MoLaker]

Don't you just hate it when that happens?

Since it was working (and still works on your local machine), you might look into the possibility of an update to the server causing the problem. Has MDAC been recently updated or anything like that?

 

[rtshort]

hahaha, Yep I do hate it.

Really nothing has changed on the server that I know of, but that's an idea. I will log in and run Windows Update but since the other "categories" work on the same page, I really don't think that will help.

I still have a little hair left though.

Thanks for the reply. I'll let you know what happens after the update.



Rob
Just my $.02.

 

[MoLaker]

I was thinking along the lines of perhaps a new reserved word in the database or something like that. Study your column names for possible problems.

 

[rtshort]

Thanks MoLaker for the replies.

I looked at the names several times. Probably hundreds. I can even copy and paste the SQL Query straight from the asp page to the SQL Query Analizer and it works fine. The only thing that I change is the variable name to the actual value. I can see though in the IIS Log File that the correct value is being passed as it should.

All of the other 3 categories on the page work perfectly. Just the one in question is giving me problems. The thing that gets me most is that it was working and just quit.

I installed SP2 on the server and that didn't make any difference either, except for making the server "crawl".

I'm still at a loss??

Rob
Just my $.02.

 

[rtshort]

OK, I'm Dumb. Guess I had to sleep on it a night before I noticed it.

I referenced a RS Field name wrong. I was paying too much attention to the Table Names and Colum Names and not what I had in the RS Fields.



Rob
Just my $.02.

 

[MoLaker]

Join the club. Wish I had a nickle for every time I overlooked something like that. Glad you found it.

 

[rtshort]

Yeah, I guess I'm in the club. Thanks!!

Rob
Just my $.02.