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: | |
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
[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.