FreeTDS Development Group

["Brent L Johnson" <brent AT bjohnson.net>]

I've searched the newsgroups and found other people with similar problems
(especially when connecting to SQL Server).  I'm not sure if this is
driver related, SQL Server related, or JDBC related (which is why I'm
sending this to the list).

I have a search page which searches on a very large database.  One of the
search inputs is a multi select where the person can pick from quite a few
choices.  The report runs just fine, until (it seems) the SQL statement
gets "too large".

It's really strange, it runs fine with (I'm, of course, using FreeTDS
connecting to a SQL Server database) just a a few criteria selected.  But
if I go down and start clicking lots of selects all I get is this:

java.sql.SQLException: Network error- Connection reset by peer: Connection
reset by peer

I uncheck a few of the criteria and it works fine.  Is there a max to the
length of a sql statement sent?  If so, can I increase that, and why would
I get a connection reset by peer rather than some other error?

Any help would be appreciated, thanks,

- Brent