FreeTDS Development Group

["Schörk, Andreas" <andreas.schoerk AT infor.de>]

Just in Case:

     create procedure spTestExec2 as
          select 'Doesn't work!' as Result

the ' should be duplicated 
Andreas

> -----Original Message-----
> From: Anton van Straaten [mailto:anton AT appsolutions.com]
> Sent: Montag, 10. September 2001 08:30
> To: TDS Development Group
> Subject: [freetds] Re: Why can't this stored procedure be called?
> (FreeTDS_JDBC and jtds)
> 
> 
> The query only fails with FreeTDS.  It runs in all other 
> environments I've
> tested, including other JDBC drivers (e.g. JTurbo, Sprinta), 
> ODBC drivers,
> and in SQL Server 6.5 Enterprise Manager.
> 
> I have tested that stored procedure execution is working.  I 
> have had no
> problems using FreeTDS for many other procedures and
> other kinds of queries.  In fact, I can get the problem query 
> to work if I
> replace the "insert...execute" statement with a simple 
> "execute", in which
> case the query returns two result sets, the second one empty (which
> unfortunately doesn't provide the required behavior, 
> otherwise I would just
> do that).
> 
> Changing the name "Result" to something else doesn't make a 
> difference.  In
> any case, that was an artifact of the test, not the original 
> code which
> triggered the problem.
> 
> Thanks for your help, though...
> 
> Anton
> 
> 
> > -----Original Message-----
> > From: bounce-freetds-132811 AT franklin.oit.unc.edu
> > [mailto:bounce-freetds-132811 AT franklin.oit.unc.edu]On Behalf Of
> > PMoore AT axa.com.au
> > Sent: Sunday, September 09, 2001 9:21 PM
> > To: TDS Development Group
> > Subject: [freetds] Re: Why can't this stored procedure be called?
> > (FreeTDS_JDBC and jtds)
> >
> >
> >
> > firstly i would have to ask the obvious question:
> > Does it run under the SQL Server Query Analyzer tool?
> > (i added it to my SQL 2000 database and apart from calling 
> my temp table
> > #tmp2 i left your code intact and verfied that your SQL works)
> >
> >
> > i would recommend executing the sp_who procedure in your 
> code as that is a
> > known working procedure. this will at least show you 
> whether or not stored
> > procedure execution is working in your JDBC/TDS implementation.
> >
> > another thing to try - i would not use the word "Result" as the
> > name of the
> > column you are returning in case there is an issue with it being
> > a reserved
> > word.
> > cheers
> > peter
> >
> > Peter Moore
> > Contractor,
> > ITeG, Axa Australia
> >
> 
> 
> ---
> You are currently subscribed to freetds as: [andreas.schoerk AT infor.de]
> To unsubscribe, forward this message to 
> $subst('Email.Unsub')
>