I'm using a CRecordset object to connect to a SQL Server database through an ODBC connection.
However sometimes the query takes more than 15 seconds and the call to open times out.
// Loop that tries to obtain the result of a query.
catch (CDBException* e )
// Give it one more chance
Setting SetQueryTimeout(0) has absolutely no effect. I keep trying in my loop because sometimes I've just waited too little for my whole data set to be ready and on a new request I actually get the info.
Anyone knows a more efficient way to do this ?