Bug #24534 c/ODBC 5.00.09 does not list tables in MSQRY32
Submitted: 23 Nov 2006 9:37 Modified: 3 Dec 2007 8:47
Reporter: Tonci Grgin Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / ODBC Severity:S2 (Serious)
Version:5.1 OS:Windows (Win XP Pro (SP2))
Assigned to: Jess Balint CPU Architecture:Any
Tags: ODBC, ODBC5-RC

[23 Nov 2006 9:37] Tonci Grgin
Description:
MySQL connector/ODBC is unable to list tables in database. MSQRY32 returns "The datasource contains no visible tables".
I think this is ioncompatibility issue since generic MS ODBC client, ODBCT32(W) works correctly.
This problem is important since MS Excell uses MSQRY32 when querying database.

How to repeat:
 - Create File DSN
 - Open MSQRY32
 - Choose "New"
 - Pick File DSN created in step 1
 - Click "OK"
"The datasource contains no visible tables".
DM log attached. c/ODBC 5 log is quite big but it should be easy to reproduce the problem and get it.

Suggested fix:
-
[23 Nov 2006 9:38] Tonci Grgin
DM trace

Attachment: MSQRY32-5-00-09-SQL.zip (application/x-zip-compressed, text), 2.72 KiB.

[1 Feb 2007 9:47] Tonci Grgin
Jess, testing 5.0 from 2007-01-30 I get this behavior:
 - Using System DSN: Empty settings box pops-up (even though connection options are in place). When data is entered, "Debug Assertation failed, dbgHeap.c 1252 ...". MyODBC log attached. To me, the main problem is why saved settings are not loaded.
 - Using UserDSN: On first connect I get "DSN contains no visible tables". Close. Open DSN again, all is fine (ie. I see all tables in DB)
[1 Feb 2007 9:47] Tonci Grgin
MyODBC5 trace

Attachment: MYODBC5.zip (application/x-zip-compressed, text), 2.54 KiB.

[13 Apr 2007 0:49] Jared S
possible duplicate http://bugs.mysql.com/bug.php?id=24677
[13 Apr 2007 7:18] Tonci Grgin
Jared, I don't think so but thanks anyway. File DSN's are not yet fixed so this is verified with 2007-04-11 version too.
[21 May 2007 6:13] Tonci Grgin
Workaround provided in Bug#28546.
[29 Oct 2007 14:00] Susanne Ebrecht
I can reproduce this with MyODBC version 5.1. Exactly as described.
[3 Dec 2007 8:47] Tonci Grgin
Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at

  http://www.mysql.com/downloads/

Explanation: Both MyODBC drivers, latest releases, work as expected with MSQRY32 and FileDSN. Hint, when adding File DSN you will have to click Advanced button and fill in:
Server=your_server
UID=your_account
PWD=your_pwd
Database=your_db
as the default for "Add" button is just
[ODBC]
DRIVER=MySQL ODBC 5.1 Driver
which is not enough. After adding at least the info mentioned above, all works fine.