[freetds] unixodbc and character identifier limits?

James K. Lowden jklowden at freetds.org
Mon Apr 7 15:57:47 EDT 2008


Lukasz Szybalski wrote:
> On Thu, Apr 3, 2008 at 11:00 AM, James K. Lowden <jklowden at freetds.org>
> wrote:
> >
> > Lukasz Szybalski wrote:
> >  > On Thu, Apr 3, 2008 at 10:33 AM, James K. Lowden
> >  > <jklowden at freetds.org> wrote:
> >  > > Lukasz Szybalski wrote:
> >  > >  > I came across a 30 character
> >  > >  >  identifier limit. In results I wasn't able to query my
> >  > >  >  records unless
> >  > >  > I have changed the identifier name to something under 30 char.
> >  > >
> >  > >  It sounds like you're using TDS 4.2 or a Sybase server.
> >  >
> >  > lucas at debianlaptop:~$ apt-cache policy tdsodbc
> >  > tdsodbc:
> >  >   Installed: 0.63-3.2
> >  >
> >  > and I am using sqlserver 2000.
> >
> >  Yes.  I wasn't referring to the FreeTDS release.  I was referring to
> >  the version of the TDS protocol you're using.  It's controlled by the
> >  configure script, the "tds version" setting in freetds.conf and the
> >  TDSVER environment variable (later overriding earlier).  See the UG
> >  for details.
> 
> What version should I change it to? Right now it has:
> 
> [global]
>         # TDS protocol version
>     tds version = 4.2

http://www.freetds.org/userguide/choosingtdsprotocol.htm

"Version 7.0 is recommended for compatibility with SQL Server tools."

Change 

     tds version = 4.2

to

     tds version = 7.0

HTH.

--jkl



More information about the FreeTDS mailing list