Skip to Content.
Sympa Menu

freetds - Re: JDBC Max Column Name Length

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Paul Schaap" <paul.schaap AT dingoblue.com.au>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: Re: JDBC Max Column Name Length
  • Date: Wed, 21 Feb 2001 20:43:01 -0500


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




Archive powered by MHonArc 2.6.24.

Top of Page