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).
Be sure you are running the latest ASE/CIS
update (ESD) for your platform.
To set up ECDA Option for ODBC for use with ASE/CIS
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)
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).
