List:MySQL ODBC« Previous MessageNext Message »
From:Ed Carp Date:March 16 1999 1:03am
Subject:Re: myodbc: Query problems using MS Access 7
View as plain text  
>Please do a MyODBC trace log (not an ODBC log) and check the queries
>Access tries to do!  In some case Access generates illegal SQL queries
>when connecting to remote servers!

If you are running Access 97, you can force Access to pass the SQL through
unchanged to the backend by selecting "Query|SQL Specific|Pass-Through" from
the Access menu.  This works for me - doing something simple like "SELECT
Mail.X_From, Count(Mail.X_From) AS CountOfX_From FROM Mail GROUP BY
Mail.X_From ORDER BY Count(Mail.X_From) DESC;" gives me an error, but
turning on passthrough (1) works without error, and (2) runs a lot faster.

myodbc: Query problems using MS Access 7Michael Widenius15 Mar
Re: myodbc: Query problems using MS Access 7Ed Carp16 Mar