FreeTDS Development Group

[Brett Knights <knights AT tanner.com>]

Hi,
I have just downloaded the freetds jdbc driver and it can't find my
stored procedures. 

it returns with a message that the stored procedure cannot be found. 

would someone give me an example of the syntax to use for a
prepareStatement call with freeTds?

I have tried :

PreparedStatement pstmt = con.prepareStatement("{sproc ?, ?}");
and
PreparedStatement pstmt = con.prepareStatement("sproc ?, ?");
and 
PreparedStatement pstmt = con.prepareStatement("exec sproc ?, ?");

TIA

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Brett Knights                                Tanner Research, Inc.    
MIS Analyst                                 2650 E. Foothill Blvd.  
brett.knights AT tanner.com                       Pasadena, CA  91107

voice  626-432-5767                               fax 626-792-0300
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 

> -----Original Message-----
> From: bounce-freetds-101769 AT franklin.oit.unc.edu
> [mailto:bounce-freetds-101769 AT franklin.oit.unc.edu]On Behalf 
> Of Michael
> Peppler
> Sent: Tuesday, February 22, 2000 5:25 PM
> To: TDS Development Group
> Subject: [freetds] Re: SybPerl
> 
> 
> Brian Bruns writes:
>  > 
>  > 
>  > On Tue, 22 Feb 2000, Dave Blob wrote:
>  > 
>  > > Does anyone use freetds with sybperl?  A lot of the test 
> seem to fail -
>  > > often times significant ones - having 2 connection open, 
> using message
>  > > handlers, etc.  I decided to try to use it anyhow, and 
> the sql() function
>  > > returns no data, but individual 
> dbcmd/dbsqlexec/dbresults work fine.  I
>  > > haven't had a chance to debug too far yet.
>  > >
>  > Hmmm...most people use DBD::Sybase.  I had it working ages 
> ago, but really
>  > haven't kept up with it. 
> 
> Note that if sybperl fails in the DBlib side it indicates some
> problems with the DBlibrary code in FreeTDS...
> 
> Michael
> -- 
> 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: knights AT tanner.com
> To unsubscribe, forward this message to 
> $subst('Email.Unsub')
> 
>