Home Page
Server Configuration
Client Library
PHP Extension
SF Project Page
Get ODBTP - Open Database Transport Protocol at SourceForge.net. Fast, secure and Free Open Source software downloads
     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 more flexibility.
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.