[egenix-users] Stored procedure call not happening

[Peter Bengtsson]

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?


Peter

PS. We use Linux 32-bit mxODBC version '2.1.0' over FreeTDS. DNS is
defined like this::

  [VAUKLive_Dev]
  Driver       = FreeTDS
  Description  = Connecting to VAUKLive_dev
  Trace        = No
  Server       = 172.24.66.6
  Database     = Vision_staff_profiles
  Pooling      = No




-- 
Peter Bengtsson,
work www.fry-it.com
home www.peterbe.com
hobby www.issuetrackerproduct.com