Comparing the client interfaces

Table 1-1 compares Sybase’s client interfaces:

Table 1-1: Comparing Sybase’s client interfaces

Client-Library

DB-Library

Embedded SQL

ODBC

Available Client/Server features

All

DB-Library does not support new features added to Client-Library version 11.0 and later, except for these:

  • new routine dbsetconnect that specifies server connection information

  • new environment variable SYBOCS_DB_VERSION that externally configures DB-Library version level at runtime

  • LDAP directory service support on Windows platform

All except data stream messaging and registered procedure notifications

Similar to DB-Library; different implementations may provide different feature sets, or may implement the same feature differently

Query-language independent?

Yes

No

No

No

Supports non-database development?

Yes

No

Yes

No

Interface style

Synchronous or asynchronous

Synchronous

Synchronous

Synchronous

Chief advantages

Powerful, generic, portable

Simple, portable

Simple, portable, and an international standard

Simple, widely available

Chief disadvantages

Learning curve associated with a new interface

Sybase-specific, does not support all generic client/server services

Less flexible than call-level interfaces

Lack of a single conformance test suite for all implementations results in a mixed level of function support