Interestingly I found http://support.microsoft.com/kb/251248 article which say , Connection Timeout and Query Timeout Not Supported with Microsoft Oracle ODBC Driver and OLE DB Provider.
I am using sql query in mb and hitting the database. Some other applications are causing deadlock in the db (and stops processing transactions of broker). Since db calls in the mb ...