FreeTDS Development Group

[Jon Pounder <pounder AT inline.net>]

hmmm, not sure even how to do that....


I have always gotten around the problem with the various odbc clients I
have used by rewriting the sp to return multiple result sets and never
using output parameters in the call. Never found a situation I couldn't do
that.


At 01:29 PM 3/28/00 -0500, you wrote:
>As matter of fact, this is an OUTPUT parameter. Could you give
>me an example of calling string?
>
>
>---------------------------------------------------------------------------
>Henry Lu
>Computer Systems Programmer III         e-mail: zhlu AT umich.edu
>MCIT                                            phone: (734) 936-2063
>University of Michigan Medical Center           fax:   (734) 763-4372
>
>On Tue, 28 Mar 2000, Jon Pounder wrote:
>
>> ahh - I didn't realize that was part of the query string, I thought it was
>> just because it was a question.
>> 
>> 
>> yes I agree then if that is the case, that is the trouble for sure.
>> 
>> just put the value in place of the "?".
>> 
>> 
>> At 09:21 AM 3/28/00 -0800, you wrote:
>> >Jon Pounder writes:
>> > > hmmm - not sure what would be "not implemented" there.
>> >
>> >Probably the ? which should potentially be replaced by a parameter in
>> >the stored proc call.
>> >
>> >I know that Sybase does not support ?-style placeholder parameters to
>> >stored procs at the protocol level, so unless the driver does the
>> >replacement and quoting itself this won't work (and I know that the C
>> >side of FreeTDS does not handle ?-style placeholders at all at the
>> >moment).
>> >
>> >Michael
>> >
>> >
>> > > At 12:06 PM 3/28/00 -0500, you wrote:
>> > > >Thanks for your info but I got error:
>> > > >java.sql.SQLException: not implemented
>> > > >
>> > > >The query is :
>> > > >"exec get_print_no ?"
>> > > >
>> > > >
>> > >
>>
>---------------------------------------------------------------------------
>> > > >Henry Lu
>> > > >Computer Systems Programmer III         e-mail: zhlu AT umich.edu
>> > > >MCIT                                            phone: (734) 936-2063
>> > > >University of Michigan Medical Center           fax:   (734) 763-4372
>> > > >
>> > > >On Tue, 28 Mar 2000, Jon Pounder wrote:
>> > > >
>> > > >> 
>> > > >> not sure on the jdbc part, but in general your sql statement just
looks
>> > > >> like this:
>> > > >> 
>> > > >> "exec sp_whatever parm1, parm2, parm3"
>> > > >> 
>> > > >> the driver should be smart enough to figure out whether this has a
>> select
>> > > >> in it or not and act accordingly based on the results that come
back.
>> > > >> 
>> > > >> 
>> > > >> At 11:42 AM 3/28/00 -0500, you wrote:
>> > > >> >Is there any example of calling a stored procedure with SQL-Server
>> JDBC?
>> > > >> >
>> > > >> >
>> > > >>
>> > >
>>
>---------------------------------------------------------------------------
>> > > >> >Henry Lu
>> > > >> >Computer Systems Programmer III         e-mail: zhlu AT umich.edu
>> > > >> >MCIT                                            phone: (734)
936-2063
>> > > >> >University of Michigan Medical Center           fax:   (734)
763-4372
>> > > >> >
>> > > >> >
>> > > >> >---
>> > > >> >You are currently subscribed to freetds as: pounder AT inline.net
>> > > >> >To unsubscribe, forward this message to
>> > > >> $subst('Email.Unsub')
>> > > >> >
>> > > >> >
>> > > >> 
>> > > >>       Jon Pounder,   Development Engineer
>> > > >>       Inline Internet Systems
>> > > >>       pounder AT inline.net Jon AT Pounder.com
>> > > >> 
>> > > >>       Web Tools Engineered for Success
>> > > >>       http://www.inline.net
>> > > >>       http://www.ihtml.com
>> > > >>       
>> > > >>       
>> > > >> 
>> > > >> ---
>> > > >> You are currently subscribed to freetds as: zhlu AT umich.edu
>> > > >> To unsubscribe, forward this message to
>> > > $subst('Email.Unsub')
>> > > >> 
>> > > >
>> > > >
>> > > >---
>> > > >You are currently subscribed to freetds as: pounder AT inline.net
>> > > >To unsubscribe, forward this message to
>> > > $subst('Email.Unsub')
>> > > >
>> > > >
>> > > 
>> > >  Jon Pounder,   Development Engineer
>> > >  Inline Internet Systems
>> > >  pounder AT inline.net Jon AT Pounder.com
>> > > 
>> > >  Web Tools Engineered for Success
>> > >  http://www.inline.net
>> > >  http://www.ihtml.com
>> > >  
>> > >  
>> > > 
>> > > ---
>> > > You are currently subscribed to freetds as: mpeppler AT peppler.org
>> > > To unsubscribe, forward this message to
>> $subst('Email.Unsub')
>> > > 
>> >
>> >-- 
>> >Michael Peppler         -||-  Data Migrations Inc.
>> >mpeppler AT peppler.org    -||-  http://www.mbay.net/~mpeppler
>> >Int. Sybase User Group  -||-  http://www.isug.com
>> >Sybase on Linux mailing list: ase-linux-list AT isug.com
>> >
>> >---
>> >You are currently subscribed to freetds as: pounder AT inline.net
>> >To unsubscribe, forward this message to
>> $subst('Email.Unsub')
>> >
>> >
>> 
>>      Jon Pounder,   Development Engineer
>>      Inline Internet Systems
>>      pounder AT inline.net Jon AT Pounder.com
>> 
>>      Web Tools Engineered for Success
>>      http://www.inline.net
>>      http://www.ihtml.com
>>      
>>      
>> 
>> ---
>> You are currently subscribed to freetds as: zhlu AT umich.edu
>> To unsubscribe, forward this message to
$subst('Email.Unsub')
>> 
>
>
>---
>You are currently subscribed to freetds as: pounder AT inline.net
>To unsubscribe, forward this message to
$subst('Email.Unsub')
>
>

        Jon Pounder,   Development Engineer
        Inline Internet Systems
        pounder AT inline.net Jon AT Pounder.com

        Web Tools Engineered for Success
        http://www.inline.net
        http://www.ihtml.com