FreeTDS Development Group

[brlewis AT alum.mit.edu]

Steven Campbell <sammynrg AT phalanx.bloor1.on.wave.home.com> writes:

> Yeah, I get that all the time, especially returning large result sets.
> I've been able to minimize the core dumps by minimizing my use of stored
> procedures and cursors that return huge chunks of data. Sucks since most
> of what I need to do is already written in the form of stored procs, all
> I need to do is exec it with the correct parameters.

Have you tried "set nocount on" in your stored procs?  I use stored
procs with freetds_jdbc against MSSQL 6.5 and have no trouble except
with stored procs that send mail.

> The other unfortunate is that I don't have a choice but to use FreeTDS.

If things continue not to work, you could try the freetds_jdbc driver,
but I think that would mean using BRL or JSP instead of PHP for those
pages that need it.

-- 
Bruce R. Lewis                          http://brl.sourceforge.net/