# Older OTL releases

- Oracle call interface Template Library (OTL), Version 1.0
  This is the first implementation of the OTL technology. It works with the Oracle Call Interface 7.x series. Besides the C++ library, the page contains Pro*OTL / Pre-Pro*C preprocessor 1.0 which generates OTL or Pro*C compatible code. This version of the OTL was released in late 1996.
- Oracle Call Interface Template Library (OTL), Version 2.0
  This is the second implementation of the OTL technology. There are, in fact, two OTL libraries: the OTL for the Oracle Call Interface 7.x (OCI7) and the OTL for the Oracle Call Interface 8.x (OCI8). OTL 1.0 was enhanced and the same framework was migrated to the OCI8. This version of the OTL was released in the fall of 1998.
- Odbc Template Library (OTL), Version 2.1
This is the implementation of the OTL technology for the ODBC API. It works with ODBC drivers which are compliant with the ODBC specification 2.5 or higher. Basically, OTL 2.0 for OCI was migrated to ODBC and then tested with as many ODBC drivers as it was possible at the time.
Here is the list of the database backends and ODBC drivers the OTL for ODBC was tested with:

- Oracle 8.0.3 with the Oracle ODBC driver for Oracle 8.0.3
- Oracle 8.0.4 with the Oracle ODBC driver for Oracle 8.0.4
- Oracle 8.0.5 with the Oracle ODBC driver for Oracle 8.0.5
- MS SQL Server 6.5 with the ODBC driver for MS SQL Server 6.5
- MS SQL Server 7.0 with the ODBC driver for MS SQL Server 7.0
- IBM DB2 5.2 with the ODBC driver for DB2 5.2
- SQL Anywhere 6.x (Sybase 11.x series) with the ODBC driver for SQL Anywhere 6.x

All of these ODBC drivers support bulk operations in SELECT, INSERT, UPDATE and DELETE statements. Due to that fact, the OTL for ODBC is very similar to the OTL for OCI7/OCI8 by performance, maybe with 3-5% degradation.

This version of the OTL for ODBC was released in early 1999.

Go Home

Copyright © 1996, 2007, Sergei Kuchin, email: skuchin@ispwest.com, skuchin@yahogmail
.

Permission to use, copy, modify and redistribute this document for any purpose is hereby granted without fee, provided that the above copyright notice appear in all copies.