Encoding: Preventing message corruption

SQL Remote encodes messages to ensure that they pass through message systems uncorrupted. The default message-encoding behavior of SQL Remote is as follows:

  • If the message system can use binary message formats, the messages are not encoded.

  • If the message system, for example SMTP, requires text-based message formats, then an encoding DLL (dbencod12.dll) translates the messages into a text format before sending. The message format is unencoded at the receiving end using the same DLL.

    You can customize the encoding scheme to provide extra features. See Creating custom encoding schemes.

  • If the compression database option is set to -1, then a version 5 compatible encoding is used for all message systems. See Upgrading SQL Remote.


Creating custom encoding schemes