About this book

This book contains information on how to migrate Open Client™ DB-Library™ applications to Open Client Client-Library.

This book has a dual audience:

• Managers or other decision makers who will decide whether to migrate a particular DB-Library application to Client-Library.

• Experienced DB-Library programmers who will perform the migration.

This book contains these chapters:

You can see these books for more information:

• The Open Server and SDK New Features for Windows, Linux, and UNIX, which describes new features available for Open Server and the Software Developer’s Kit. This document is revised to include new features as they become available.

• The Open Server Release Bulletin for your platform contains important last-minute information about Open Server.

• The Software Developer’s Kit Release Bulletin for your platform contains important last-minute information about Open Client™ and SDK.

• The jConnect™ for JDBC™ Release Bulletin contains important last-minute information about jConnect.

• The Open Client and Open Server Configuration Guide for your platform contains information about configuring your system to run Open Client and Open Server.

• The Open Client Client-Library/C Programmers Guide contains information on how to design and implement Client-Library applications.

• The Open Client Client-Library/C Reference Manual contains reference information for Open Client Client-Library™.

• The Open Server Server-Library/C Reference Manual contains reference information for Open Server Server-Library.

• The Open Client and Open Server Common Libraries Reference Manual contains reference information for CS-Library, which is a collection of utility routines that are useful in both Client-Library and Server-Library applications.

• The Open Server DB-Library/C Reference Manual contains reference information for the C version of Open Client DB-Library™.

• The Open Client and Open Server Programmers Supplement for your platform contains platform-specific information for programmers using Open Client and Open Server. This document includes information about:

  • Compiling and linking an application

  • The sample programs that are included with Open Client and Open Server

  • Routines that have platform-specific behaviors

• The Installation and Release Bulletin Sybase® SDK DB-Library Kerberos Authentication Option contains information about installing and enabling the MIT Kerberos security mechanism to be used on DB-Library. DB-Library only supports network authentication and mutual authentication in the Kerberos security mechanism.

• The Open Client and Open Server International Developers Guide provides information about creating internationalized and localized applications.

• The Open Client Embedded SQL™/C Programmers Guide explains how to use Embedded SQL and the Embedded SQL precompiler with C applications.

• The Open Client Embedded SQL™/COBOL Programmers Guide explains how to use Embedded SQL and the Embedded SQL precompiler with COBOL applications.

• The jConnect for JDBC Programmers Reference describes the jConnect for JDBC product and explains how to access data stored in relational database management systems.

• The Adaptive Server® Enterprise ADO.NET Data Provider Users Guide provides information on how to access data in Adaptive Server using any language supported by .NET, such as C#, Visual Basic .NET, C++ with managed extension, and J#.

• The Adaptive Server Enterprise ODBC Driver by Sybase® Users Guide for Microsoft Windows and UNIX, provides information on how to access data from Adaptive Server on Microsoft Windows and UNIX platforms, using the Open Database Connectivity (ODBC) Driver.

• The Adaptive Server Enterprise OLE DB Provider by Sybase Users Guide for Microsoft Windows provides information on how to access data from Adaptive Server on Microsoft Windows platforms, using the Adaptive Server OLE DB Provider.

• The Adaptive Server Enterprise Database Driver for Perl Programmers Guide provides information for Perl developers to connect to an Adaptive Server database and query or change information using a Perl script.

• The Adaptive Server Enterprise extension module for PHP Programmers Guide provides information for PHP developers to execute queries against an Adaptive Server database.

• The Adaptive Server Enterprise extension module for Python Programmers Guide provides information about Sybase-specific Python interface that can be used to execute queries against an Adaptive Server database.

Use the Sybase Getting Started CD and the Sybase Product Documentation Web site to learn more about your product:

This book contains a number of code fragments taken from the set of migration sample programs that Sybase provides on the World Wide Web.

The example fragments in this book use the EXIT_ON_FAIL() example macro, which is as follows. Macros similar to this can simplify return code error checking. However, this macro is not appropriate for every situation.

/*
** Define a macro that exits if a function return code indicates
** failure. Accepts a CS_CONTEXT pointer, a Client-Library
** or CS-Library return code, and an error string. If the
** return code is not CS_SUCCEED, the context will be 
** cleaned up (if it is non-NULL), the error message is
** printed, and we exit to the operating system.
*/

#define EXIT_ON_FAIL(context, ret, str) { 
   if (ret != CS_SUCCEED) 
   { 
      fprintf(stderr, "Fatal error: %s\n", str); 
      if (context != (CS_CONTEXT *) NULL) { 
         (CS_VOID) ct_exit(context, CS_FORCE_EXIT); 
         (CS_VOID) cs_ctx_drop(context); 
      } \
      exit(ERROR_EXIT); 
   }
}

Technical documentation at the Sybase Web site is updated frequently.

Set up a MySybase profile. MySybase is a free service that allows you to create a personalized view of Sybase Web pages.

This document is available in an HTML version that is specialized for accessibility. You can navigate the HTML with an adaptive technology such as a screen reader, or view it with a screen enlarger.

Open Client and Open Server documentation has been tested for compliance with U.S. government Section 508 Accessibility requirements. Documents that comply with Section 508 generally also meet non-U.S. accessibility guidelines, such as the World Wide Web Consortium (W3C) guidelines for Web sites.

Each Sybase installation that has purchased a support contract has one or more designated people who are authorized to contact Sybase Technical Support. If you cannot resolve a problem using the documentation or online help, please have the designated person contact Sybase Technical Support or the Sybase subsidiary in your area.