I am not sure of Putty as I am using plink.exe that is the SSH tunneler for tunnel.
The thing is that I call up plink.exe from my app to create an ssh tunnel and then set the correct values for mysql_real_connect() in my app. What I am doing is that I am bundling plink.exe with my app and then ask the user for SSH info. Depending upon that I create a plink.exe process and then connect my app to the SSH process. I referred to Putty as many people seem to be using it and putty usese plink.exe which is the back end for it. Should I look into some options like what you suggested? Regards, Karam --- "Adams, Pat 006" <[EMAIL PROTECTED]> wrote: > > -----Original Message----- > > From: Karam Chand [mailto:[EMAIL PROTECTED] > > > Sent: Friday, December 10, 2004 12:08 PM > > To: [EMAIL PROTECTED] > > Subject: Lost connection during query when using > SSH tunneling > > > > So I use Putty to create the SSH tunneler and then > connecting > > to the local port. > > > > Now the problem, is that whenever I execute a long > query or > > something that returns big resultset, i get an > error - > > > > Lost connection during query. > > > > If I use direct connection - everythings fine. > > Putty has an option in the Connection category of > the configuration for > Seconds between keepalives. It's set to zero (off) > by default. If you > set it to > 0 number, putty will send a null packet > at the server to try > and keep the connection alive. Have you tried that? > > -- > Pat Adams > Applications Programmer > SYSCO Food Services of Dallas, L.P. > (469) 384-6009 > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > __________________________________ Do you Yahoo!? Jazz up your holiday email with celebrity designs. Learn more. http://celebrity.mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]