Skip to Content.
Sympa Menu

freetds - Re: [freetds] Huge result files from bsqlodbc

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Jochen Daum <jd AT automatem.co.nz>
  • To: FreeTDS Development Group <FreeTDS AT lists.ibiblio.org>
  • Subject: Re: [freetds] Huge result files from bsqlodbc
  • Date: Wed, 21 Nov 2012 22:35:08 +1300

In addition: the content of odbcfile.pdf is correct as far as I can
see from less.

Jochen

On 21 November 2012 22:33, Jochen Daum <jd AT automatem.co.nz> wrote:
> Hi,
>
> When I run a query through bsqlodbc/FreeTDS against a single text
> column, I'm getting huge result files.
>
> The command I use is: bsqlodbc -U sa -P **** -S EIS -D
> ExportInformationSystem -i attachment.sql -o odbcfile.pdf -e odbcerror
>
> attachment.sql:
> select [Attachment].[attaId], [Attachment].[attaFilename],
> CAST([Attachment].[attaContent] as varchar(max)) as [attaContent]
> FROM [Attachment]
> WHERE ([Attachment].[attaId] = 2910)
> ORDER BY [Attachment].[attaId]
>
> The text column contains 160832 bytes.
>
> I tried changing "text size" in /etc/freetds/freetds.conf, but it does
> not seem to have any effect.
>
> I'm concerned that the query doesn't return anything through PHP on my
> web server is that it is running out of memory?
>
>
>
>
>
> Kind Regards,
>
> Jochen Daum



--
P.S.: Latest newsletter: Website application reporting - an overview -
http://eepurl.com/pKrAD

Kind Regards,

Jochen Daum

"There is no shortcut to anywhere worth going" - Beverly Sills

Automatem Ltd
Phone: +64 9 630 3425
Mobile: +64 21 567 853
Email: jd AT automatem.co.nz
Website: www.automatem.co.nz
Skype: jochendaum
http://nz.linkedin.com/in/automatem
http://twitter.com/automatem




Archive powered by MHonArc 2.6.24.

Top of Page