Wigsy writes:
> 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?
It's in the docs of the next release.
I wasn't aware of this problem until recently... (a couple of weeks
before you hit the problem :-)
Michael
> ----- Original Message -----
> From: "Michael Peppler" <[EMAIL PROTECTED]>
> To: "Higgens" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> 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. - [EMAIL PROTECTED]
> > http://www.mbay.net/~mpeppler - [EMAIL PROTECTED]
> > International Sybase User Group - http://www.isug.com
> > Sybase on Linux mailing list: [EMAIL PROTECTED]
> >
>
--
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]
