Installing CData Virtuality ODBC (Windows)

Installation

To install the ODBC driver on Windows, download the driver from the CData Virtuality web interface, double-click the appropriate installer file (datavirtualityODBC.msi or datavirtualityODBC_x64.msi), and follow the wizard.

Configuration

Launching the Windows Data Source Administration Tool

After installing the driver, create a DSN via the Windows ODBC Administrator Tool.

The 64-Bit ODBC Driver needs to be configured in the 64-Bit Version of the ODBC Administrator Tool. The 32-Bit ODBC Driver needs to be configured in the 32-Bit Version of the ODBC Administrator Tool.

To open the ODBC Administrator Tool in Windows, access the Windows search field, search for ODBC, and start the appropriate ODBC Administrator Tool:

Windows Start menu search results showing ODBC Data Sources (32-bit) and ODBC Data Sources (64-bit).

Verifying that the CData Virtuality ODBC Driver is Installed

Verify that the CData Virtuality ODBC Driver is correctly installed by opening the Drivers Tab in ODBC Administrator Tool:

ODBC Data Source Administrator (64-bit) showing installed drivers, including Data Virtuality ANSI (x64) and Data Virtuality Unicode (x64).

If the CData Virtuality ODBC Driver does not appear in the list, the CData Virtuality ODBC Driver installation did not finish successfully. That needs to be fixed before proceeding with the configuration.

Creating a New DSN

Open either the User DSN or System DSN tab and click the Add button.

Choose the ANSI or the Unicode version of the CData Virtuality ODBC Driver from the list of installed drivers. The ANSI driver version is faster but does not support Unicode characters.

Create New Data Source dialog showing available ODBC drivers, with DataVirtuality Unicode (x64) selected.

Provide connection parameters for the driver as follows:

Data Source, Database, Server, Port, SSL mode, and user credentials are mandatory;
Data Source is an arbitrary DSN name;
Database must be 'datavirtuality';
Server is the URL or IP address of the CData Virtuality Server instance;
Port is 35432 (no SSL) or 35433 (SSL) unless configured differently in the CData Virtuality Server;
SSL Mode should be chosen according to the configuration of the CData Virtuality Server to connect to.

DataVirtualitySQL Unicode ODBC Driver Setup dialog showing connection fields for data source name, server address, database, port, user name, and password.

Test the connection and then save the created DSN. You can now use the DSN by its name in ODBC clients connecting to the CData Virtuality Server.

Connection Test dialog in the ODBC Data Source Administrator confirming a successful connection.

System DSN list in ODBC Data Source Administrator showing a configured DataVirtualityUnicode data source.