Data values returned from the target DBMS to a client application are converted into a format that Open Client and Open Server can handle. This conversion can encounter inconsistencies, particularly in supported ranges. The access service must convert the value from the target into a matching Open Client and Open Server datatype before it sends the value back to the client.
To do this, the access service uses configuration properties. Each target datatype has a default Open Client and Open Server mapping, but these may be overridden either by the configuration property (thus affecting the entire service) or through a set statement (thus affecting only the client connection).
For more information on configuration values that affect data conversion, see “Data Conversion Error properties”.
