[egenix-users] Stored procedure call not happening

[Charlie Clark]

Am 06.03.2007, 17:33 Uhr, schrieb Peter Bengtsson <peter at fry-it.com>:

> Hi,
> I've got a stored procedure called prcVisionTest which takes one
> parameter. It looks like this::
>   CREATE PROCEDURE dbo.prcVisionTest
>  (@fullname as varchar(50), @returnMessage varchar(100) output)
>  as
>  insert into appuser (fullname,datalocationid,departmentid) values
>  (@fullname,1000,3030)
>  set @returnMessage='Record updated'
>  GO
>  I tried call it like this::
>    >>> c.callproc("prcVisionTest", ["abc123"])
>  ['abc123']
>  >>> c.execute("select * from appuser where fullname='abc123'")
>  >>> print c.fetchone()
>  None
>  We looked at some Profiler program for MS SQL which allegedly notices
> all SQL coming in to the server and we found nothing.
> Clearly the driver doesn't send the stored procedure call. Why?

Please see section 2.3.6 in the mxODBC manual.

Charlie