How to Connect using ODBC Driver
You can connect to SnappyData Cluster using SnappyData ODBC Driver and can execute SQL queries by connecting to any of the servers in the cluster.
Step 1: Install Visual C++ Redistributable for Visual Studio 2013
To download and install the Visual C++ Redistributable for Visual Studio 2013:
Select Run to start the installation and follow the steps to complete the installation.
Step 2: Install SnappyData ODBC Driver
To download and install the ODBC driver:
Download the SnappyData 220.127.116.11 Enterprise Version by registering on the SnappyData website. The downloaded file contains the SnappyData ODBC driver installers.
Depending on your Windows installation, extract the contents of the 32-bit or 64-bit version of the SnappyData ODBC Driver.
Version ODBC Driver 32-bit for 32-bit platform snappydata-1.0.2-odbc32.zip 32-bit for 64-bit platform snappydata-1.0.2-odbc32_64.zip 64-bit for 64-bit platform snappydata-1.0.2-odbc64.zip
Double-click on the SnappyDataODBCDriverInstaller.msi file, and follow the steps to complete the installation.
Connect to the SnappyData Cluster
Once you have installed the SnappyData ODBC Driver, you can connect to SnappyData cluster in any of the following ways:
Use the SnappyData Driver Connection URL:
Driver=SnappyData ODBC Driver;server=<ServerHost>;port=<ServerPort>;user=<userName>;password=<password>
Create a SnappyData DSN (Data Source Name) using the installed SnappyData ODBC Driver. Refer to the Windows documentation relevant to your operating system for more information on creating a DSN. When prompted, select the SnappyData ODBC Driver from the list of drivers and enter a Data Source name, SnappyData Server Host, Port, User Name and Password. Refer to the documentation for detailed information on Setting Up SnappyData ODBC Driver.