Bug #12180 error using linked MYSQL tables in Microsoft Access from Microsoft Excel

• Submitted: 26 Jul 2005 15:45
• Modified: 24 Jul 2007 17:45
• Reporter: Ivano Luberti
• Status: Can't repeat
• Category: Connector / ODBC
• Severity: S1 (Critical)
• Version: 3.51.11
• OS: Windows (Windows XP PRO)
• CPU Architecture: Any
• Tags: ODBC5-RC

[26 Jul 2005 15:45] Ivano Luberti

Description:
I have installed on my pc MYODBC 3.51.11 and configured 
a DSN. 
Then I linked mysql tables in an Access database and all went well. 
Starting from this I wrote some queries in Access, using the Access 
sql dialect against the linked tables and again all went well. 
Finally I used the get external data feature in excel to display the 
queries in an Excel sheet (ie using MS Query). 
Things kept on going well until I installed Windows XP Pro instead of the 
previous Windows 98. 

I have installed on the same  pc: MyODBC 3.51.11, Windows XP Pro 
(SP2), Office 2003 (updated). Then I linked tables and made the already described steps.

The new configuration works well in Access, but when I try to use 
Excel to get data from Access an error appears saiyng there is a 
failure trying to connect to the DSN. 

"Obviously" trying to use de DSN directly choosing it from the list displayed in the list displayed by MSS Query (and not via Access) all goes well. 

On the same pc also happens the "Could not determine the driver name so could not lookup setup library" error trying to define a new DSN from inside the MS Query software.

How to repeat:
On a PC with  MyODBC 3.51.11, Windows XP Pro 
(SP2), Office 2003 (updated). 

Configure a DSN with the  MYODBC driver.
Link a mysql table in an Access database.
From an Excel sheet try to get external data from the data menu, choosing the option Microsoft Access option: from the dialog box choose the access database file where you have linked the table.
Put the linked table in the query
Try to put a field in the query: here comes the error.

Suggested fix:
no idea

[27 Jul 2005 9:14] Vasily Kishkin

Hi Ivano

When I try to import external data in excel and choose access file I've got error message of MS Query:

Could not use "|"; file already in use

And I could't choose table and fields. Do you know what's problem ?

[27 Jul 2005 9:43] Ivano Luberti

have you closed the Access software ?
You must quit it after you have linked the tables

[27 Jul 2005 23:22] MySQL Verification Team

If understand well you did:

1- Linked an MySQL table in Access using MyODBC.
2- Closed Access
3- Opened Excel and try to use the linked MySQL table via the mdb Access File

Thanks in advance.

[28 Jul 2005 7:02] Ivano Luberti

yes, Miguel you understood well

[28 Jul 2005 12:01] Vasily Kishkin

Thanks for advice.
I got the message "ODBC - connection to 'myodbc' failed". So...as far as I can understand - is it the error ?

[29 Jul 2005 7:11] Ivano Luberti

yes, it is

[29 Jul 2005 8:19] Vasily Kishkin

Tested on Access/Excel 2003, Windows 2003 Server, MySQL 4.1.13, MyODBC 3.51.11

[29 Jul 2005 8:26] Ivano Luberti

Do you mean that has the same error been raised ?

[24 Jul 2007 17:45] Jim Winstead

I was unable to reproduce this problem with Connector/ODBC 3.51.17. It may have been fixed since 3.51.11, which is where the bug was reported and last reproduced.

If it does re-occur, please provide the specific table definition of the MySQL table, and the exact steps to reproduce. Thanks.

[31 Jul 2007 6:27] Tonci Grgin

3.51.11 had several similar problems, mostly fixed in 3.51.11-2 so no wonder no one can repeat.