I have recently had to update mySQL from 5.1 to 5.5 with a MS Access 2003 front end (via ODBC links)
When I run some legacy SQL queries on Access using a form I inherited (and worked fine before the rebuild) I am getting Visual Basic Error 3146 ODBC Call Failed.
I can run the code directly within mySQL so I am at a loss what the problem might be.
I have switched ODBC Tracing on, and get the following fragment in the log - which doesnt really help much:
InterconnecTRep 90-14f0 EXIT SQLExecDirect with return code -1 (SQL_ERROR)
UCHAR * 0x11CF44B4 [ 2010] "## This report currently includes ...(SQL is in here)" SDWORD 2010
DIAG [S1000] [MySQL][ODBC 5.1 Driver][mysqld-5.5.27-log]Query execution was interrupted (1317)
Does anyone know how I can force more detail on the 3146 error, so it shows me what the *real* problem is?