Re: Call stored proc from ADODB.Command

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Al Reid (areidjr_at_reidDASHhome.com)
Date: 05/06/04 

Date: Thu, 6 May 2004 08:32:44 -0400

Post the exact DDL for the SP along with the code you are using to call it. 

-- 
Al Reid
"It ain't what you don't know that gets you into trouble. It's what you know
for sure that just ain't so."  --- Mark Twain
"alex" <anonymous@discussions.microsoft.com> wrote in message news:4C4BDCF4-D7FF-48A9-875E-2B86F6A649C9@microsoft.com...
> Dear all,
> I have a stored proc on my SQL 2000 that looks something like:
> ...
> UPDATE ... SET ...
>
> ...
> The problem is that when I call for that proc using ADODB.Command object, everything that is before UPDATE statement is executed,
but everything, that's after - not.
> I use standart syntax for calling:
> Dim cmd as new adodb.command
> with cmd
>   .activeconnection = de.cn
>   .commandtype = 4
>   .commandtext = "my_sp"
>   .execute
> end with
> To test executing I inserted RAISERROR after UPDATE statement and it never works...
> Executing that proc from query analyzer works fine.
>
> What is the possible reason of this behaviour?
> alex

Relevant Pages

  • Call stored proc from ADODB.Command
    ... The problem is that when I call for that proc using ADODB.Command object, everything that is before UPDATE statement is executed, but everything, that's after - not. ... Dim cmd as new adodb.command ... To test executing I inserted RAISERROR after UPDATE statement and it never works... ...
    (microsoft.public.vb.database)
  • Re: error message on publisher
    ... update statement on the publisher database, ... I executed the SQL outside of our app and got the following ... Error Executing Database Query. ...
    (microsoft.public.sqlserver.replication)
  • Re: Concurrencty violation with decimal type
    ... It would be useful to see the UPDATE statement you're executing. ... generated by the CommandBuilder or one of the drag-and-drop or DataAdapter ... > search of these forums someone else had a similar problem, ...
    (microsoft.public.dotnet.framework.adonet)
  • Low-Level crash tracing errorInfo
    ... I'm trying to have a detailed errorStack in Tcl. ... puts "ERROR Found: " ... proc A { ... I'm running ActiveTcl 8.5.4 and executing in the wish console, ...
    (comp.lang.tcl)
  • Re: updating through a loop statement
    ... The optimizer can, and will, execute statements out of order if it detects that they are not co-dependent. ... This behaviour is easily observable if you debug SQL server, and I was also bitten by a bug in the 2008 optimizer when it over optimized the statement execution of a very aggressive app using a certain ODBC call sequence to reduce server workload ... I suspect that he should replace the loop in his sp (multiple update statements) with either dynamic SQL or a single update statement depending on whether he knows in advance all of the fields that he needs to update or not. ... stored procedure is executing, no other statement in the procedure is ...
    (microsoft.public.sqlserver.programming)