Skip to Content.
Sympa Menu

freetds - query length limits with MSSQL 6.5?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: brlewis AT alum.mit.edu
  • To: <freetds AT franklin.oit.unc.edu>
  • Subject: query length limits with MSSQL 6.5?
  • Date: 18 Sep 2001 11:33:23 -0400


One user is getting the infamous "unexpected 0x79 packet" with JDBC on a
page that otherwise works all the time. I suspect she is the first one
to put in enough text to make the query (exec usp_...) be longer than
4096 characters. Couldn't find anything about this in O'Reilly's
"Transact SQL" book or Server Configuration/Options on Enterprise
Manager.

Is there such a limit? Any workarounds? Please let me know.

--
Bruce R. Lewis <brlewis@[(if (brl-related? message)
"users.sourceforge.net"
"alum.mit.edu")]> http://brl.sourceforge.net/




Archive powered by MHonArc 2.6.24.

Top of Page