Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

Re: Re: Re: Retrieve MS SQL Image to per/UNIX

by cbro (Pilgrim)
on Jun 06, 2003 at 18:26 UTC ( #263809=note: print w/ replies, xml ) Need Help??


in reply to Re: Re: Retrieve MS SQL Image to per/UNIX
in thread Retrieve MS SQL Image to per/UNIX

cooperman,
Try:
$dbh->do("set textsize <somesize>");
From this site:
Sybase defaults the TEXTSIZE attribute (aka LongReadLen) to 32k, but MS-SQL 7 doesn't seem to do that correctly, resulting in very large memory requests when querying tables with TEXT/IMAGE data columns. The work-around is to set TEXTSIZE to some decent value via $dbh->{LongReadLen} (if that works - I haven't had any confirmation that it does) or via $dbh->do(``set textsize <somesize>'');


Comment on Re: Re: Re: Retrieve MS SQL Image to per/UNIX
Download Code
Re: Re: Re: Re: Retrieve MS SQL Image to per/UNIX
by Anonymous Monk on Jun 08, 2003 at 15:45 UTC
    cbro,
    I have already tried set textsize both from a ->do(...); statement and in the freetds.conf file. No dice. I am currently fiddling with the freetds nightly development build. I am hoping maybe something was advanced in 0.62 work. -Marc

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://263809]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (5)
As of 2015-07-04 03:28 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (57 votes), past polls