Setting Up ECDA Option for ODBC for Adaptive Server/CIS

Configure ECDA Option for ODBC so that Adaptive Server/CIS can configure it to transparently access data on a remote server as an access service.

Prerequisites

Verify that you are running the latest Adaptive Server/CIS update (ESD) for your platform.

Task
  1. Configure these properties for ECDA Option for ODBC to a Microsoft SQL Server datasource:
    • QuotedIdentifier= on
    • SqlTransformation= sybase
    • CSPColumnODBCVersion= 2 (Adaptive Server/CIS version 12.0)
    • Use the default, CSPColumnODBCVersion= 3 (Adaptive Server/CIS 12.5 and later)
  2. Configure the Microsoft SQL Server driver:

    • On Windows – choose “enabled quoted identifiers” for the Microsoft SQL Server driver in the ODBC administrator.

    • On UNIX – add the configuration property QuotedId= yes in the ODBC system information file (odbc.ini).