search

nasihere / pyodbc

Automatically exported from code.google.com/p/pyodbc
MIT No Attribution
0 stars 0 forks source link

Linked MySQL tables in Access 2013 #321

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
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 jonathan...@telanova.com on 1 May 2013 at 10:21