Skip to Content.
Sympa Menu

freetds - RE: BLOB with MSSQL 7 - more information

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: BLOB with MSSQL 7 - more information
  • Date: Fri, 3 May 2002 17:11:58 -0400


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




Archive powered by MHonArc 2.6.24.

Top of Page