FreeTDS Development Group

["Paul Schaap" <paul.schaap AT dingoblue.com.au>]

Bob/Stefan,

Thankyou that was it ! But it ended up being ";TDS=7.0".

I had actually tried it as per the README ";TDS=70" and it failed, you set me 
on
the right path and I used the source :-) to find it wanted the ".". You just 
have
to love open source don't you. Can someone with CVS access patch the README
56,57c56,57
<     TDS        TDS protocol version to use.  Can be "42", "50", or "70".
<                Defaults to "42".
---
>     TDS        TDS protocol version to use.  Can be "4.2", "5.0", or "7.0".
>                Defaults to "4.2".
59c59
< e.g. "jdbc:freetds:sqlserver://servername/database;CHARSET=cp950;TDS=70"
---
> e.g. "jdbc:freetds:sqlserver://servername/database;CHARSET=cp950;TDS=7.0"

CHEERS
Paul

> On 21 Feb 2001, Stefan Bodewig wrote:
> 
> > Paul Schaap <paul.schaap AT dingoblue.com.au> wrote:
> > 
> > > Is it a TDS protocol issue ?
> > 
> > Are you using ";tdsver=7.0" in your JDBC-URL to specify you want to
> > use SQL Server 7 specific features? I'm not sure but maybe the column
> > length has been restricted to 30 chars in TDS 4.2?
> 
> Right.  Old max was 30; new max is 128.
> 
> -- 
> Bob Kline 
> mailto:bkline AT rksystems.com 
> http://www.rksystems.com