DBPROC called from ADO/ASP

[Tomasz Kantecki]

Hi,   I searched through the archive but I could not find similar issue. I hope I am not duplicating the case. I am working on web application working on Win2K/IIS/ASP + SAPDB. I get access to SAPDB via ADO objects and ODBC driver for SAPDB. As far as I use SQL commands in CmdText mode it is OK. Yet I cannot invoke DBPROC as CmdStoredProc via ADO interface at all. I get strange errors that tell me nothing. Here is the code fragment:   dim conn, rs, cmd set conn = Server.CreateObject("ADODB.Connection") set cmd = Server.CreateObject("ADODB.Command") set rs = Server.CreateObject("ADODB.RecordSet")   conn.Open "DSN=sapdb2;uid=xx;pwd=xx;" set cmd.ActiveConnection = conn cmd.CommandType = adCmdStoredProc cmd.CommandText = "TESTFN"                       <--- adding "USER.TESTFN" does not change anything cmd.Parameters.Refresh cmd.Parameters.Item(0) = 47 cmd.Execute adExecuteNoRecords conn.Close   If I remove the call to Refresh then error message changes to other ... The above code works with MSSQL   Another question concerns DBPROC: - is it possible to return recordset from DBPROC? how shall I do it? - I guess the return data is retrieveable via Parameters collection?   I am frustrated with this stored procedure issue, please help. Thanks in advance and best regards, Tomasz Kantecki   ************r-e-k-l-a-m-a*************** Chcesz oszcz�dzi� na kosztach obs�ugi bankowej ? mBIZNES - konto dla firm