| Bug #65440 | Connection Failed error using Test button on ODBC client | ||
|---|---|---|---|
| Submitted: | 28 May 2012 15:30 | Modified: | 31 May 2012 7:43 |
| Reporter: | Martin Davies | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | Connector / ODBC | Severity: | S3 (Non-critical) |
| Version: | 3.51.30 | OS: | Windows |
| Assigned to: | Assigned Account | CPU Architecture: | Any |
[31 May 2012 7:43]
Bogdan Degtyariov
Thank you for reporting the problem in Connector/ODBC 3.51. We know about it already. This bug is marked as a duplicate of bug 65328.
Description: when configuring a new ODBC data source connection using 3.51.30, there is a 'Test' button which confirms the connection is successful. On using this button, the message is displayed: "Connection Failed: [HY000][ODBC 3.51 Driver]Access denied for user 'asp0022'@'%'to database '{asp0022-DATABASE-SQL}'" - where asp0022 is the user. This message is misleading as all applications using this connector are able to connect and query the database. This error did not occur in 3.51.24. MySQL server 5.0.77 Windows XP Main application used: SAP Crystal Reports 2011 How to repeat: Using Control Panel | Data Sources (ODBC) | Add new Data source | System DSN | create a new data source to a MySQL database | once the correct host, user and password have been entered and a database selected from the drop-down click on the 'Test' button and the message quoted will be displayed. ODBC Driver 3.51.30 MySQL server 5.0.77 Windows XP