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 WordPress

Note: For now, only connecting to self hosted wordpress instances is supported by CData ODBC Driver for WordPress.

To connect to data, set the Url and provide authentication. You must set the URL to your wordpress site, otherwise an error will be thrown indicating that the site was not found.
For example, if your site is hosted in 'http://localhost/wp/wordpress', the URL should be 'http://localhost/wp/wordpress' and not 'htpp://localhost' .

Authenticating to WordPress

WordPress uses Basic or OAuth2.0 authentication.

Basic

Basic authentication is recommended for a testing environment only.

Configure Access to WordPress

1. Go to your WordPress host and login with your admin credentials when prompted.
2. Make sure your WordPress supports the REST API. Wordpress 4.7 and later support it natively, earlier versions will need to install the REST API plugin.
3. Install an authentication plugin such as Basic Authentication to secure access to the REST API.

4. To create custom taxonomies, you need to install the Simple Taxonomy Refreshed
   

   Alternatively, to install the plugins manually, extract the compressed folders to the wp-content\plugins folder and then enable the plugins via the WordPress admin interface.

After setting the following connection properties, you are ready to connect:

• AuthScheme Set this to Basic.
• Url: Set this to your WordPress URL.
• User: Set this to your username.
• Password: Set this to your password.

OAuth 2.0

You can use OAuth to authenticate with WordPress.OAuth requires the authenticating user to interact with WordPress using the browser. Set AuthScheme to OAuth while using OAuth Authentication.