SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 ADODB.Command error '800a0cc1'		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

rwaldron
Posting Yak Master

129 Posts
Posted - 04/03/2012 :  10:57:23  Show Profile  Reply with Quote
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 "<!-- Param: " & param & ", Value: " & value & " --><br>"
225 'Response.Write "<!-- Name:" & co.CommandText & " --><br>"
226 co.Parameters("@" & param).value = value
End Sub

russell
Pyro-ma-ni-yak

USA
5037 Posts
Posted - 04/03/2012 :  11:24:03  Show Profile  Visit russell's Homepage  Reply with Quote
What does it print out if you uncomment line 224. Seems to be an issue appending params.
Go to Top of Page

rwaldron
Posting Yak Master

129 Posts
Posted - 04/03/2012 :  12:09:28  Show Profile  Reply with Quote
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..
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5037 Posts
Posted - 04/03/2012 :  12:14:37  Show Profile  Visit russell's Homepage  Reply with Quote
It's not going to fix the error, it's going to help you troubleshoot it.
Go to Top of Page

rwaldron
Posting Yak Master

129 Posts
Posted - 04/03/2012 :  12:37:44  Show Profile  Reply with Quote
I uncommeted and still got the same error ?
any other ideas ?
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5037 Posts
Posted - 04/03/2012 :  15:49:06  Show Profile  Visit russell's Homepage  Reply with Quote
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
Edited by - russell on 04/03/2012 15:50:36
Go to Top of Page

rwaldron
Posting Yak Master

129 Posts
Posted - 04/16/2012 :  06:54:45  Show Profile  Reply with Quote
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.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000