FreeTDS Development Group

[Malte Grunwald <mg AT clearing-bank.de>]

Hallo,

I know the MS SQL 4... is totally out of date, but we have to stick with
it since an old back-office is connected to the database:


I am creating an simple prepared statement:

con.createPreparedStatement(SELECT * FROM table WHERE name = ?);

executing the Query I get the following error:

..tds.PreparedStatement.submitProcedure: Must declare '@P1'

I have checked the stored procedure which is created by the driver:

create proc #jdbc#1 ( @P1 char(255)) as SELECT * FROM table WHERE field =
@P1


This string makes absolutely sense (as well for the old version of
database)


Does anyone have an idea what could go wrong? 

Thanks for any help and have a nice eastern..

Malte

***********************************************************************
Malte Grunwald
Risiko Management/System Entwicklung
Clearing Bank Hannover AG
***********************************************************************