Skip to content

Sybase IQ 16.0: Configure Sybase IQ ODBC connection from MS Windows 10

This post enumerates the steps to configure an ODBC connection to SAP Sybase IQ 16.0 from MS Windows 10.

Environment

  • MS Windows 10 Enterprise
  • SAP Sybase IQ 16.0SP11 ODBC Drivers

Prerequisites

Sybase IQ 16.0: How to install SAP sybase IQ ODBC drivers on MS Windows 10

Steps

  1. Select Start->All apps->SAP->ODBC Administrator XX-bit (XX = 32 if you need
    to configure a connection using the 32 bits ODBC driver (XX = 64 if you need
    to configure a connection using the 64 bits ODBC driver).
  2. If not already selected, select the “User DSN” tab and click “Add”.
  3. On the “Create New Data Source” window, select “Sybase IQ” and click on the button “Finish”.
  4. On the “ODBC Configuration for SQL Anywhere” window, select the “ODBC” tab and enter the Data source name and the description.
  5. On the “Login” tab:
    1. select “Database” as authentication,
    2. enter your Sybase IQ database user and password,
    3. select “Connect to a running database on another server” as action,
    4. Enter the hostname, port number, server name and database name.
  6. On the “ODBC” tab, click on the button “Test Connection”. If the DSN was correctly configured
    a “Connection successful” note will display.

  7. You should see the newly created data source in the list. Click “OK” to close the “ODBC Data Source Administrator”.
Advertisements

Sybase IQ 16.0: How to install SAP sybase IQ ODBC drivers on MS Windows 10

This post enumerates the steps to install SAP Sybase ODBC drivers on MS Windows 10.

Environment

  • MS Windows 10 Enterprise
  • SAP Sybase IQ 16.0SP11

Prerequisites

Extract the SAP Sybase IQ ODBC driver installer from
the SAP Sybase IQ Network Client Installer

Steps

  1. Execute (double click) the setup.exe file.
  2. If prompted, confirm you want to install the drivers.
  3. Click “Next” on the welcome screen of the installer.
  4. Select the folder where you want to install the Sybase IQ ODBC drivers. You can also leave the default proposed location C:/SAP.
  5. Select the type of installation to perform (“Typical” recommended) and click “Next”.
  6. Confirm to proceed with the installation by clicking on “Install”.
  7. Click on “Done” to close the installation program.

Sybase IQ 16.0: How to extract the ODBC driver installer from the IQ Network Client Installer

In this post I describe how to extract the SAP Sybase IQ ODBC driver installer from
the SAP Sybase IQ Network Client Installer.

Motivation

Why do I need to extract the individual SAP Sybase IQ ODBC installer anyway?

I need to install the ODBC driver on a MS Windows 10 client, but compatibility issues impedes the IQ Network Client
installer to execute; none of the compatibility modes available on MS Windows 10 works. However, executing
the individual SAP Sybase IQ ODBC driver installer works.

Environment

  • MS Windows 10 Enterprise
  • SAP Sybase IQ 16.0SP11

Steps

  1. Download the SAP Sybase IQ Network Client from the SAP download website.
    I downloaded IQNC160011_0-20011253.ZIP (EBF 25558: 16.0 SP11 PL 00)
    SAP account is required.
  2. Unzip the downloaded zip file on a temporary directory.
  3. Navigate to the directory IQNC160011_0-20011253\ebf25558\archives\iq_odbc
  4. The IQ ODBC driver installer is named setup.exe, to install the IQ ODBC driver
    you only need to execute the setup.exe file.
    To install the driver in another MS Window 10 client machine, copy the
    setup.exe file to a central location or to the client machine, and execute it.
  5. Follow the installation instructions.
  6. Clean up any temporary file or directory.