FreeTDS Development Group

["Schörk, Andreas" <andreas.schoerk AT infor.de>]

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')
>