[PHP-DB] MSSQL + FreeTDS and No SQL Errors Returned

brlewis at alum.mit.edu brlewis at alum.mit.edu
Wed Aug 2 11:51:47 EDT 2000

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/

More information about the FreeTDS mailing list