We get the “"BLOCK" / "ROLLBACK" error issues when running ODBC v11 or v13 against SQL v2014. Now I find article on the “"BLOCK" / "ROLLBACK" error and it says NOT TO USE ODBC – BUT USE NATIVE CLIENT 11. 'https://support.oracle.com/epmos/faces/DocumentDisplay?%7B%7D&_afrLoop=400880239030492&parent=EXTERNAL_SEARCH&sourceId=P… Quote = "The ODBC Driver in use is not supported. OGG 12.1, 12.2, and 12.3 requires SQL Server Native Client 11.0 driver...."
OK then . What do we do about the memory leak we get when running with “SQL Server Native Client version 11”?
We get this warning in the RPT file...
WARNING OGG-05203
The SQL Server Native Client 11 driver is known to cause a memory leak when used to connect to SQL Server 2012 or later.
then, every few days, we get an "abend" because cannot connect to SQL… I can simply restart REPLICAT
ERROR OGG-00551
Database operation failed: Listing tables.
ODBC error: SQLSTATE 08S01 native database error 233.
[Microsoft][SQL Server Native Client 11.0]Shared Memory Provider: No process is on the other end of the pipe.
[Microsoft] [SQL Server Native Client 11.0]Communication link failure.