Hi, I think that adding .....;Extended Properties="OPTION=16400" to your ADO connection string should do the trick.
Cheers, Bruce -----Original Message----- From: Mattias Persson [mailto:[EMAIL PROTECTED]] Sent: 08 January 2002 13:29 To: [EMAIL PROTECTED] Subject: OleDB 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 --------------------------------------------------------------------- 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
