The Microsoft® OLE DB Provider for AS/400 and VSAM uses a number of registry settings for configuration and proper operation. The configuration registry settings are located under the HKEY_LOCAL_MACHINE\Software\Microsoft\SNA OLE DB key. These registry settings include the following subkeys:
| Subkey | Comment |
|---|---|
| BinAsChar | Registry key that indicates whether to process binary fields as character fields (default is 0, don't process binary fields as character fields). |
| CLIENT | Stores the path to the directory where the DDMAPI.DLL and other OLE DB Provider for AS/400 and VSAM DLLs are located and the default code page to use on the PC. |
| CodePage | Stores the path to the directory where the EBCDIC-to-ASCII character set tables are located. |
| Data Sources | Stores information used by the OLE DB Provider for AS/400 and VSAM to enumerate data sources on different hosts. |
| DDM Server | Stores the path to the directory where the DDMSERV.EXE is located. |
| Locale | Lists the conversions supported by the PC and the hosts. |
| Trace | Indicates whether internal tracing is to be enabled for the OLE DB Provider. |
| TraceFile | This parameter is only valid if internal tracing is enabled. When configuring for tracing, the TraceFile registry setting indicates the name and path for the OLE DB trace file stored on the PC. The default value for this parameter is C:\SNA\Traces\snaoledb.trc. |
Under the Data Sources subkey are subkeys for each host using the host name as the subkey. The registry settings for these parameters are normally configured using the Microsoft Management Console snap-in application
The registry keys and values under these host subkeys are as follows:
| Key | Data value |
|---|---|
| CCSID | The CCSID on the host (default is 37, U.S. English). |
| CodePage | The code page to use on the PC (default is 437, US ASCII). This value is only used when the SNA client is configured for custom code page conversion. |
| HostEnv | Indicates whether the data resides on an AS/400 or a mainframe system. |
| Library | The default AS/400 library to be accessed. This parameter is not required for mainframe access and is optional when connecting to AS/400 files. |
| LocalLU | The name of the local LU alias configured in the SNA server. |
| LocalFilePath | The path where the DDM host column description (HCD) files are stored on the PC. |
| Mode | The APPC mode (must be set to a value that matches the host configuration and SNA server configuration). Legal values for the APPC mode include QPCSUPP (5250), #INTER (interactive), #INTERSC (interactive), #BATCH (batch), #BATCHSC (batch), and custom modes. The following modes that support bidirectional LZ89 compression are also legal: #INTERC (interactive), INTERCS (interactive), BATCHC (batch), and BATCHCS (batch). |
| Rdb | The Remote DataBase Name for OS/400. This value is only used when the database name is different from the remote LU alias configured in the SNA server. |
| RemoteLU | The name of the remote LU alias configured in the SNA server. |
| UseLocalFile | An integer value that determines if DDM host column description files (HCD files) are to be used when communicating with an AS/400. If this value is 1, then local HCD files will be used rather than interrogating the host system. |
Note that the SNA OLE DB Management Console snap-in should be used for configuring these registry settings.