Skip to Content.
Sympa Menu

freetds - RE: ODBC troubles with nightly snapshot

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Lowden, James K" <LowdenJK AT bernstein.com>
  • To: "'TDS Development Group'" <freetds AT franklin.metalab.unc.edu>
  • Subject: RE: ODBC troubles with nightly snapshot
  • Date: Mon, 24 Jun 2002 09:59:07 -0400


> From: Detlef Steuer [mailto:Detlef.Steuer AT unibw-hamburg.de]
> Sent: June 24, 2002 2:35 AM
>
> Where exactly I have to set TEXTSIZE? odbc.ini? interfaces?
> Enviroment? configure?

Detlef,

The UG syntax is wrong; the correct syntax is "set TEXTSIZE 8000". It would
be part of your SQL query. The statement affects all queries for the spid.


If you use freetds.conf (instead of interfaces), you can place the line:

text size = 8000 # or whatever

in either [global] or any dataserver section. That of course will affect
all queries, unless overridden by "set textsize".

Thank you for your question, by the way. It wasn't clear that it wasn't
clear, if you see what I mean. I'm working on the UG quite a bit these
days, and I can see I'm not done.

HTH.

--jkl




> On 21-Jun-2002 Lowden, James K wrote:
> >> From: Alex Hornby [mailto:alex AT anvil.co.uk]
> >> Sent: June 21, 2002 1:22 PM
> >>
> >> The TDS odbc driver doesn't seem to work for me with unixODBC-2.2.0
> >> connecting to a sybase 11.9.2 server (both on redhat 6.2).
> >>
> >> A backtrace shows:
> >>
> >> (gdb) bt
> >> #0 0x4018e487 in memcpy (dstpp=0x8058b18, srcpp=0x805e838,
> >> len=4294967295)
> >> at ../sysdeps/generic/memcpy.c:55
> >> #1 0x40238727 in tds_convert_char (srctype=47,
> >> src=0x805e838 "LON", ' ' <repeats 17 times>,
> srclen=4294967295,
> >> desttype=47, dest=0xbfff3a58 "1", destlen=301) at convert.c:253
> >> #2 0x4023a01b in tds_convert (locale=0x804ff90, srctype=47,
> >> src=0x805e838 "LON", ' ' <repeats 17 times>,
> srclen=4294967295,
> >> desttype=47, dest=0xbfff3a58 "1", destlen=301) at convert.c:935
> > Alex,
> >
> > Nice bt.
> >
> > srclen=4294967295? Methinks you need "set TEXTSIZE 8000"
> or so somewhere.
> >:)
> >
> > Some drivers initialize the connection with a size; we let
> the server do
> > what it wants.
> >
> > One of these days, I'm gonna put a very polite error message in
> > tds_convert_char that reminds the caller to "set TEXTSIZE
> to some plausible
> > number". Segfaulting without checking is unhelpful. :/
> >
> > ISTR Brian talking about making TEXTSIZE an item in
> freetds.conf, but I
> > don't see it in the docs, so I guess it's not there.
> >
> > Cheers,
> >
> > --jkl
> >
> > ---
> > You are currently subscribed to freetds as:
> [Detlef.Steuer AT unibw-hamburg.de]
> > To unsubscribe, forward this message to
> > $subst('Email.Unsub')
>
> Detlef Steuer --- http://fawn.unibw-hamburg.de/steuer.html
>
> ***** Encrypted mail preferred *****
>
> ---
> You are currently subscribed to freetds as: [LowdenJK AT bernstein.com]
> To unsubscribe, forward this message to
> $subst('Email.Unsub')
>




Archive powered by MHonArc 2.6.24.

Top of Page