At this time, you need to install the Microsoft Data Access Component (MDAC). The MDAC contains required ODBC components, such as the ODBC driver manager and the ODBC Administrator, as well as OLE/DB, used by Microsoft SQL Server 2000.
To create a new Microsoft SQL Server data source or configure an existing data source, use the ODBC Administrator, which contains several setup boxes.
To access the Driver Setup dialog boxes
From your control panel, click on the ODBC Administrator icon to start it.
Select the System DSN (recommended) or the User DSN and do one of the following:
If you are configuring a new data source, click Add. (New DSNs are required for releases that contain driver updates.)
If you are configuring an existing data source, select the data source name and click Configure.
Select the DirectConnect SQL Server wire protocol driver.
Click Finish.
The DirectConnect SQL Server wire protocol driver provides several dialog boxes where connectivity and other options take place.
To configure a data source to the SQL Server
Click the General parameters tab and enter values for the required parameters, indicated by an asterisk (*).
Parameter |
Comments |
|---|---|
*Data Source Name |
A string that identifies this SQL Server Wire Protocol data source configuration in the system information. Examples include "Accounting" or "SQL Server-Serv1." |
Description |
An optional long description of a data source 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. |
Click the Advanced parameter tab and enter values for the required parameters indicated by an asterisk (*).
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 logon ID used to connect to your SQL Server database. This ID is case sensitive. A logon 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 logon ID and password. Selecting this check box also activates the corresponding check box on the Logon 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, the check box is not selected.
|
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. |
After you enter this information, click Test Connect. If the connection fails, check your worksheet for accurate information.
If the test connection is successful, click Apply and then click OK.
Select only if using ASE/CIS client version 12.5.0.3
and later. These later versions of ASE/CIS send quoted
identifiers to Microsoft SQL Server.