Huge result files from bsqlodbc

Jochen Daum <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <CAPeqxCdL_N3VwOyUK0qhpawtORP1odHh295=iQ7EZiOy9_Bk2A@mail.gmail.com>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.