Using the Microsoft ODBC Data Source Administrator

You can use the Microsoft ODBC Data Source Administrator to edit the DSN configuration. Note that the DSN is created during the installation process.

Complete the following steps to edit the DSN configuration:

1. Select Start > Search, and enter ODBC Data Sources in the Search box.
2. Choose the version of the ODBC Administrator that corresponds to the bitness of your application (32-bit or 64-bit).
3. Click the System DSN tab.
4. Select the system data source and click Configure.
5. Edit the information on the Connection tab and click OK.

Note: For .NET Framework 4.0, the driver distributes Microsoft Visual C++ 2015-2022 Redistributable. For .NET Framework 3.5, the driver distributes Microsoft Visual C++ 2008 Redistributable.

Connecting to Mailchimp

Mailchimp supports the following authentication methods:

• APIKey
• OAuth

API Key

The easiest way to connect to Mailchimp is to use the API Key. The APIKey grants full access to your Mailchimp account. To obtain the APIKey, log into Mailchimp and click Account -> Extras -> API Keys. You can then set the connection property APIKey to this value.

• AuthScheme: Set this to APIKey.

OAuth

An alternative method to authenticate to Mailchimp is using OAuth standard. OAuth can be used to enable other users to access their own data. To authenticate using OAuth, you need to obtain the OAuthClientId, OAuthClientSecret, and CallbackURL by registering an app with Mailchimp. OAuth requires the authenticating user to interact with Mailchimp using the browser.

• AuthScheme: Set this to OAuth.