Chapter 4 Setting up the Database Client

Defining an ODBC Data Source

Once you have installed the database client (including an ODBC driver for Adaptive Server Anywhere), you have to create an ODBC data source to define the connection parameters between the client and the database on the server.

There are three types of ODBC data sources:

Machine data source: this data source is created on the client machine, and is available to the user currently logged onto the system. Machine data sources are stored in the part of the registry containing settings for the current user.
System data source: this data source is created on the client machine, and is available to all users regardless of whether a user is logged onto the system or not. System data sources are stored in the part of the registry containing settings for the current machine.
File data source: this data source is stored as a file. A file data source has the extension .dsn. It can be used by different users if it is placed in the default location for file data sources. File data sources are usually managed by database administrators.

You will learn to create a machine data source.

From the ODBC administrator, you will have to enter the following parameters in the ODBC configuration dialog box:

Tab	Parameter	Description
ODBC	Data Source Name	This name is used to identify the ODBC data source
	Description	Optional description of the data source
	Translator	Keep <No Translator>
Login	User ID	Name of the user ID with which you log on to the database, for Adaptive Server Anywhere the default user is DBA
	Password	Password for the connection, for Adaptive Server Anywhere the default password is SQL
	Encrypt password	You can select this box if you want to store the password in an encrypted fashion in the data source
Database	Server Name	Name of the network server
	Start Line	(only if the server is installed on the same machine as the client) enter the server that should be started. You should supply a Start Line parameter only if you are connecting to a database server that is not currently running
	Database Name	Name of the database that you have created on the network server
	Database File	Full path and name of the database file on the server. You can also click Browse to locate the file
Network	—	Check your network protocol documentation to select appropriate options
Advanced	—	Keep default parameters

To define a machine data source:

Select Start→Settings→Control Panel.

Double-click the ODBC Data Sources program icon.

The ODBC Data Source Administrator dialog box opens to the User DSN page.

Click the Add button.

Select the driver Adaptive Server Anywhere 9.0 from the list of ODBC drivers.

ODBC drivers
If you are using the Oracle DBMS, it is recommended to use the ODBC drivers delivered with PowerDesigner

Click Finish.

The ODBC Configuration for Adaptive Server Anywhere 8 box is displayed

Type the configuration parameters as explained in the above table.

Click OK in the ODBC configuration dialog box.

You return to the list of data source drivers.

Click Close.

You return to the Users DSN page, the name of the data source you have created is displayed in the list.

Click OK.