FreeTDS Development Group

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

Hello,

I am looking for hours to get FreeTDS to work with SQL server 7.0 stored 
procedure.

I would like to place a call like:
{sp_procedure_name param1, param2, param3} (params are always input 
parameters)
and get the output parameters from the result set, for example:

ResultSet rs = st.executeQuery();

int i;

if (rs.next())
{
  i = rs.getInt("output_parameter")
}

I do not find a correct syntax to call the procedure.

I tried, with connection.prepareCall():

{call sp_procedure_name param1, param2, param3}
{exec sp_procedure_name param1, param2, param3}
{call sp_procedure_name(param1, param2, param3)}
{sp_procedure_name param1, param2, param3}
{sp_procedure_name (param1, param2, param3)}
{call sp_procedure_nam(?,?,?)} + statement.setXXX(1, value) [etc]

I really do not know how to get it to work.

Thank for your help,

Emmanuel.