Bug #49948 | Field not returned via ODBC connection | ||
---|---|---|---|
Submitted: | 27 Dec 2009 23:14 | Modified: | 1 Feb 2010 9:08 |
Reporter: | Zoltan Kiss | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | Connector / ODBC | Severity: | S2 (Serious) |
Version: | mysql connector odbc 5.1.6 win32 | OS: | Windows (XP32 SP3 Hungarian) |
Assigned to: | CPU Architecture: | Any | |
Tags: | ODBC driver 5.1.6 problem |
[27 Dec 2009 23:14]
Zoltan Kiss
[28 Dec 2009 15:26]
MySQL Verification Team
I couldn't repeat on Windows Vista X64 and linking the table with MS Access 2003.
[1 Feb 2010 9:08]
Tonci Grgin
Zoltan, I can not repeat this too using ODBCte32w generic Microsoft ODBC client... All went just fine: Full Connect(Default) Env. Attr. SQL_ATTR_ODBC_VERSION set to SQL_OV_ODBC3 Successfully connected to DSN '5-1-6-on-opensol'. SQLExecDirect (create table): In: hstmt = 0x008F5BA8, szSqlStr = "", cbSqlStr = -3 Return: SQL_SUCCESS=0 SQLExecDirect (select *): In: hstmt = 0x008F5BA8, szSqlStr = "", cbSqlStr = -3 Return: SQL_SUCCESS=0 Get Data All: "AZONOSITO", "SZINT", "NEV" 0 rows fetched from 3 columns. I suggest you take a look at your MySQL server error log and general query log and see if you can find anything there. If not, start ODBC trace and check.