[MySQL][ODBC 5.3(a) Driver][mysqld-5.6.34-log]Invalid descriptor index {07009,NativeErr = 9}

[Yogesh Chaudhari]

Hi,

I want to upgrade my server OS from Oracle Linux 6 to Oracle 7. The current server (Oracle Linux 6 with mysql-connector-odbc-5.1.5r1144-7.el6.x86_64) is pulling data from more than 50 tables MySQL database v 5.6.34 without any issue. MySQL database is running in Amazon cloud and I have only read-only access. I ran the program daily to sync tables for past one year successfully and never saw ""Invalid descriptor index" error.

I build the new server with Oracle Linux 7 and installed mysql-connector-odbc-5.3.9-1.el7.x86_64 driver. ODBC connectivity to MySQL server is successful, but when I run the program to fetch data from MySQL database. I am receiving "Invalid descriptor index" error every time when I ran my program, but for different table.

e.g.

SQL> select count(1) from case_tasks_dim;
+---------------------+
| count(1) |
+---------------------+
| 9216935 |
+---------------------+
SQLRowCount returns 1
1 rows fetched
SQL> select * from case_tasks_dim;
SQLRowCount returns -1

odbctrace.log:

Entry:
Statement = 0x17ecfd0
SQL = [select * from case_tasks_dim;][length = 29]
[ODBC][25230][1503061950.374116][SQLPrepare.c][371]
Exit:[SQL_SUCCESS]
[ODBC][25230][1503061950.374155][SQLExecute.c][187]
Entry:
Statement = 0x17ecfd0
[ODBC][25230][1503063865.613986][SQLExecute.c][348]
Exit:[SQL_SUCCESS]
[ODBC][25230][1503063865.614088][SQLNumResultCols.c][156]
Entry:
Statement = 0x17ecfd0
Column Count = 0x7fff8952131e
[ODBC][25230][1503063865.614118][SQLNumResultCols.c][248]
Exit:[SQL_SUCCESS]
Count = 0x7fff8952131e -> 0
[ODBC][25230][1503063865.614140][SQLRowCount.c][173]
Entry:
Statement = 0x17ecfd0
Row Count = 0x7fff895212d0
[ODBC][25230][1503063865.614161][SQLRowCount.c][244]
Exit:[SQL_SUCCESS]
Row Count = 0x7fff895212d0 -> -1
[ODBC][25230][1503063865.614195][SQLMoreResults.c][162]
Entry:
Statement = 0x17ecfd0
[ODBC][25230][1503063865.614220][SQLMoreResults.c][317]
Exit:[SQL_NO_DATA]
[ODBC][25230][1503063865.614240][SQLFreeStmt.c][144]
Entry:
Statement = 0x17ecfd0
Option = 1
[ODBC][25230][1503063865.614260][SQLFreeHandle.c][381]
Entry:
Handle Type = 3
Input Handle = 0x17ecfd0
[ODBC][25230][1503063865.614294][SQLFreeHandle.c][491]
Exit:[SQL_SUCCESS]
[ODBC][25230][1503064084.457754][SQLDisconnect.c][208]
Entry:
Connection = 0x17a2050
[ODBC][25230][1503064084.457988][SQLDisconnect.c][364]
Exit:[SQL_SUCCESS]
[ODBC][25230][1503064084.458052][SQLFreeHandle.c][284]
Entry:
Handle Type = 2
Input Handle = 0x17a2050
[ODBC][25230][1503064084.458097][SQLFreeHandle.c][333]
Exit:[SQL_SUCCESS]
[ODBC][25230][1503064084.458138][SQLFreeHandle.c][219]
Entry:
Handle Type = 1
Input Handle = 0x17a1750




Is mysql-connector-odbc-5.3.9-1.el7.x86_64 driver is certified with MySQL 5.6 database?

I appreciate any suggestions.

Best regards, Yogesh