ADODB.Command error '800a0cc1'

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

ADODB.Command error '800a0cc1'

Author

Topic

rwaldron
Posting Yak Master

131 Posts

Posted - 2012-04-03 : 10:57:23

Hi all,
I am attempting to move a website from one server to another.
The website uses sql db as it's backend.
I restored DB to new server sql2005 & copied website to the same new server (IIS)
Createded identical sql account for access to sql db that is named in database.asp of the website and confirmed that I can connect to copied DB in SQL....BUT when I try to login to the site I get the following error..Am I missing stored procedures ?

ADODB.Command error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.
database.asp, line 226

line 222- 226 reads

222 '# Set stored proc parameters
223 Public Sub SQLSetProcedureParam(ByRef co, ByVal param, ByVal value)
224 'response.Write "<br>"
225 'Response.Write "<br>"
226 co.Parameters("@" & param).value = value
End Sub

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2012-04-03 : 11:24:03

What does it print out if you uncomment line 224. Seems to be an issue appending params.

rwaldron
Posting Yak Master

131 Posts

Posted - 2012-04-03 : 12:09:28

Hiya, and thx for the reply.
If I uncomment out line 224 I still get the same error.
This database.asp is copied from the original server where it is currently still running ok..
Did I fail to copy something accross ?

Ray..

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2012-04-03 : 12:14:37

It's not going to fix the error, it's going to help you troubleshoot it.

rwaldron
Posting Yak Master

131 Posts

Posted - 2012-04-03 : 12:37:44

I uncommeted and still got the same error ?
any other ideas ?

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2012-04-03 : 15:49:06

Let's try it again. You have to stop execution of the script.

do this:


'# Set stored proc parameters
Public Sub SQLSetProcedureParam(ByRef co, ByVal param, ByVal value)
	response.Write "<p><b>Param: " & param & ", Value: " & value & " </b></p><br>"

	response.end

	'Response.Write "<!-- Name:" & co.CommandText & " --><br>"
	co.Parameters("@" & param).value = value
End Sub

rwaldron
Posting Yak Master

131 Posts

Posted - 2012-04-16 : 06:54:45

Just to let you know that I finally got it sorted.
There were numerous versions of the DB that I was trying to move.
The DB at source existed in 2 places and one was considered out of date.
Finally I did a table count of source and dest DB and they did not match, I then restored what I know now to be the most recent DB, did a table count and they did match and the error went away, this was a case of restoring the wrong version of the DB,
Thx so much for your help.

Ray.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources