FreeTDS Development Group

["Adrian Hill" <adrian.hill AT nrm-internet.net>]

Hi again,

Many thanks for all responses to my request. I have tried the following
combinations to try to set tds version:

jdbc:freetds:sqlserver://127.0.0.10/MYDatabase;tds=7.0", "sa", "");
jdbc:freetds:sqlserver://127.0.0.10/MYDatabase;TDS=7.0", "sa", "");
jdbc:freetds:sqlserver://127.0.0.10/MYDatabase;tds=70", "sa", "");
jdbc:freetds:sqlserver://127.0.0.10/MYDatabase;TDS=70", "sa", "");

NB: I am using different db names and IP addresses - security's gotta
be protected y'know ;)

All of the above statements give the error:
java.sql.SQLException: Bad database name

If I take out the ";tds=7.0", it works!

If anyone else has any suggestions, they would be much appreciated.
Again, many thanks,


Adrian Hill

> From Rajkumar Seth:
> tds=7.0 I think the TDS bit might be case sensitive I think the
> documentation might be wrong try all the combinations :)
> By the way the documentation is being updated so let me know if it out of
> date.
> Let me know how you get on.

>> Original Message:
>> Still having problems with the tds driver I'm afriaid to say: If I pull
>> binary data from a database with a field length of 128 the it gives me a
>> java.lang.NegativeArraySizeException when I execute the SQL statement.
>>
>> I suspect this is because I have not set the tds version in my connect
>> statement. As I understand it, the connection should be made as follows:
>>
>> jdbc:freetds:sqlserver://127.0.0.10/MYDatabase;tds=7.0", "sa", "");
>>
>> But it gives an error...
>> java.sql.SQLException: Bad database name- MYDatabase;tds=7.0
>>
>> If I connect without the ";tds=7.0" appended to my database name then it
>> all works. Please could somebody help me solve this problem before I tear
>> the rest of my hair out! Many thanks,