FreeTDS Development Group

["nick bhanji" <nbhanji AT home.com>]

Hello Again - I got further than before but I still have the same problem.
The problem is that when i run test t0001 i get the following error 1st 
time:
[bhanji@serve unittests]$ java t0001
Starting test t0001-  Insert and retrieve timestamps
AT POINT ONE                                    <--- debugging code
AT POINT TWO
AT POINT 3
Creating table affected 0 rows
AT POINT 4
AT POINT 5
java.sql.SQLException: Logon failed.  Msg 5703, Lvl 0, State 1, Changed 
language setting to 'us_english'.
, Server , Procedure , Line 1
1 connection are in use by this program
        at 
com.internetcds.jdbc.tds.Connection.allocateTds(Connection.java:341)
        at 
com.internetcds.jdbc.tds.Connection.prepareStatement(Connection.java:500)
        at t0001.main(t0001.java:51)

when I run it again:
[bhanji@serve unittests]$ java t0001
Starting test t0001-  Insert and retrieve timestamps
AT POINT ONE
AT POINT TWO
AT POINT 3
Creating table affected 0 rows
AT POINT 4
AT POINT 5
AT POINT 6
AT POINT 7
AT POINT 8
AT POINT 9
AT POINT 10
AT POINT 11
java.sql.SQLWarning: Stored procedure 'sa.jdbc_gen_temp_sp_names' not 
found. Specify owner.objectname or use sp_help to check whether the object 
exists (sp_help may produce lots of output).

        at 
com.internetcds.jdbc.tds.SqlMessage.toSQLWarning(SqlMessage.java:80)
        at 
com.internetcds.jdbc.tds.Statement.getMoreResults(Statement.java:597)
        at com.internetcds.jdbc.tds.Statement.execute(Statement.java:463)
        at 
com.internetcds.jdbc.tds.Tds.generateUniqueProcName(Tds.java:1883)
        at 
com.internetcds.jdbc.tds.Tds.getUniqueProcedureName(Tds.java:1947)
        at 
com.internetcds.jdbc.tds.PreparedStatement.execute(PreparedStatement.java:155)
        at 
com.internetcds.jdbc.tds.PreparedStatement.executeUpdate(PreparedStatement.java:345)
        at t0001.main(t0001.java:62)


I traced this to TDS.class where temp stored proc is made and delivered to 
DB.  I have question, is there anywhere in TDS that login id and password 
are not sent properly so that temp. procedure is not stored

Please HELP.

thank u in advance

nick.b