Thank you SOOOOOOO much Michael! That did it. If only that little bug had been mentioned somewhere in the documentation.. Or perhaps it was and I missed it. At any rate, thanks again. And what kind of virtual beer would you like? =) Wigsy ----- Original Message ----- From: "Michael Peppler" <mpeppler@peppler.org> To: "Higgens" <higgens@home.com> Cc: <dbi-users@perl.org> Sent: Thursday, March 08, 2001 7:03 AM Subject: Re: DBD::Sybase and MS Sql Server 7 ntext - Out of Memory! > Higgens writes: > > Hello, I'm in a bit of a state and I'm hoping that someone can help me out. > > > > I've been racking my brain for the last two days trying to do something which I thought would be pretty simple. Getting the perl DBI to talk to a remote MS SQL Server. Well, it turns out that it is fairly easy to do this. I have implemented the FreeTDS module and the Sybase module for DBD and both are working nicely. EXCEPT for one huge issue that is making all of the work I've done pretty close to useless for my situation. I get a nasty "out of memory" error whenever I try to select a "text" field from the MS SQL Server. This error is reported from my OS (Linux) not the DBI from what I can tell. > > > > This appears to be a bug in either FreeTDS or MS-SQL. > > Anyway - the $dbh->{LongReadLen} attribute doesn't work with either > FreeTDS or MS-SQL (I forget which) because the underlying ct_option() > call fails. > > So use the more straightforward > > $dbh->do("set textsize <somesize>"); > > and that should fix the problem. > > As an aside - and for others using DBD::Sybase with FreeTDS: > DBD::Sybase is pretty stable and works correctly when used with the > Sybase libraries and a Sybase server. If you experience some serious > bugs I suggest that you first ask on the FreeTDS mailing list (see > http://www.freetds.org for details) because the problems are most > likely to be linked to FreeTDS (or MS-SQL) than to DBD::Sybase proper. > > Michael > -- > Michael Peppler - Data Migrations Inc. - mpeppler@peppler.org > http://www.mbay.net/~mpeppler - mpeppler@mbay.net > International Sybase User Group - http://www.isug.com > Sybase on Linux mailing list: ase-linux-list@isug.com >Thread Previous | Thread Next