Hoping anyone have similar experience.
I have an application that uses the ODBC drivers provided by Oracle. Runs perfectly in 11g and 12c version.
Tried against a Oracle 19c (both server and client 19c version) using also Oracle ODBC 19c. ODBC logs shows errors:
ConsolidationTe 31c0-1afc EXIT SQLGetDiagRecW with return code -2 (SQL_INVALID_HANDLE) SQLSMALLINT 3 <SQL_HANDLE_STMT> SQLHANDLE 0x00000220BF093FA0 SQLSMALLINT 1 SQLWCHAR * 0x0000006122EEC240 SQLINTEGER * 0x00000220BEBE270C SQLWCHAR * 0x0000006122EEC250 SQLSMALLINT 511 SQLSMALLINT * 0x0000006122EEC1F0
and there some codes that are just plainly hanging:
AppServ 1338-b1cc ENTER SQLFetchScroll SQLHSTMT 0x01077150 SQLSMALLINT 5 <SQL_FETCH_ABSOLUTE> SQLLEN 1
Just for the sake of testing I installed on a different machine, I installed both 12c and 19c clients but using 19c server. When I switch to 12c client driver, everything works as expected but using 19c, same errors as above happened.
Need help on how can I really pinpoint that the 19c driver are the actual issue? Or i need to change something on our 10+ year old codes.
Thanks in advance!