Skip to Content.
Sympa Menu

freetds - RE: query length limits with MSSQL 6.5?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Schörk, Andreas" <andreas.schoerk AT infor.de>
  • To: "'TDS Development Group'" <freetds AT franklin.oit.unc.edu>
  • Subject: RE: query length limits with MSSQL 6.5?
  • Date: Tue, 18 Sep 2001 19:32:52 +0200


There is a limit on single (varchar) parameters round this size.
Is the query executable in query analyzer.
Which JDBC-Version do you use ?
Could you send the query to me ?
I would like to create a junit test.
Andreas

> -----Original Message-----
> From: brlewis AT alum.mit.edu [mailto:brlewis AT alum.mit.edu]
> Sent: Dienstag, 18. September 2001 17:33
> To: TDS Development Group
> Subject: [freetds] query length limits with MSSQL 6.5?
>
>
> 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/
>
> ---
> You are currently subscribed to freetds as: [andreas.schoerk AT infor.de]
> To unsubscribe, forward this message to
> $subst('Email.Unsub')
>




Archive powered by MHonArc 2.6.24.

Top of Page