FreeTDS Development Group

[Stefan Bodewig <bodewig AT bost.de>]

>>>>> "SL" == Stephanie Lewis <slewis AT thinweb.com> writes:

 SL>               java.sql.SQLException: ntext data cannot be sent to
 SL> clients using DB-Library(such as ISQL) or ODBC earlier than 3.7or
 SL> earlier.

 SL>                              In Tds.java I changed the line:

No, don't do this, the value will be overwritten later (and 4.2 is the
default, that's why you don't see any effect.

The correct way (and this should go into the README) is to append
;tds=7.0 to your JDBC URL.

so use jdbc:freetds:sqlserver://server:port/database;tds=7.0 to enable
SQL Server 7 support.

Stefan