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: ZIGLIO Frediano <Frediano.Ziglio AT vodafoneomnitel.it>
  • To: "'TDS Development Group'" <freetds AT franklin.metalab.unc.edu>
  • Subject: RE: ODBC troubles with nightly snapshot
  • Date: Mon, 24 Jun 2002 16:08:57 +0200


>
> > 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.
>
I think a best solution should be use variable field for big one (ex: field
>1K should be reallocated if needed). This should solve the missing TEXTSIZE
problem. Also If I want to put DivX on a column I can. Do you think this
feature can be usefull (I think it'll be a 0.7 feature...) ?

freddy77

=================================
"STRICTLY PERSONAL AND CONFIDENTIAL

This message may contain confidential and proprietary material for the sole
use of the intended recipient. Any review or distribution by others is
strictly prohibited. If you are not the intended recipient please contact
the sender and delete all copies.
The contents of this message that do not relate to the official business of
our company shall be understood as neither given nor endorsed by it."

=================================




Archive powered by MHonArc 2.6.24.

Top of Page