ODBTP -- Version 1.1 Changes
- Interface Files
To facilitate the process for connecting to databases,
interface file support was added.
An interface file provides the ability to connect to databases without
the use of a complex ODBC driver connect string.
- Row Cache
The data rows from a query result set can be placed into a memory cache.
This allows for the predetermination of row counts, and the use
of scrollable fetches without
the need for a cursor. It also provides the ability to maintain a result set
without being connected to the server.
- Extended Column Information
Additional column intormation can optionally be provided by the server.
This includes type, table, schema, and catalog name information.
- Stored Precedure Preparation
Special provisions for preparing stored procedures has been added.
They are designed to make it as easy as possible to process stored
procedures. Procedure parameters can be set and retrieved
without having to know their specifics.
- UNICODE Query Text Processing
The ability to execute UTF-8 encoded query text is optionally provided.
This is achieved with the use of the UNICODE versions of the Win32
ODBC API functions.
- Enhanced PHP Support
Many new functions have been added to the ODBTP PHP
extension. In addition to the new functions, is support for the
functions defined in the mssql extension. This allows existing PHP scripts
that use the mssql extension to use ODBTP without potentially any
modifications. A PEAR DB driver for ODBTP is also included for even
- Special Support for MS SQL Server
Special support for MS SQL Server database connections is provided by
utilizing MSSQL specific aspects of the ODBC driver. This includes
additional column information, and extended error reporting.
- ODBC Information Retrieval
More ODB attributes have
been added to retrieve ODBC driver information.
- Direct Access to ODBC Catalog Functions
Access to the ODBC API catalog functions is made possible with the use of
a special query text syntax. These functions include SQLGetTypeInfo,
SQLTables, SQLColumns and SQLProcedures.