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.

Installing the PSQL Client

An installation of the PSQL Client is required to establish a connection to Btrieve. Acquire the PSQL Client from the Actian download page.

• Product: Select Actian Zen (PSQL).
• Release: PSQL v12, v13, and v14 are supported.
• Platform: Select your platform.
• A dropdown menu appears. Scroll down to find the PSQL client download link.

You must install the PSQL client on the same machine as the driver.

Connecting to Btrieve

With the PSQL client installed, the driver can now connect to Btrieve.

Set the following connection properties:

• Server: The default value is localhost. If your database is not on the local machine, set the value to the hostname or IP of the remote machine.
• Database: Set to the directory containing the Btrieve database files if DatabaseLocation is empty, or the name of the database when DatabaseLocation is set to the database path.
• User: Set this to the username used to authenticate to Btrieve.
• Password: Set this to the password used to authenticate to Btrieve.