How to Create DSN

1- Open Windows’ ODBC Data Source Administrator as follows:

In Windows 95, 98, or NT, choose Start > Settings > Control Panel, then double-click the ODBC Data
Sources icon. Depending on your system, the icon could also be called ODBC or 32bit ODBC. in Windows 2000, choose Start > Settings > Control Panel > Administrative Tools > Data Sources.

In Windows XP, choose Start > Control Panel > Performance and Maintenance > Administrative Tools >
Data Sources (ODBC).

2 - Click the System DSN tab.

The tab displays the list of DSNs currently on your system.

3- Click Add to add a new DSN to the list.

The Create New Data Source dialog box appears, listing all the drivers currently loaded on your system.

4- Select a driver from the list, then click Finish

Example:

If your database is a Microsoft Access file, select Microsoft Access Driver (*.mdb). If a driver for your product does not appear in the list, you’ll have to download the driver from a vendor’s website and install it.

In the dialog box that appears, enter a name for the DSN and specify the connection parameters.

The dialog boxes for specifying parameters differ depending on the driver you selected. For the Microsoft Access Driver, you enter a name, click Select, locate the database file on the hard disk, and click OK.

Click OK to close the dialog box.

The new DSN is added to your list of system DSNs.