Skip to Content.
Sympa Menu

freetds - [freetds] SP Syntax error using freeTDS and UnixODBC on Linux

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Rogers, Tom" <tom.rogers AT ccur.com>
  • To: "'FreeTDS AT lists.ibiblio.org'" <FreeTDS AT lists.ibiblio.org>
  • Cc:
  • Subject: [freetds] SP Syntax error using freeTDS and UnixODBC on Linux
  • Date: Wed, 7 May 2003 16:17:20 -0400



> Okay, I am dumbfounded.
>
> On my Linux machine with UnixODBC 2.2.3-1 using freeTDS 7.0 into a MS SQL
> 7.0 server I have a simple, sample app that calls a stored procedure using
> SQLBindParameter and SQLExecDirect. The SQL server returns a syntax error
> if using escape clause syntax, "{ ? = call myproc(?, ?, ?) }". I say this
> is on "my machine", as a colleagues machine the SQLExecDirect call runs
> fine, except no output params or return code.
>
> I am supposed to debug the no RC/Output params problem, but it is
> difficult as I can't get the SP to work in the first place. I can execute
> the SP if I use the regular t-sql equiv: "execute myproc NULL, val1,
> val2". That works fine.
>
> Oh, on my colleagues machine I have tried SQLMoreResults to fetch any
> recs/diag recs, etc. That seemed to get the ReturnCode to show up but not
> the output param.
>
> I have searched the various mailing lists, news groups high and low and
> triple checked my config.
>
> What should I do?
>
> Thomas Rogers
> System Engineer
> Concurrent Computer Corporation
> phone: 215.712.7422 x7261
>




Archive powered by MHonArc 2.6.24.

Top of Page