An access service converts or performs SQL transformation on incoming Open Server data it receives in a client request when the data includes:
Data values embedded as strings within the text of select, insert, delete, update, and execute language commands
Data values as parameters of RPC, cursor, transfer, or dynamic SQL commands
Datatype names as part of create table or alter table commands
The access service does not perform automatic incoming datatype conversions on data values embedded in strings or received as parameters. Instead, the client application receives a string template from the target datatypes so that it can format the strings correctly before sending them to the target DBMS. The formatting is set up through the sp_columns catalog stored procedure.
