User`s guide

2 Getting Started with Database Toolbox
2-92
3
Click the System DSN tab and then click Add. When setting up an ODBC data
source, you can use a User DSN or System DSN. A User DSN is specific to the user
on a machine. Any data sources a user defines under User DSN are seen only by that
specific user. Conversely, a System DSN is not specific to the user on a machine. Any
data sources a user defines under System DSN on a machine can be seen by any user
who logs into that machine. Your ability to set up a User DSN or System DSN might
depend on the database and ODBC driver you are using. For details, contact your
database administrator or your database ODBC driver documentation.
4
A list of installed ODBC drivers appears in the Create New Data Source dialog box.
Select the ODBC driver Adaptive Server Enterprise. Your ODBC driver might
have a different name. Click Finish.
5
In the Adaptive Server Enterprise dialog box, enter an appropriate name for your
data source in the Data Source Name field. You use this name to establish a
connection to your database. Here, enter Sybase as the data source name. Enter
a description for this data source, such as Sybase database, in the Description
field. Enter your database server name in the Server Name (ASE Host Name)
field. Enter your port number in the Server Port field. Enter your database name
in the Database Name field. Enter your user name in the Logon ID field. Leave all
other tabs with default settings.