SQL Stored Procedures in ASP 800a01a8 error

[Juano]

Hi

I did a sp in SQL, which i want to execute from an asp script.
The problem is that the asp returns the following error:

Microsoft VBScript runtime error '800a01a8'
Object required: ''

This error was common, and always in my script referred as when the execute command of the sql query in asp is wrong, the object is nonexistent.
So i tested the output of my SQL string created in asp. which was the following:

EXEC spAgregaInventario '8MM0D1B1','Propveedor',1839,'19/07/2007','19/08/2008','Laptop Dell'

I executed this sql string in Query Analyzer, which it did it correctly, the stored procedure executed fine and it did what it was meant to.

But it's still having the runtime error when i execute it from asp.

Here's my ASP code:

dim sqlqry
sqlqry="EXEC spAgregaInventario '"&serie&"','"&proveedor&"',"&factura&",'"&fechafact&"','"&garantia&"','"&producto&"'"
response.write(sqlqry)
conn.Execute sqlqry

Thanks