Adaptive Server Features Supported
Review the advanced Adaptive Server features that you can use with the Adaptive Server
ODBC Driver.
- Microsecond Granularity for Time Data
Adaptive Server ODBC Driver provides microsecond-level precision for time data by supporting the SQL datatypes bigdatetime and bigtime.
- Asynchronous Execution for ODBC
By default, drivers execute ODBC functions synchronously. That is, the application calls a function and the driver returns control to the application when execution is complete.
- Adaptive Server Cluster Edition Features Supported
Learn about the Adaptive Server ODBC Driver features that support the Cluster Edition, where multiple Adaptive Servers connect to a shared set of disks and a high-speed private interconnection.
- Distributed Transactions
Use Adaptive Server ODBC Driver to participate in two-phase commit transactions.
- Directory Services
Directory services allow the Adaptive Server ODBC Driver to get connection and other information from a central LDAP server; then, it uses this information to connect to an Adaptive Server. It uses a property called Directory Service URL (DSURL), that indicates which LDAP server to use.
- Bookmark and Bulk Support
Sybase supports bookmarks and SQL bulk operations for the ODBC Driver.
- Bulk-Load Support
The Adaptive Server ODBC Driver supports bulk-load interface for fast insertions of large sets of rows to Adaptive Server.
- Support for data-at-exec in Adaptive Server ODBC Driver
In Adaptive Server ODBC Driver version 15.7 ESD #7, the data-at-exec feature has been enhanced to support bulk and batch operations resulting in lower memory utilization.
- Support for Mainframe Connect and DirectConnect for z/OS Option
Adaptive Server ODBC Driver by Sybase supports Mainframe Connect DirectConnect™ for z/OS Option through the ServiceName and BackEndType configuration properties.
- DSN Migration Tool
The ODBC DSN Migration tool can help you migrate from the Data Direct ODBC driver to the Adaptive Server ODBC Driver by Sybase.
- Password Encryption
By default, the Adaptive Server ODBC Driver sends plain-text passwords over the network to Adaptive Server for authentication.
- Password Expiration Handling
Every company has a specific set of password policies for its database system. Depending on the policies, the password expires at a specific date and time.
- SSL Overview
Secure Sockets Layer (SSL) is an industry standard for sending wire- or socket-level encrypted data over client-to-server and server-to-server connections.
- Failover in High Availability Systems
A high availability cluster includes two or more machines that are configured so that if one machine (or application) is interrupted, the second machine assumes the workload of both machines.
- Kerberos Authentication
Kerberos is an industry standard network authentication system that provides simple login authentication as well as mutual login authentication.
- Logging Without ODBC Driver Manager Tracing
Log calls to ODBC APIs without using ODBC Driver Manager tracing in the Adaptive Server ODBC Driver.
- TDS Protocol Capture
The ProtocolCapture connection string captures Tabular Data Stream™ (TDS) packets exchanged between an ODBC application and the server for debugging purposes.
- ODBC Data Batching Without Binding Parameter Arrays
When the same SQL statement is executed for different parameter values, client applications normally bind parameter arrays and execute each set of parameters using SQLExecute, SQLExecuteDirect, and SQLBulkOperations.
- ODBC Deferred Array Binding
Adaptive Server Enterprise ODBC Driver provides the extended SQLBindColumnDA() and SQLBindParameterDA() APIs that allow applications to bind all columns or parameters with a single API call.
- Suppressing Additional Row Format Information
Use the SuppressRowFormat2 connection string property to force Adaptive Server to send data using the TDS_ROWFMT byte sequence where possible instead of the TDS_ROWFMT2 byte sequence.
- Suppressing Row Format Metadata
Improve the performance of repeatedly executed queries with the Adaptive Server ODBC driver by instructing Adaptive Server to suppress row format metadata (TDS_ROWFMT or TDS_ROWFMT2) for queries that are re-executed in a session. Adaptive Server 15.7 ESD#1 and later supports row format metadata suppression.
- Suppressing Parameter Format Metadata
Improve the performance of prepared statements with the ODBC driver by suppressing parameter format metadata when the prepared statements are re-executed.
- Releasing Locks at Cursor Close
Include the release_locks_on_close option in the declare cursor syntax , which releases shared cursor locks at isolation levels 2 and 3 when a cursor is closed. Adaptive Server ODBC Driver accordingly supports the release-lock-on-close semantics.
- select for update Support
Adaptive Server supports select for update, which can lock rows for subsequent updates within the same transaction, and supports exclusive locks for updatable cursors.
- Variable-Length Rows in Data-Only Locked Tables
Versions of Adaptive Server earlier than 15.7 configured for 16K logical page sizes could not create data-only locked (DOL) tables with variable-length rows if a variable-length column began more than 8191 bytes after the start of the row.
- Nonmaterialized Columns
The bulk insert routines in the Adaptive Server ODBC Driver version 15.7 and later can handle nonmaterialized columns in Adaptive Server 15.7.
- Large Object (LOB) Support
Adaptive Server ODBC Driver supports Large Object (LOB) datatypes.
- Large Object (LOB) Locator Support
Adaptive Server ODBC Driver supports large object (LOB) locators. A LOB locator contains a logical pointer to LOB data rather than the data itself, reducing the amount of data that passes through the network between Adaptive Server and its clients.
- Server-Specified Packet Size
Clients and servers have to be prepared to reserve memory to store the packages used for communication between them.
Created June 6, 2013. Send feedback on this help topic to Technical Publications:
pubs@sybase.com