JDBC driver: ntext data cannot be sent...

Stefan Bodewig bodewig at bost.de
Mon Sep 4 03:24:35 EDT 2000


>>>>> "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



More information about the FreeTDS mailing list