Setting DB-Library Preferences

For Windows-NT- and Windows 95-based clients, the SQL Client Configuration Utility includes two options for setting DB-Library preferences:

• The Automatic ANSI to OEM option enables DB-Library to convert characters from OEM to ANSI when communicating with SQL Server, and from ANSI to OEM when communicating from SQL Server to the client. By default, this is set on.
• The Use International Settings option enables DB-Library to get date, time, and currency formats from the system rather than using hard-coded parameters or parameters specified in SQLCOMMN.LOC. By default, this is set on.

For Windows-based clients, the SQL Client Configuration Utility includes the Automatic ANSI to OEM option but not the Use International Settings option. By default, the setting for the Automatic ANSI to OEM option is set off.

    To set DB-Library conversion preferences on a Windows NT- or Windows 95-based client

1. Start the SQL Client Configuration Utility as described in Starting the Client Configuration Utility, earlier in this chapter.

   The SQL Client Configuration Utility appears.

   

2. Select or clear the check box for the Automatic ANSI to OEM option.
3. Select or clear the check box for the Use International Settings option.
4. Choose the Done button.

    To set DB-Library conversion preferences on a Windows-based client

1. From the SQL Server Tools program group, double-click the SQL Client Configuration Utility icon.

   

   The SQL Client Configuration Utility window appears.

   

2. Select or clear the check box for the Automatic ANSI to OEM option.
3. Choose the Done button.

For information on setting DB-Library conversion preferences on an MS-DOS-based client, see Microsoft SQL Server Programming
DB-Library for C.