FreeTDS Development Group

["Emmanuel Blot" <eblot AT jijia12.grenoble.hp.com>]

Hello Bob,

THANKS, it works !

Emmanuel.

----- Original Message ----- 
From: "Bob Kline" <bkline AT rksystems.com>
To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
Sent: Tuesday, April 04, 2000 4:34 PM
Subject: [freetds] Re: Stored procedure and JDBC


> On Tue, 4 Apr 2000, Emmanuel Blot wrote:
> 
> > Hello,
> > 
> > I am looking for hours to get FreeTDS to work with SQL server 7.0
> > stored procedure.
> 
> Here's an example of a call to a stored procedure which takes one input
> parameter and produces a result set with two columns (INT and VARCHAR):
> 
>     Connection c = DriverManager.getConnection(url, uid, pwd);
>     Statement s  = c.createStatement();
>     ResultSet rs = Stmt.executeQuery("exec sp_t 50");
>     while (rs.next())
>         System.out.println(rs.getInt(1) + ", " + rs.getString(2));
> 
> Hope this helps.
> 
> -- 
> Bob Kline
> mailto:bkline AT rksystems.com
> http://www.rksystems.com
> 
> 
> 
> ---
> You are currently subscribed to freetds as: eblot AT sablet.grenoble.hp.com
> To unsubscribe, forward this message to $subst('Email.Unsub')
>