Reconnect option in mysql

Hi,
   
  I have a application written in c. I use mysql odbc drivers to coneect to the mysql database and i m new to this. I am getting the "mysql server gone away" error.
   
  After doing google i search i came to know abt the "wait_timeout" variable...but i would like not to make use of this and instead do some thing in the code.
   
  I want to know is thr any function which we can use so that the reconnect option can be enabled..once i establish my connection at the beginning.
   
  Also can someone pls tell me if "SQLSetConnectOption" function can be used to do the same.
   
  Thanks.
  Avadhut.


Thanks. 
Avadhut U. Bhangui 
Mobile: +91-9845376250 







 				
---------------------------------
 Here’s a new way to find what you're looking for - Yahoo! Answers