Chapter 5: Installing DirectConnect
For DirectConnect for Microsoft SQL Server
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.
Creating and configuring a data source
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 (*).
Table 5-6: General parameter
required values
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 (*).
Table 5-7: 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 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.
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.
|
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.
Copyright © 2005. Sybase Inc. All rights reserved.
|
|
View this book as PDF