[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