At 19/10/2002 19:16, Venu wrote: > Its because of mysql_store_result(), instead you should > check the option 'Don't cache results' to use > 'mysql_use_result()'.
I tried to uncheck the option " Don't cache results " (with MyODBC 3.51.04 it is " Don't cache Results(only for forward-only cursor) ") and I solved the " opening " problem... but it created 2 new problems: 1. the " closing " time is about 20 seconds (the same time opening the recordset with that check unchecked) 2. I wasn't able to edit/addnew records > Must have client side cursor in this case as driver can't > simulate server side/scrollbale cursor on non-cached result > sets. I think I can only set a flag that enables/disables cursor (I don't know if it is client side or server side) for the entire database (not a single table) using this syntax (from MSDN): CDatabase::Open virtual BOOL Open( LPCTSTR lpszDSN, BOOL bExclusive = FALSE, BOOL bReadOnly = FALSE, LPCTSTR lpszConnect = "ODBC;", BOOL bUseCursorLib = TRUE ); As you can see I can only enable/disable the cursor library. Any clues for me? TIA, Massimo. ----------------------------------------------------- This mail sent through IMP: http://web.horde.org/imp/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php