freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: FreeTDS + MSSQL + TEXT = "Out of memory!"

From: "Serguey Kolesov" <hedgehog AT strogino.ru>
To: "TDS Development Group" <freetds AT franklin.metalab.unc.edu>
Subject: Re: FreeTDS + MSSQL + TEXT = "Out of memory!"
Date: Wed, 27 Mar 2002 23:47:56 +0300

Hello again,

> I am trying to access TEXT columns on MSSQL 7.0, but I get "Out of
memory!"
> errors.
> Queries with other data-types work fine.

Ooops. I should have read the docs before posting to the list.
The answer was in http://www.freetds.org/faq.html
The value of the @@textsize on my MSSQL server is 2147483647 :o)

If I $dbh->do("SET TEXTSIZE 2048"); before anything else, everything
seems to work fine.

--
Serguey

FreeTDS + MSSQL + TEXT = "Out of memory!", Serguey Kolesov, 03/27/2002
- <Possible follow-up(s)>
- Re: FreeTDS + MSSQL + TEXT = "Out of memory!", Serguey Kolesov, 03/27/2002