Use OTL to access the database

Use OTL to access the database-take the wife to the street-C ++ blog

Use OTL to access the database

Source: http://read.newbooks.com.cn/info/157869.html

OTL introduction:
OTL Yes Oracle, ODBC and DB2-CLI template library abbreviation, is a C ++ template library for controlling relational databases during compilation. It currently supports almost all mainstream databases, example: Oracle, ms SQL Server, Sybase, Informix, MYS Ql, DB2, Interbase/Firebird, PostgreSQL, SQLite, SAP/DB, TimesTen, MS access and so on. OTL Oracle mainly uses Oracle provides the OCI API, the DB2 database is performed through the CLI interface, for MS databases and other databases, OTL only supports odbc . Of course, Oracle and DB2 can also be OTL is indirectly manipulated using odbc .

InWindows and Unix MSPlatform,OTLCurrently, the following database versions are supported:Oracle 7 (Direct useOci7), Oracle 8 (Direct useOci8), Oracle 8i (Direct useOci8i), Oracle 9i (Direct useOci9i), Oracle 10g (Direct useOci10g), DB2 (Direct useDB2 CLI, ODBC 3.x, ODBC 2.5.OTLThe latest version is4.0, SeeHttp://otl.sourceforge.net/,Http://otl.sourceforge.net/otlv4_h.zip.
Advantages:
A. Cross-platform
B. High operation efficiency, andCDirect language callAPIEquivalent
C. High development efficiency
D. Easy to deploy, no needADOComponent, not required. NET FrameworkAnd so on
  the following examples are available: 501 For more information, see http://otl.sourceforge.net/otl4_mssql_examples.htm .