[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