| Bug #27493 | Wrong result with DAO ODBCDirect | ||
|---|---|---|---|
| Submitted: | 28 Mar 2007 10:01 | Modified: | 18 Jan 2008 20:24 |
| Reporter: | Andrew Sitnikov | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | Connector / ODBC | Severity: | S2 (Serious) |
| Version: | 5.0.11 and late | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[28 Mar 2007 10:01]
Andrew Sitnikov
test case
Attachment: dao_err1.vbs (application/octet-stream, text), 1018 bytes.
[28 Mar 2007 10:22]
MySQL Verification Team
Got error: Error #0 Description: S1091: [MySQL][MyODBC 5.00.11] Descriptor type out of range In general query log: 070328 14:17:45 3 Connect ODBC@localhost as anonymous on 3 Query SET NAMES utf8 3 Query SELECT now() as dd 3 Query SELECT * FROM SELECT now() as dd
[18 Jan 2008 20:24]
Jess Balint
MySQL Connector/ODBC 5.0 has been discontinued. This bug is not repeatable with Connector/ODBC 5.1.
Description: Wrong result with MyODBC v5.0.11 + MS DAO ODBCDirect How to repeat: Install MyODBC v3.51 & v5.0.11 Download attached test case script Setup connection variables MysqlHost MysqlUID MysqlPwd MysqlDB Run attached vbs script from cmd. Current datatime will be displayed Remove comment (') before DriverStr = "MySQL Connector/ODBC v5" for select MyODBC v5 Run it again. Error will be displayed. mysqld sql log: MyODBC v3.51 070328 12:30:18 84719 Connect foo@bar on test 84719 Query SET SQL_AUTO_IS_NULL=0 84719 Query SELECT now() as dd MyODCB v5.0.11 070328 12:29:18 84711 Connect foo@bar on test 84711 Query SET NAMES utf8 84711 Query SELECT now() as dd 84711 Query SELECT * FROM SELECT now() as dd