About this book

This book describes how to install Sybase® Enterprise Connect™ Data Access (ECDA) Options on the following platforms:

Audience

This book is for System Administrators or other qualified persons familiar with their system environment, resources, and devices.

How to use this book

See these chapters for information about installing, setting up connectivity, and configuring the ECDA Options.

See

To

Chapter 1, “Understanding Enterprise Connect Data Access”

Understand ECDA Option for ODBC, ECDA Option for Oracle, and DirectConnect™ Manager.

Chapter 2, “Preparing to Install”

Identify the tasks required to get ready for installing ECDA.

Chapter 3, “Installing ECDA”

Install and uninstall ECDA Option for ODBC, ECDA Option for Oracle, and DirectConnect Manager.

Chapter 4, “Creating DirectConnect Servers Using the Create Server Wizard.”

Create and start a DirectConnect server using a GUI.

Chapter 5, “Managing DirectConnect Servers and Services Using ECDA Utilities”

Create, start, and stop a server, and to create, start, and stop a service.

Chapter 6, “Managing DirectConnect Servers and Services Using DirectConnect Manager”

Create and start a server, and create and start an access service.

Chapter 7, “Managing Servers Using ECDA Option for ODBC Utilities”

Create and start a DCDirector server and a DirectConnect server using ECDA Option for ODBC utilities.

Chapter 8, “Configuring ECDA”

Configure client connectivity and to configure the DirectConnect server and access services.

Chapter 9, “Setting Up the ODBC Back-end Driver and Driver Manager”

Set up the ODBC driver manager.

Chapter 10, “Troubleshooting Installation”

Identify and resolve problems that can occur when you install an ECDA product.

Appendix A, “Connectivity Tasks for AS/400”

Set up the AS/400 to communicate with ECDA products.

Appendix B, “Installation Worksheets”

Access worksheets and instructions for recording installation information for ECDA products.

Appendix C, “Configuring Data Sources to Connect to Targets Using DataDirect”

Configure data sources for various targets.

Glossary

Find definitions of technical terms used in this guide.

Related documents

For more information about configuring and administering ECDA, use these guides:

For ODBC information, use Microsoft ODBC 3.5 Programmer’s Reference and SDK Guide

For additional references, use these documents:

To administer the ECDA DirectConnect server using DirectConnect Manager, use the DirectConnect Manager online help.

Other sources of information

Use the Sybase Getting Started CD, the SyBooks™ CD, and the Sybase Product Manuals Web site to learn more about your product:

Sybase certifications on the Web

Technical documentation at the Sybase Web site is updated frequently.

StepsFinding the latest information on product certifications

  1. Point your Web browser to Technical Documents.

  2. Click Certification Report.

  3. In the Certification Report filter select a product, platform, and time frame and then click Go.

  4. Click a Certification Report title to display the report.

StepsFinding the latest information on component certifications

  1. Point your Web browser to Availability and Certification Reports.

  2. Either select the product family and product under Search by Base Product, or select the platform and product under Search by Platform.

  3. Select Search to display the availability and certification report for the selection.

StepsCreating 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.

  1. Point your Web browser to Technical Documents.

  2. Click MySybase and create a MySybase profile.

Sybase EBFs and software maintenance

StepsFinding the latest information on EBFs and software maintenance

  1. Point your Web browser to the Sybase Support Page.

  2. Select EBFs/Maintenance. If prompted, enter your MySybase user name and password.

  3. Select a product.

  4. Specify a time frame and click Go. A list of EBF/Maintenance releases is displayed.

    Padlock icons indicate that you do not have download authorization for certain EBF/Maintenance releases because you are not registered as a Technical Support Contact. If you have not registered, but have valid information provided by your Sybase representative or through your support contract, click Edit Roles to add the “Technical Support Contact” role to your MySybase profile.

  5. Click the Info icon to display the EBF/Maintenance report, or click the product description to download the software.

Syntax conventions

Syntax statements that display options for a command look like this:

COMMAND [object_name, [ {TRUE | FALSE} ] ]

Table 1 explains the syntax conventions used in this guide.

Table 1: Syntax conventions

Symbol

Convention

( )

Include parentheses as part of the command.

{ }

Braces indicate that you must choose at least one of the enclosed options. Do not type the braces when you type the option.

[ ]

Brackets indicate that you can choose one or more of the enclosed options, or none. Do not type the brackets when you type the options.

|

The vertical bar indicates that you can select only one of the options shown. Do not type the bar in your command.

,

The comma indicates that you can choose one or more of the options shown. Separate each choice by using a comma as part of the command.

Style conventions

Table 2 explains the style conventions used in this guide.

Table 2: Style conventions

This type of information

Looks like this

Gateway-Library function names

TDINIT, TDCANCEL

Client-Library function names

CTBINIT, CTBCANCEL

Other executables (DB-Library™ routines, SQL commands) in text

the dbrpcparam routine, a select statement

Directory names, path names, and file names

/usr/bin directory, interfaces file

Variables

n bytes

Adaptive Server® Enterprise (ASE) datatypes

datetime, float

Sample code

01 BUFFER  PIC S9(9) COMP SYNC

User input

01 BUFFER PIC X(n)

Client-Library and Gateway-Library function argument names

BUFFER, RETCODE

Names of objects stored on the mainframe

SYCTSAA5

Symbolic values used with function arguments, properties, and structure fields

CS_UNUSED, FMT_NAME, CS_SV_FATAL

Client-Library property names

CS_PASSWORD, CS_USERNAME

Client-Library and Gateway-Library datatypes

CS_CHAR_TYPE

Accessibility features

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.

Enterprise Connect Data Access and the HTML documentation have 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.

NoteYou might need to configure your accessibility tool for optimal use. Some screen readers pronounce text based on its case; for example, they pronounce ALL UPPERCASE TEXT as initials, and MixedCase Text as words. You might find it helpful to configure your tool to announce syntax conventions. Consult the documentation for your tool.

For information about how Sybase supports accessibility, see Sybase Accessibility. The Sybase Accessibility site includes links to information on Section 508 and W3C standards.

See Section 508 compliance statement for DirectConnect Manager for Voluntary Product Assessment Templates.

If you need help

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.