To create a new ODBC data source, use the Windows ODBC Data Source Administrator dialog. You can bring up this dialog by:

<

> <
• >If you use Windows 7 64-Bit, open the Start menu and in the search bar type: ODBC 32 Then run the "ODBC 32-Bit" application.

  <

• >If you use Windows 7 32-Bit, open the Start menu and in the search bar type: ODBC Then run the "Data Sources (ODBC)" application.

  <

• >If you use Windows XP, click the Start button in your Windows Taskbar and choose Control Panel. Double-click "Administrative Tools" within the Control Panel and then double-click "Data Sources (ODBC)." For Windows 2000, click the Start button in your Windows Taskbar, choose Settings, and then choose Control Panel. Double-click "Administrative Tools" within the Control Panel and then double-click "Data Sources (ODBC)." For earlier versions (such as Windows 98), click the Start button in your Windows Taskbar, choose Settings, and then choose Control Panel. Double-click "ODBC Data Sources (32-bit)." <

>

The ODBC Data Source Administrator dialog appears similar to the following.

<>

To create a new data source, do the following steps:

<>Step 1<>. In either the User DSN or System DSN pages, click the Add button. The Create New Data Source dialog appears, looking something like the following. Select the appropriate driver, and click the Finish button.

<>

What happens next depends on the driver you selected. The rest of these steps assume you are using the SQL Server driver. Please see your system administrator for assistance with other drivers.

<>Step 2<>. The setup dialog appears. Type something descriptive for the Name (such as "My Database") and Description, then choose the server from the drop-down list.

<>

<>Step 3<>. Click the Next button to go to the next page of the dialog. Check with your system administrator to see what settings to use in this page; you can leave the choices set at their default values if you aren't sure what settings to use.

<>Step 4<>. Click the Next button to go to the next page of the dialog. In the "Change the default database to" setting, select the database you want to query on from the list (you may have to ask your system administrator for the name of the database). You can leave the rest of the settings at their default values.

<>

<>Step 5<>. Click the Next button to go to the next page of the dialog. Check with your system administrator to see what settings to use in this page; you can leave the choices set at their default values if you aren't sure what settings to use.

<>Step 6<>. Click the Finish button to finish the setup. You then see a dialog that looks something like the following. Click the Test Data Source button to ensure everything works, then click the OK button.

<>