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. - [EMAIL PROTECTED]
http://www.mbay.net/~mpeppler - [EMAIL PROTECTED]
International Sybase User Group - http://www.isug.com
Sybase on Linux mailing list: [EMAIL PROTECTED]
