Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: brlewis AT alum.mit.edu
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Cc: "'php-db AT lists.php.net'" <php-db AT lists.php.net>
  • Subject: Re: [PHP-DB] MSSQL + FreeTDS and No SQL Errors Returned
  • Date: 02 Aug 2000 11:51:47 -0400


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/




Archive powered by MHonArc 2.6.24.

Top of Page