Re: unixodbc and character identifier limits?
"James K. Lowden" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
Lukasz Szybalski wrote: > On Thu, Apr 3, 2008 at 11:00 AM, James K. Lowden <[email protected]> > wrote: > > > > Lukasz Szybalski wrote: > > > On Thu, Apr 3, 2008 at 10:33 AM, James K. Lowden > > > <[email protected]> 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@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