ADO & Stored Procedure & SQL Server
From: Enrico Matta (e.matta_at_libero.it)
Date: 01/23/05
- Next message: Christoph Basedau: "Re: Mdac 2.8 & XP sp2 & Client Access"
- Previous message: Gregory: "error of the system stored procedure MSSQL Server"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 23 Jan 2005 02:38:10 +0100
with a multiple execution of a sql server stored procedure (SQLOLEDB) with a
command object i get with the profiler this instruction:
SET FMTONLY ON EXEC dbo.pAttivita_Elenco_Update_1 0,0 SET FMTONLY OFF
for example with this code:
set cmd = Server.CreateObject("ADODB.Command")
set cmd.ActiveConnection = con
cmd.CommandText = "dbo.pAttivita_Elenco_Update_1"
cmd.CommandType = &H0004
cmd.Parameters.Append cmd.CreateParameter("Par1",3,,,10)
cmd.Parameters.Append cmd.CreateParameter("Par2",3,,,10)
cmd.execute
cmd.Parameters.Append cmd.CreateParameter("Par1",3,,,20)
cmd.Parameters.Append cmd.CreateParameter("Par2",3,,,20)
cmd.execute
and i don't get it with only one execution
why?
- Next message: Christoph Basedau: "Re: Mdac 2.8 & XP sp2 & Client Access"
- Previous message: Gregory: "error of the system stored procedure MSSQL Server"
- Messages sorted by: [ date ] [ thread ]