Beefy Boxes and Bandwidth Generously Provided by pair Networks Cowboy Neal with Hat
Welcome to the Monastery
 
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 perusing the Monastery: (15)
As of 2014-04-23 17:38 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    April first is:







    Results (551 votes), past polls