Hello Im using OleDB from my ASP pages and I have a problem with queries with count(*) and group by statement. I had the same problem with ODBC but i Solved it by setting the "Change BigInt to Int" and the "Return all rows" option. Now I changed to OleDB for better speed but I don't know how to set these options.
So far my Database is pretty small with just 20 tables but it will grow fast and i want to use the best connection from start. Anybody have any ideas? Regards Mattias Persson --------------------------------------------------------------------- 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