This document is intended for application developers who need access to data from Adaptive Server® Enterprise (ASE) on Windows, Linux and Mac OS X 10.3 platforms, using the Open Database Connectivity (ODBC).
The information in this book is organized as follows:
For information on installing the Software Developer’s Kit, see the Software Developer’s Kit and Open Server 12.5.1 Installation Guide.
For information on known problems and recent updates, see the Software Developer’s Kit and Open Server 12.5.1 Release Bulletin.
For information on installing the Adaptive Server Enterprise on Windows, see the Adaptive Server Enterprise 12.5.1 for Windows Installation Guide.
For information on installing the Adaptive Server Enterprise on Linux, see the Adaptive Server Enterprise 12.5.1 for Linux Installation Guide.
For information on installing the Adaptive Server Enterprise on Mac OS X 10.3, see the Adaptive Server Enterprise 12.5.1 for Mac OS X 10.3 Quick Installation Guide.
For information on known problems and recent updates to Adaptive Server Enterprise on Windows, see the Adaptive Server Enterprise 12.5.2 for Windows Release Bulletin.
For information on known problems and recent updates to Adaptive Server Enterprise on Linux, see the Adaptive Server Enterprise 12.5.2 for Linux Release Bulletin.
For information on known problems and recent updates to Adaptive Server Enterprise on Mac OS X 10.3, see the Adaptive Server Enterprise Version 12.5.2 for Mac OS X Release Bulletin.
Use the Sybase® Getting Started CD, the Sybase Technical Library CD, and the Technical Library Product Manuals Web site to learn more about your product:
The Getting Started CD contains release bulletins and installation guides in PDF format, and might also contain other documents or updated information not included on the Technical Library CD. It is included with your software. To read or print documents on the Getting Started CD, you need Adobe Acrobat Reader (downloadable at no charge from the Adobe Web site, using a link provided on the CD).
The Technical Library CD contains product manuals and is included with your software. The DynaText reader (included on the Technical Library CD) allows you to access technical information about your product in an easy-to-use format.
Refer to the Technical Library Installation Guide in your documentation package for instructions on installing and starting the Technical Library.
The Technical Library Product Manuals Web site is an HTML version of the Technical Library CD that you can access using a standard Web browser. In addition to product manuals, you will find links to EBFs/Updates, Technical Documents, Case Management, Solved Cases, newsgroups, and the Sybase Developer Network.
To access the Technical Library Product Manuals Web site, go to Product Manuals.
Technical documentation at the Sybase Web site is updated frequently.
To find the latest information on product certifications
Point your Web browser to Technical Documents.
Select Products from the navigation bar on the left.
Select a product name from the product list and click Go.
Select the Certification Report filter, specify a time frame, and click Go.
Click a Certification Report title to display the report.
To create a personalized view of the Sybase Web
site (including support pages)
Set up a MySybase profile. MySybase is a free service that allows you to create a personalized view of Sybase Web pages.
Point your Web browser to Technical Documents.
Click MySybase and create a MySybase profile.
To find the latest information on EBFs and software
maintenance
Point your Web browser to the Sybase Support Page.
Select EBFs/Maintenance. Enter user name and password information, if prompted (for existing Web accounts) or create a new account (a free service).
Select a product.
Specify a time frame and click Go.
Click the Info icon to display the EBF/Maintenance report, or click the product description to download the software.
The following conventions are used in this book.
Functions, command names, command option names, program names, program flags, properties, keywords, statements, and stored procedures are printed as follows:
You use the SQLSetConnectAttr function to control details of the connection. For example, the following statement turns off ODBC autocommit behavior.
Variables, parameters, and user-supplied words are in italics in syntax and in paragraph text, are printed as follows:
For example, the following statement allocates a SQL_HANDLE_STMT handle
the with name stmt,
on a connection with a handle named dbc.
Names of database objects such as databases, tables, columns, and datatypes, are printed as follows:
The value of the pubs2 object.
Examples that show the use of functions are printed as follows:
retcode = SQLConnect( dbc, (SQLCHAR*) "MANGO", SQL_NTS, (SQLCHAR* ) "sa", SQL_NTS, (SQLCHAR*) "", SQL_NTS );
Syntax formatting conventions are summarized in the following table.
Key |
Definition |
|---|---|
{ }
|
Curly braces mean you must choose at least one of the enclosed options. Do not include braces in the command. |
[ ]
|
Brackets mean you can choose or omit enclosed options. Do not include brackets in the command. |
|
|
Vertical bars mean you can choose no more than one option (enclosed in braces or brackets). |
,
|
Commas mean you can choose as many options as you need (enclosed in braces or brackets). Separate your choices with commas, to be typed as part of the command. Commas can also be required in other syntax contexts. |
( )
|
Parentheses are to be typed as part of the command. |
... |
An ellipsis (three dots) means you can repeat the last unit as many times as you need. Do not include ellipses in the command. |
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 manuals or online help, please have the designated person contact Sybase Technical Support or the Sybase subsidiary in your area.
