Contents Index Features not supported for remote data Connectivity problems

ASA SQL User's Guide
  Accessing Remote Data
    Troubleshooting remote data access

Case sensitivity


The case sensitivity setting of your Adaptive Server Anywhere database should match the settings used by any remote servers accessed.

Adaptive Server Anywhere databases are created case insensitive by default. With this configuration, unpredictable results may occur when selecting from a case sensitive database. Different results will occur depending on whether ORDER BY or string comparisons are pushed off to a remote server or evaluated by the local Adaptive Server Anywhere.


Contents Index Features not supported for remote data Connectivity problems