What steps will reproduce the problem?
1.Access database with MySQL linked tables
2.Create connection object to MS Access using ODBC DSN
3.Attempt to access data in linked tables
What is the expected output? What do you see instead?
Expect data in linked table to be returned. Get error message:
curs.execute("SELECT * from table")
Error: ('HY000', "[HY000] [Microsoft][ODBC Microsoft Access Driver]
ODBC--connection to 'database' failed. (-2001) (SQLExecDirectW)")
What version of the product are you using? On what operating system?
Server 2012 (64bit), MS Access 2013 (64bit), Python 2.7 (64bit), Pyodbc 3.0.6
(64bit)
Please provide any additional information below.
This works on Server 2003 (32bit) /Access 2003/python 2.7/pyodbc 3.0.5.
I have created the linked tables with the 'save password' box checked.
Original issue reported on code.google.com by j...@telanova.com on 1 May 2013 at 10:21
Original issue reported on code.google.com by
j...@telanova.comon 1 May 2013 at 10:21