Host CCSID and Data Source

The Host CCSID registry setting at the Data Source level should be configured using the SNA OLE DB Management Console (MMC) snap-in. The SNA OLE DB MMC snap-in is designed to run on Microsoft® Windows® 95 and Microsoft® Windows NT®. On Windows NT, the snap-in respects the Windows NT security hierarchy, where only privileged users can read and write to some areas of the system registry. To prevent general users from modifying the data sources and HCD files on Windows NT, the SNA OLE DB Management snap-in can only be run by users that have administrative privileges on the local computer.

Valid values for the Host CCSID registry setting are any CCSID including 65535. If the Host CCSID attribute is set to 65535, then no character conversion will occur (the data will be treated as binary). If the Host CCSID registry setting at the Data Source level does not exist, then the value for Host CCSID defaults to the value at the SNA OLE DB Provider level.