3. Define connectivity between ASE and an access service  Using ASE/CIS with the ASE transaction model

Chapter 3: Configuring Access Services to Work with Related Products

Setting up ECDA Option for ODBC for ASE/CIS

You can configure ECDA Option for ODBC so that ASE/CIS can configure it to transparently access data on a remote server (such as an access service).

NoteBe sure you are running the latest ASE/CIS update (ESD) for your platform.

StepsTo set up ECDA Option for ODBC for use with ASE/CIS

  1. Configure the following properties for ECDA Option for ODBC to a Microsoft SQL Server data source:

    • QuotedIdentifier=on

    • SqlTransformation=sybase

    • CSPColumnODBCVersion=2 (ASE/CIS version 12.0)

    • Use the default, CSPColumnODBCVersion=3 (ASE/CIS 12.5 and later)

  2. Configure the Microsoft SQL Server driver:

    • For Windows: Choose “enabled quoted identifiers” for the Microsoft SQL Server driver in the ODBC administrator.

    • For UNIX: Add the configuration property QuotedId=yes in the ODBC system information file (odbc.ini).




Copyright © 2007. Sybase Inc. All rights reserved. Using ASE/CIS with the ASE transaction model

View this document as PDF