Hi Tomek, I use SAP DB Stored Procedures with ADO Objects and have no problem with this. I always use USER.PROC_NAME, and I append my parameters of command in code, so the refresh method isn't neccesary (because it slows down your application). Did you grant EXECUTE privilege to your application user?? And give us some more detailed errors descriptions (and no. errors) !! (it means - "give us the chance to help you") Regards, Marcin Pytel Talex S.A.
U�ytkownik "Tomasz Kantecki" <[EMAIL PROTECTED]> napisa� w wiadomo�ci 003b01c2b7cb$afa7d090$1801a8c0@leo">news:003b01c2b7cb$afa7d090$1801a8c0@leo... 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 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
