You can configure DirectConnect to be configured by ASE/CIS to transparently access data on a remote server, such as a DirectConnect access service, by performing the following.
Be sure you are running the latest ASE/CIS
update (ESD) for your platform.
To set up DirectConnect for ASE/CIS
Configure the following properties for DirectConnect for Microsoft SQL Server:
QuotedIdentifier=on
SqlTransformation=sybase
CSPColumnODBCVersion=2 (ASE/CIS Version 12.0)
Use default, CSPColumnODBCVersion=3 (ASE/CIS 12.5 and up)
Configure the Microsoft SQL Server driver:
For Windows: Choose "enabled quoted identifiers" for Microsoft SQL Server driver in the ODBC administrator
For UNIX: Add the configuration property QuotedId=yes in the ODBC system information file (odbc.ini for UNI
