Installing the SQream ODBC Driver

This document describes how to install the SQream ODBC driver (for 64 bit Windows).

For access to our Unix-based ODBC for CentOS 7/Ubuntu, please contact us via a support ticket.

Pre-installation steps:

  1. Before installing the ODBC driver, please install the Visual Studio redistributable packages for VS2010, VS2012 and VS2013: 
    2013
    64bit: http://download.microsoft.com/download/0/5/6/056dcda9-d667-4e27-8001-8a0c6971d6b1/vcredist_x64.exe
    32bit: http://download.microsoft.com/download/0/5/6/056dcda9-d667-4e27-8001-8a0c6971d6b1/vcredist_x86.exe
    2012
    64bit: https://download.microsoft.com/download/1/6/B/16B06F60-3B20-4FF2-B699-5E9B7962F9AE/VSU_4/vcredist_x64.exe
    32bit: https://download.microsoft.com/download/1/6/B/16B06F60-3B20-4FF2-B699-5E9B7962F9AE/VSU_4/vcredist_x86.exe
    2010
    64bit: https://download.microsoft.com/download/3/2/2/3224B87F-CFA0-4E70-BDA3-3DE650EFEBA5/vcredist_x64.exe
    32bit: https://download.microsoft.com/download/5/B/C/5BC5DBB3-652D-4DCE-B14A-475AB85EEF6E/vcredist_x86.exe
  2. After installing the Visual Studio Redistributables - download the SQream driver package from the link below
    http://www.sqream.com/downloads/drivers/latest/SQreamDriverInstall.exe
    This will download the latest version.
    If you know your instance is running a different version, please contact support for the correct link.

Installing via the installation wizard

  1. Run the installer and follow the steps in the Wizard as you see below:
  2. The User Account Control window may open up. Click Yes to continue the installation.

  3. Follow the installation instructions

    Choose the components you wish to install. If you have a previous version installed, keep Remove old ODBC ODBC Driver Registry Keys selected.

    To install only the ODBC drivers, select only the top 3 components:

  4. Once the installer finishes, enter the ODBC Data Sources window in order to properly set up your connection:
    Open up the Windows menu by clicking the Windows button on your keyboard, and type ODBC. Then, pick ODBC Data Sources matching your system (usually 64-bit)

  5. Locate the correct DSN. The installer automatically added a DSN called "sqream64"

  6. Click Configure and enter the correct server details in the DSN editing screen, as given to you.
    SQream DB ODBC DSN configuration
    DSN: The DSN name, select something that you'll easily identify
    Server: The IP or hostname of the SQream DB server
    Port: The port of the SQream DB server. Typically 5000+ for a SQream DB server, or 3108 for the load balancer
    Database: The database name. The database name must exist beforehand. If this is your first connection, select "master", which is the default SQream DB database name.
    Username: Your SQream DB role
    Password: Your SQream DB role password
    Clustered: Select if you are connecting to the load balancer (port 3108), or leave blank if connecting directly to a SQream DB instance (port 5000+)
    SSL: Select if you are connecting to an SSL-encrypted port
  7. Save the connection settings by clicking Done and then OK. You can now test the ODBC installation with any tool that supports ODBC.
  • 67
  • 10-Apr-2018
  • 1199 Views