Configuring a Datasource to Microsoft SQL Server

Use the ODBC Administrator to configure an existing datasource.

1. Click the General Parameters tab and enter values for the required parameters, indicated by an asterisk (*).

   General Parameter Required Values

   Parameter	Comments
   *Data Source Name	A string that identifies this SQL Server Wire Protocol datasource configuration in the system information. Examples include "Accounting" or "SQL Server-Serv1."
   Description	An optional long description of a datasource name. For example, "My Accounting Database" or "SQL Server on Server number 1."
   *Server Name	Name of the server that contains the database you want to access.
   Database Name	Name of the database to which you want to connect by default. If you do not specify a value, the default database defined by the SQL Server is used.

2. Click the Advanced Parameter tab and enter values for the required parameters indicated by an asterisk (*).

   Advanced Parameter Required Values

   Parameter	Comments
   Language	National language to be used by the client. The default is English.
   Application Name	Name the SQL Server uses to identify your application.
   Workstation ID	Workstation ID used by the client.
   Default Logon ID	Default login ID used to connect to your SQL Server database. This ID is case-sensitive. A login ID is required only if security is enabled on your database. Your ODBC application may override this value, or you may override this value in the Logon dialog box or connection string.
   Use Windows Authentication	Enables Windows security. When enabled, the Default Logon ID field is inactive because Windows security passes the login ID and password. Selecting this option activates the corresponding option on the Login Dialog. Sybase recommends that you do not use this Windows security parameter.
   *Enable Quoted Identifiers	Allows quoted identifiers; that is, identifiers in SQL Server that you can quote using a quoting character. By default, this option is not selected. Note: Select only if using the Adaptive Server Enterprise/Component Integration Services (ASE/CIS) client version 12.5.0.3 and later. These later versions of ASE/CIS send quoted identifiers to Microsoft SQL Server.
   Translate	Allows you to display the Select Translator dialog box, which lists the translators specified in the ODBC Translators section of the system information. DataDirect provides a translator named OEM to ANSI that translates your data from the IBM PC character set to the ANSI character set. Select a translator; then click OK to close this dialog box and perform the translation.

3. After you enter this information, click Test Connect. If the connection fails, check for accurate information.
4. If the test connection is successful, click Apply and click OK.