FreeTDS Development Group

["Lowden, James K" <LowdenJK AT bernstein.com>]

From: Michael Hudin [mailto:hudin AT zoetrope.com]
Sent: May 3, 2002 2:33 PM

I'm using DBI and DBD::SYBASE through freetds 4.2 to connect to an 
MSSQL 7.0 sp4 server.

I'm trying to retrieve a pdf file from the database
The pdf file is, as you may imagine, stored in a column of type 
IMAGE.  If I try to retrieve the entire file I just get an empty 
string.  

Michael, 

I tried to reproduce this, but no luck.  I haven't wired up perl; I'm using
sqsh.  

I loaded a single-column table of type IMAGE with a pdf file, size  728,281
bytes.  I set textsize to 800,000, and retrieved the whole thing (or so it
seems; I'm not too good a reading PDFs without xpdf. ;) )

I have:

        NetBSD 1.5.2
        FreeTDS 0.53 
        sqsh 1.7

1> select @@textsize, @@version
2> go
----------------------------------------------------------------
      800000
        Microsoft SQL Server  7.00 - 7.00.859 (Intel X86)
        Apr 26 2000 18:57:49
        Copyright (c) 1988-1998 Microsoft Corporation
        Enterprise Edition on Windows NT 4.0 (Build 1381: Service Pack 6)

Don't know what this means, but HTH.  

I know it's a pain, but if I were in your shoes, I'd rebuild DBD with
symbols, run the query while perl is in gdb, and look at the backtrace after
the segfault.  I wonder whether it will point to FreeTDS, DBD, or some
server flakeyness.  

Regards, 

--jkl