Populating CA CMDB › Create a Data Source Name

Create a Data Source Name

You can create a Database Source Name (DSN) that contains the information about a specific database for the ODBC driver to use the ADT Generic ODBC data source.

To create a database source name

1. Select Settings, Control Panel, Administrative Tools, ODBC Data Sources from the Start menu.

   The ODBC Data Source Administrator dialog appears.

2. Click Add, and select the driver that supports the source of your data on the System DSN tab.
3. Click Finish.

   A dialog appears that lets you specify a data source name and other setup information. The dialog appearance depends on the driver you selected.

4. Complete the fields as appropriate for your driver and click OK.
5. For a SQL Server 2005 database, select the SQL Native Client, and click Finish.
6. Continue following the on-screen instructions.
7. Verify that Perform Translation for Character Data is selected and click Finish.

   Note: Typically, no changes are necessary on this dialog.

8. Click Test Data Source to test the database connectivity.

   When the test has completed successfully, click OK.

   The data source name is created.