Various SQL Server settings.

Create a New Data Source to SQL Server

IT! Change the language of SQL Server system messages to:




IT1 Use strong encryption for data

[vl Perform translation for character data

i Use regional settings when outputting currency, numbers, dates and u times.

P Save long running queries to the log file:

|J:\Users\HELENF~1\AppData\Local\Temp\QUER | | Browse-

Long query time (milliseconds): J0000

1 Log 0 D BC driver statistics to the log file:

|J:\Usere\HELENF~1\AppData\Local\Temp\STATi| [ Browse..

< Back || Finish ] Cancel | | Help

11. Click Finish to get a screen listing the ODBC data source configuration; click Test Data Source to test the connection to the database (see Figure 18.59).

0 0

Post a comment