Create a Data Source Name

The ITP/MDK Repository Server uses ODBC to connect to its database. Therefore an ODBC Data Source has to be created to access the ITP/MDK Repository database. If you choose to install Microsoft SQL Server Express 2005 a Data Source will be created automatically. Otherwise:

1. Use the Microsoft Windows Start menu to go to the Control Panel.
2. Open the Data Sources Administrator window.
3. Select the System DSN tab.
4. Click the button Add. The Create New Data Source wizard starts.
5. Select the driver you want to use in the first screen of the wizard. This choice is database specific.
6. Select your driver of choice by clicking on it.
7. Click Finish.
   

   What happens next is database (driver) specific, but in all cases you will be asked for a name and a description for the Data Source Name and for the location of the database you just created. The name you enter is important because you need it later to configure the ITP/MDK Repository.
   

8. Fill out the fields in the next screen(s).

   Note

   if you are using SQLServer please do not use Master as the default database; you must select a database created especially for the ITP/MDK Repository as the default database.

9. Click Finish on the last screen.

You have now created a Data Source Name. With the database created and the Data Source Name made, you can now install the server part of the ITP/MDK Repository first followed by any clients.

Note

When installing the ITP/MDK Repository Server on a 64bit operating system, you need to create a DSN using the 32bit version of the 'Data Sources (ODBC) properties' program, located in the folder C:\Windows\SysWOW64\odbcad32.exe
If you create a DSN using the default program, which uses the executable from the system32 folder, the ITP/MDK Repository Server installation will not be able to use the DSN.

Note

When configuring an iSeries database, refer to the configuration tip in DB2 UDB for iSeries.