For Gurus:Error in ASP page in one database but not in another!!

[eramgarden]

I get this error:

Operation is not allowed when the object is closed.

on this line of code:
set rsADO = oSvy.GetCaller(callid,incid)

When I point global.asa to my local database. But, when I point it to Production database, it works fine.

These are some info:

1. I have the callid and incid hardcoded in ASP page for testing

2. I looked at the VB dll and it calls a stored proc. I ran the stored proc by itself with those hardcoded values and it does return a recordset on my local database.

3. Google had it to use "SET NOCOUNT ON" in stored proc, I did that but still got the error.

4. I checked the order of calling the stored proc from Vb dll and it calls the stored proc correctly.

5. compared the stored proc in Production to the one on my machine and they look the same.

6. This is the VB code that causes the error:

SQL = "GetCaller '" & callid & "', '" & incid & "'"
errorClass = "ExecDBcnx1300"
Set rsADO = DBCnx.Execute(SQL)

Set GetCaller = rsADO ' return the recordset

7. This is the ASP code:
set oSvy = Server.CreateObject ("SurveyAPI.DisplaySurvey&quot
if Err then
Session("DCS_ErrorDesc&quot = Err.Description
Response.Redirect "error.asp"
Response.End
end if
set rsADO = oSvy.GetEspCaller(callid,incid)

What am I missing? how could this work on one datbase and not on the other???

 

[SarkMan]

Have you checked permissions on the stored proc. Maybe the permissions in prod are different than in you test environment.

 

[eramgarden]

Yes, i did...on my local machine, i have puplic and another user..on production, i have the same.

I also checked ODBC connection, tried err.number <> 0, i do get a connection.

The error comes from the VB dll...globla is pointig to my local database, i have ODBC pointing to my local database..

hmmm... looked at a lot of posts on Google but nothing concrete...