ddorado
asked on
ADODB.Recordset error '800a0e78'
Sorry, my english is no good, and I'm desperated.
I work with Stored procedures (SQL Server 2000) and IIS 5.0 with a asp aplication.
My store procedure:
CREATE Procedure p_lee_archivos(
@idSubCategoria int = null,
@id int OUTPUT,
@Categoria varchar (50) OUTPUT,
@SubCategoria varchar(50) OUTPUT,
@archivo varchar (50) OUTPUT,
@descripcion varchar (256) OUTPUT,
@anchoalto varchar (20) OUTPUT,
@tamano bigint OUTPUT,
@fechaAlta varchar (50) OUTPUT,
@Descargas bigint OUTPUT,
@tipo char (4) OUTPUT,
@enviadoPor varchar (100) OUTPUT,
@creditosNecesarios int OUTPUT)
AS
SET NOCOUNT ON
BEGIN
select id,archivo,descripcion,anc hoalto,
CAST(tamano/1024 as int) as tamano,
FLOOR((tamano/1024)/250) as creditosNecesarios,
fechaalta, descargas,tipo,enviadopor, categoria, subcategoria
from datos where
idsubcategoria = @idsubcategoria
order by descripcion
END
My asp code:
<%'p_lee_archivos
Set conexion = Server.CreateObject("ADODB .Connectio n")
conexion.open "Provider=SQLOLEDB.1;Persi st Security Info=False;User ID=xxxx;PWD=xxxxxx;Initial Catalog=xxxx;Data Source=XXXXX"
set cmd = Server.CreateObject("ADODB .Command")
set cmd.ActiveConnection = conexion
cmd.commandtype = 4
cmd.commandtext = "p_lee_archivos"
set idSubCategoria = cmd.createparameter("idSub Categoria" ,adInteger ,adParamIn put)
cmd.Parameters.Append idSubCategoria
idSubCategoria.Value = Request("idSubCategoria")
set id = cmd.createparameter("id",a dInteger,a dParamOutp ut)
cmd.Parameters.Append id
set Archivo= cmd.createparameter("Archi vo",adVarC har,adPara mOutput,50 )
cmd.Parameters.Append Archivo
set Categoria= cmd.createparameter("Categ oria",adVa rChar,adPa ramOutput, 50)
cmd.Parameters.Append Categoria
set subCategoria= cmd.createparameter("subCa tegoria",a dVarChar,a dParamOutp ut,50)
cmd.Parameters.Append subCategoria
set Descripcion= cmd.createparameter("Descr ipcion",ad VarChar,ad ParamOutpu t,50)
cmd.Parameters.Append Descripcion
set anchoAlto = cmd.createparameter("ancho Alto",adVa rChar,adPa ramOutput, 20)
cmd.Parameters.Append anchoAlto
set Tamano = cmd.createparameter("Taman o",adBigIn t,adParamO utput)
cmd.Parameters.Append Tamano
set fechaAlta = cmd.createparameter("fecha Alta",adVa rChar,adPa ramOutput, 50)
cmd.Parameters.Append fechaAlta
set Descargas = cmd.createparameter("Desca rgas",adBi gInt,adPar amOutput)
cmd.Parameters.Append Descargas
set Tipo = cmd.createparameter("Tipo" ,adVarChar ,adParamOu tput,50)
cmd.Parameters.Append Tipo
set enviadoPor = cmd.createparameter("envia doPor",adV arChar,adP aramOutput ,50)
cmd.Parameters.Append enviadoPor
set creditosNecesarios = cmd.createparameter("credi tosNecesar ios",adInt eger,adPar amOutput)
cmd.Parameters.Append creditosNecesarios
set resultados = Server.CreateObject("ADODB .Recordset ")
resultados.Open cmd
While not resultados.EOF%>
Print any param
<%resultados.MoveNext()
Wend
set resultados = nothing
set cmd = nothing
conexion.close
Set conexion = nothing
%>
The error:
ADODB.Recordset error '800a0e78'
La operación no está permitida si el objeto está cerrado.
/archivos_subcategoria.asp , line 97
The stored procedure works fine.
Other stored procedures and other asp pages, with similar code works OK.
I don't understand anything, because that's my first experience in stored procedures with asp.
Best regards
Diego
I work with Stored procedures (SQL Server 2000) and IIS 5.0 with a asp aplication.
My store procedure:
CREATE Procedure p_lee_archivos(
@idSubCategoria int = null,
@id int OUTPUT,
@Categoria varchar (50) OUTPUT,
@SubCategoria varchar(50) OUTPUT,
@archivo varchar (50) OUTPUT,
@descripcion varchar (256) OUTPUT,
@anchoalto varchar (20) OUTPUT,
@tamano bigint OUTPUT,
@fechaAlta varchar (50) OUTPUT,
@Descargas bigint OUTPUT,
@tipo char (4) OUTPUT,
@enviadoPor varchar (100) OUTPUT,
@creditosNecesarios int OUTPUT)
AS
SET NOCOUNT ON
BEGIN
select id,archivo,descripcion,anc
CAST(tamano/1024 as int) as tamano,
FLOOR((tamano/1024)/250) as creditosNecesarios,
fechaalta, descargas,tipo,enviadopor,
from datos where
idsubcategoria = @idsubcategoria
order by descripcion
END
My asp code:
<%'p_lee_archivos
Set conexion = Server.CreateObject("ADODB
conexion.open "Provider=SQLOLEDB.1;Persi
set cmd = Server.CreateObject("ADODB
set cmd.ActiveConnection = conexion
cmd.commandtype = 4
cmd.commandtext = "p_lee_archivos"
set idSubCategoria = cmd.createparameter("idSub
cmd.Parameters.Append idSubCategoria
idSubCategoria.Value = Request("idSubCategoria")
set id = cmd.createparameter("id",a
cmd.Parameters.Append id
set Archivo= cmd.createparameter("Archi
cmd.Parameters.Append Archivo
set Categoria= cmd.createparameter("Categ
cmd.Parameters.Append Categoria
set subCategoria= cmd.createparameter("subCa
cmd.Parameters.Append subCategoria
set Descripcion= cmd.createparameter("Descr
cmd.Parameters.Append Descripcion
set anchoAlto = cmd.createparameter("ancho
cmd.Parameters.Append anchoAlto
set Tamano = cmd.createparameter("Taman
cmd.Parameters.Append Tamano
set fechaAlta = cmd.createparameter("fecha
cmd.Parameters.Append fechaAlta
set Descargas = cmd.createparameter("Desca
cmd.Parameters.Append Descargas
set Tipo = cmd.createparameter("Tipo"
cmd.Parameters.Append Tipo
set enviadoPor = cmd.createparameter("envia
cmd.Parameters.Append enviadoPor
set creditosNecesarios = cmd.createparameter("credi
cmd.Parameters.Append creditosNecesarios
set resultados = Server.CreateObject("ADODB
resultados.Open cmd
While not resultados.EOF%>
Print any param
<%resultados.MoveNext()
Wend
set resultados = nothing
set cmd = nothing
conexion.close
Set conexion = nothing
%>
The error:
ADODB.Recordset error '800a0e78'
La operación no está permitida si el objeto está cerrado.
/archivos_subcategoria.asp
The stored procedure works fine.
Other stored procedures and other asp pages, with similar code works OK.
I don't understand anything, because that's my first experience in stored procedures with asp.
Best regards
Diego
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations! No comment means you don't care.