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