Bug #25550 MyODBC5 Doesn't return the database name in SQLGetInfo()

• Submitted: 11 Jan 2007 16:27
• Modified: 2 Jan 2008 22:40
• Reporter: Bogdan Degtyariov
• Status: Can't repeat
• Category: Connector / ODBC
• Severity: S2 (Serious)
• Version: 5.1
• OS: Windows (Windows)
• CPU Architecture: Any

[11 Jan 2007 16:27] Bogdan Degtyariov

Description:
This bug isn't present in 3.51.x, however it causes lots of problems in MS Office applications such as MS Query, MS Excel, MS Access. Alhough client connects to MySQL using DSN that contains the name of the database it cannot get the database name.

How to repeat:
Create a new System DSN
Provide all needed info along with the database name.
Run the C++ test case uploaded below.

[11 Jan 2007 16:27] Bogdan Degtyariov

C++ Test Case

Attachment: test13478.cpp (text/x-c++), 3.07 KiB.

[6 Feb 2007 10:17] Erica Moss

This problem came up again while working on the ADO compliance tests.  Please see test script cndefdat.vbs.  The test fails on line 51:
t1 = connection1.DefaultDatabase

If you examine the connection object, it is evident that this property is not set:
: DefaultDatabase : <Provider does not support the property.> : String : test module.myTest

[17 Oct 2007 17:23] Bogdan Degtyariov

This looks like a duplicate of bug#3780

[2 Jan 2008 22:40] Jess Balint

cnfdefdat.vbs correctly retrieves DefaultDatabase in ODBC 5.1 svn r975 (5.1.2-dev)