Bug #6704 CDatabase::GetConnect()

• Submitted: 18 Nov 2004 19:07
• Modified: 24 Oct 2005 18:11
• Reporter: Massimo Colurcio
• Status: Closed
• Category: Connector / ODBC
• Severity: S3 (Non-critical)
• Version: MyODBC 3.51.10.00
• OS: Windows (WinXP)
• Assigned to: Peter Harvey
• CPU Architecture: Any

[18 Nov 2004 19:07] Massimo Colurcio

Description:
It seems there is a problem using the MySQL ODBC Driver 3.5.10
I'm using Visual C++ 6.0 Sp5 accessing to the database via CDatabase & CRecordset classes.

I recognized this problem:

the method CDatabase::GetConnect() returns a string containig the connection string similar to this:

ODBC;DSN=MyDNS;DESC=MySQL ODBC 3.51 Driver DSN;DB=TestDB;SERVER=Server;UID=myuid;PASSWORD=mypassword;PORT=3306;SOCKET=;OPTION=3;STMT=;

It should be

ODBC;DSN=MyDNS;DESC=MySQL ODBC 3.51 Driver DSN;DB=TestDB;SERVER=Server;UID=myuid;PWD=mypassword;PORT=3306;SOCKET=;OPTION=3;STMT=;

How to repeat:
Invoke CDatabase::GetConnect() method

Suggested fix:
PWD instead of PASSWORD, according to the others ODBC drivers behaviour.

[18 Nov 2004 20:48] MySQL Verification Team

I was able to repeat:

{"ODBC;DSN=replixdb;DESC=;DB=replixdb;SERVER=localhost;UID=root;PASSWORD=;PORT=3306;SOCKET=;OPTION=155;STMT=;"}

Thank you for the bug report.

[24 Oct 2005 18:11] Peter Harvey

c/odbc v3.51.12 now uses the standard connection attribute keywords while supporting the use of the non-standard for legacy apps.