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

Steven Campbell <sammynrg@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/