Setting up the DSN for the ODBC Connection on your system: In this example we are connecting to a SQL database.

1. Go to your Database connection utility. On Windows 2000 this can be found in the Control Panel < Administrative Tools < Data Sources.
   
2. Click on the System DSN connection tab.
3. Click Add. You will see the list of drivers available. (If your database driver is not listed, consult your database software and install the drivers).
4. Choose the driver you will be using. In this Example we will create an SQL Server DSN.
   
   • Give the DSN connection a name.
   • Give the DSN connection a description (optional).
   • Specify to which SQL server you will be connecting.
   • Click Next.
     
5. Set up the verification for the login permissions.
   
6. Depending on your network security policy, you can choose:
   -Windows NT authentication using the network login ID.
   -SQL Server authentication using login ID and password entered by the user. (What we will use in this example).
   
   • (Check the Client Connection, typically this will be TCP/IP).
   • Enter the login ID and password you want to use for this connection. (If using the Windows NT authentication, this option is disabled).
     
7. Choose the default database.
8. Click Next
9. Click Finish
10. A summary of the ODBC connection will appear. Click Test Data Source, you should be rewarded with a "Tests Completed Successfully!" message.

Connecting to the ODBC Connection with Campaign
In the Campaign, click on Step 1 - The Data Source Tab

1. Select ODBC connection from the Database Type drop down menu.
2. Click browse on the database source line and highlight your new DSN ODBC connection you just created. You will see a database connection string at the top of the page.
   
   • Enter your user ID and password into the string.
     If required by the ODBC Driver, you must enter the User ID (UID) and Password (PWD) here. If it is incorrect, the connection will fail. If no UID or PWD is required then do not enter any.
   • Click Select.
     
3. Select the Table/Query name.
4. Select the Email field.

You have now connected to a database using the ODBC connection.