Chapter 5 Setting up the Repository on any DBMS

Creating an ODBC data source

The ODBC data source defines the connection parameters between the PowerDesigner client and the database on the server where the PowerDesigner repository will reside.

There are different types of ODBC data sources: a user data source is saved in a Current User registry key whereas a system data source is saved in a Local Machine registry key.

To define a user data source:

1. Select Start→Settings→Control Panel→Administrative Tools→Data Sources (ODBC).
   
   The ODBC Data Source Administrator dialog box opens to the User DSN page.
2. Click the Add button.
3. Select the driver corresponding to your DBMS.
   
4. Click Finish.
   
   The configuration box is displayed. Most of the time, you will have to declare the data source name together with the name of the server where the database is installed.
   
   You may also be prompted to type the name of the user that will connect to the database and a password. See section Creating a repository definition for more information on connection parameters.
5. Test connection if applicable and save new DSN by clicking OK.
   
   You return to the Users DSN page, the name of the data source you have created is displayed in the list.
6. Click OK.

Copyright (C) 2006. Sybase Inc. All rights reserved.