Each SQL Server can have multiple sets of system messages, with each set in a different language (English, Spanish, French, and so on). If a data source is defined against a server that has multiple sets of system messages, you can specify which language you want to use for system messages. In the list, click the language. The Change the language of SQL Server system messages to option is unavailable if only one language is installed on the SQL Server instance.

When the Perform translation for character data check box is selected, the SQL Server ODBC driver converts ANSI strings sent between the client computer and SQL Server by using Unicode. The SQL Server ODBC driver sometimes converts between the SQL Server code page and Unicode on the client computer. This requires that the code page used by SQL Server be one of the code pages available on the client computer.

When cleared, extended characters in ANSI character strings are not translated when they are sent between the client application and the server. If the client computer is using an ANSI code page (ACP) different from the SQL Server code page, extended characters in ANSI character strings might be misinterpreted. If the client computer is using the same code page for its ACP that SQL Server is using, the extended characters are interpreted correctly.

The Use regional settings when outputting currency, numbers, dates, and times check box specifies that the driver use the regional settings of the client computer for formatting currency, numbers, dates, and times in character output strings. The driver uses the default regional setting for the login account of the user connecting through the data source. Select this option for applications that only display data, not for applications that process data.

The Save long running queries to the log file box specifies that the driver log any query that takes longer than the Long query time value. Long-running queries are logged to the specified file. To specify a log file, either type the full path and file name in the box or click Browse to select a log file by navigating through existing file directories.

The Long query time (milliseconds) box specifies a threshold value, in milliseconds, for long-running query logging. Any query that takes longer than this number of milliseconds to run is logged.

The Log ODBC driver statistics to the log file box specifies that statistics be logged. Statistics are logged to the specified file. To specify a log file, either type the full path and file name in the box or click Browse to select a log file by navigating through existing file directories.

The statistics log is a tab-delimited file that can be analyzed in Microsoft Excel or any other application that supports tab-delimited files.