My favorites | Sign in
Project Home Downloads Wiki
READ-ONLY: This project has been archived. For more information see this post.
Search
for
  Advanced search   Search tips   Subscriptions
Issue 321: Linked MySQL tables in Access 2013
1 person starred this issue and may be notified of changes. Back to list
Status:  New
Owner:  ----


 
Reported by jonathan...@telanova.com, May 1, 2013
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.


Powered by Google Project Hosting