Connections Tab, Options Dialog Box

Use the Connections tab on the Options dialog box to configure general connection settings.

Options

Login timeout (seconds)

Specify the amount of time to wait for a connection before timing out. The connection timeout applies only after Query Analyzer has searched every computer on the network for the requested server.

Network package size (bytes)

Specify the network package size.

Query timeout (seconds)

Specify the amount of time a query can process before timing out.

Lock timeout (milliseconds.)

Specify the amount of time to wait for a lock before timing out.

Batch separator

Specify the word or character that can be used to separate batches.

Parse ODBC message prefixes

Specify that ODBC prefixes should be parsed.

Perform translation for character data

Specify that translation should be performed for character data.

Use regional settings when displaying currency, number, dates and times

Specify that regional settings should be used for currency, numbers, dates, and times.

Disconnect after query executes

Specify that the connection should be dropped after the query executes.

Parse ODBC message prefixes

Specify to parse ODBC message prefixes. When this option is selected the prefix [Microsoft][ODBC SQL Server Driver][SQL Server] is removed from the ODBC error messages. If the option is OFF, the error messages are presented. The default for this setting is ON.

Note  This option works only when connected to an instance of SQL Server version 4.21a or later.

T-SQL batch separator

Specify the Transact-SQL command to separate batches. The default for this setting is GO.

Note  This option works only when connected to an instance of SQL Server 4.21a or later.

Query time-out (seconds)

Specify the number of seconds to wait for any request on the connection to complete before returning to the application. When this time is exceeded, the client prompts the user to continue waiting. The default is 0, which indicates an infinite wait or no time-out.

Note  This option works only when connected to an instance of SQL Server 4.21a or later.

Change the language of SQL Server system messages to

Specify the language to use for system messages sent from SQL Server to the client. The list presented is the actual list of possible languages present on a given server. However, the extensive list of languages is only available when connecting to a Microsoft® SQL Server™ version 7.0 or later. SQL Server version 6.5 and earlier support only English, French, German, and Japanese.

Note  This option works only when connected to an instance of SQL Server 4.21a or later.

Perform translation for character data

Specify to perform translations for character data. Turning on this setting causes the ODBC driver to translate characters between the client and server code pages as data is exchanged. The attribute only affects data stored in SQL Server char, varchar, and text columns. When the translate option is OFF, the driver does not translate characters from one code page to another in character data exchanged between the client and the server. The driver configures the character translation automatically, determining the code page installed on the server in use by the client. The default for this setting is ON.

Note  This option works only when connected to an instance of SQL Server 4.21a or later.

Use regional settings when outputting currency, number, dates, and times

Specify to use regional settings when converting numeric, date, time, and currency data to a string. Turning this setting to ON causes the ODBC driver to respect the local client setting when converting numeric, date, time, and currency values to character strings. The conversion is from SQL Server native data types to character strings only. When the setting is OFF, the driver does not convert numeric, date, time, and currency data to character string data using the client locale setting. The conversion setting is only applicable to output conversion and is only visible when currency, numeric, date, or time values are converted to character strings (which is always the case with Query Analyzer). The default for this setting is OFF.

Note  This option works only when connected to an instance of SQL Server 4.21a or later.