FreeTDS Development Group

["Varley, David(CBorn at Alcoa)" <David.Varley AT alcoa.com.au>]

You're right, that does "fix" the problem (and yes, it is SQLServer 7).
And I rebuilt sqsh on Linux, and exactly the same thing happened there.
However I was puzzled as to why this had just started with latest code,
as I'm tracking CVS changes pretty much daily.

The "_image" field in the all_types test table is a 16 byte long binary,
with 8-byte contents (20120304).
When I use tsql, it seems to display it correctly.

 bash-2.02# tsql -S Bakes -U user -P password
 Msg 5703, Level 0, State 1, Server CPRO200, Line 0
 Changed language setting to us_english.
 1> select '>',_image,'<' from all_types
 2> go
         _image
 >       3230313230333034        <

but for some reason sqsh now wants to display it as a binary surrounded
by a large amount of blank space, limited by "set textsize" as you pointed
out, or else segfaulting.

I've attached the freetds.log file. 

David

> -----Original Message-----
> From: Castellano, Nicholas [mailto:Nicholas_Castellano AT acml.com]
> Sent: Thursday, 10 October 2002 11:41 PM
> To: TDS Development Group
> Subject: [freetds] Memory alloc failure (was RE: WARNING: update your
> autoconf)
> 
> 
> What type of server is "Bakes"?  (i.e. "select @@version")
> 
> It sounds like you're experiencing the infamous "4 gigabyte 
> text column"
> problem on a Microsoft SQL server.  Try executing "set 
> textsize 8192" first
> and see if that helps.  If so, you can put "text size = 8192" in your
> freetds.conf.  See the FAQ or userguide for more details.
> 
> Cheers,
> --nick
> 
> -----Original Message-----
> From: bounce-freetds-145195 AT franklin.oit.unc.edu
> [mailto:bounce-freetds-145195 AT franklin.oit.unc.edu] 
> Sent: Wednesday, October 09, 2002 9:07 PM
> To: TDS Development Group
> Subject: [freetds] RE: WARNING: update your autoconf
> 
> 
> Good stuff, after rebuilding automake and libtool as well, I 
> now get an
> identical "configure" when running autogen.sh on Tru64 or 
> Linux systems :)
> 
> After build and install, other problems arose, however :(
> I'm blaming CVS state for now. But on the Tru64 system sqsh 
> refused to run,
> complaining about incorrect library versions. So I rebuilt 
> sqsh, now it
> runs, but fails on the "image" column from the all_types 
> table as follows:
> 
>  bash-2.02# sqsh -S Bakes -U user -P password
>  sqsh-2.1 Copyright (C) 1995-2001 Scott C. Gray
>  This is free software with ABSOLUTELY NO WARRANTY
>  For more information type '\warranty'
>  [21] Bakes.Bakes.1> select _image from all_types;
>  dsp_desc_bind: Memory alloc failure for native column 1
>  [22] Bakes.Bakes.1> quit
> 
> On Linux sqsh fails instead with:
>  \connect: unable to install message callback
> 
> (I haven't recompiled it on Linux yet.)
> 
> David
> 
> 
> The information contained in this transmission may contain 
> privileged and
> confidential information and is intended only for the use of 
> the person(s)
> named above.  If you are not the intended recipient, or an 
> employee or agent
> responsible for delivering this message to the intended recipient, any
> review, dissemination, distribution or duplication of this 
> communication is
> strictly prohibited. If you are not the intended recipient, 
> please contact
> the sender immediately by reply e-mail and destroy all copies of the
> original message. Please note that for certain accounts we do 
> not accept
> orders and/or instructions by e-mail, and for those accounts 
> we will not be
> responsible for carrying out such orders and/or instructions. 
> Kindly refrain
> from sending orders or instructions by e-mail unless you have 
> confirmed that
> we accept such communications for your account. Please also 
> note that to
> satisfy regulatory requirements we review the outgoing and 
> incoming e-mail
> correspondence of staff members serving certain functions.
> 
> 
> 
> ---
> You are currently subscribed to freetds as: 
> [David.Varley AT alcoa.com.au]
> To unsubscribe, forward this message to 
> $subst('Email.Unsub')
>

Attachment: freetds.log
Description: Binary data