1. SuiteAnalytics
  2. Connect
  3. Accessing the Connect Service Using an ODBC Driver
  4. Downloading and Installing the ODBC Driver for Windows
  5. ODBC Installation on Windows for Installer Only

ODBC Installation on Windows for Installer Only

Before you install or upgrade the Connect driver, ensure that you meet the installation prerequisites. For more information, see Installation Prerequisites.

Download an installer if you do not want your current user context data to be used. Use this approach if you want to install the driver or automated services. This installer can create generic System DSNs. If you use only the installer file and there is no dsn.ini file, then fallback content is provided during installation. The fallback content configures the default service host without any role IDs or account IDs.

After you downloaded the Connect driver, ensure that you install it as local administrator. If you install the driver on Windows as domain administrator, the installation process may fail.

When you run the installer, you must review the content and add the Account ID and Role ID to get a DSN. Note that you may need to create additional DSNs manually, if you want to connect to another server or you want to select between different account types, for example, both production and sandbox. For more information, see Configuring the ODBC Data Source on Windows.

Downloading the Connect Driver

You can download all Connect drivers from the SuiteAnalytics Connect Driver Download page. For more information, see Downloading and Installing Connect Drivers.

Installing the Connect Driver

After downloading the driver, run the downloaded file to install it.

To install the Connect driver:

  1. Run the file you downloaded and follow the wizard's instructions.

  2. When the installation is complete, configure the connection attributes. For more information, see Configuring the ODBC Data Source on Windows.

Upgrading the Connect Driver

There are several ways to upgrade the ODBC driver:

  • Upgrading the existing driver - This upgrade option is preferred. The values of the Data Source Name (DSN) are updated automatically with the required attributes. See Upgrading the Existing Driver.

  • Uninstalling the old driver before installing the latest one - Choosing this upgrade option is not preferred. You need to create a new DSN or to edit to Windows registry to include a connection attribute. See Uninstalling the Old Driver and Installing the Latest Driver.

Upgrading the Existing Driver

The preferred upgrade option is to install the latest driver without uninstalling the old one. If you choose this option, you do not need to perform any further steps, unless you use a DSN-less connection.

To upgrade the existing driver:

  1. Run the file you downloaded and follow the wizard's instructions.

  2. When the installation is complete, you can verify the connection attributes. For more information, see Verifying the ODBC Driver Installation on Windows.

Uninstalling the Old Driver and Installing the Latest Driver

Choosing this upgrade option is not preferred. If you choose to uninstall the old driver and install the latest one, you need to update the existing Data Source Name (DSN) values in the Windows registry.

To uninstall the old driver and install the latest driver:

  1. Locate the existing driver file on your machine.

  2. Right-click the driver file and click Uninstall.

  3. You are asked if you want to delete the existing ODBC DSNs. You can choose one of the following options:

    • Yes - If you choose to delete the existing Data Source Names (DSN) you need to create a new DSN after installing the new driver. This DSN includes the required attributes of the latest driver. For more information, see Using the ODBC Administrator Tool.

    • No - If you choose not to delete the existing DSNs, the values of the DSNs are kept. However, these values do not include the required attribute for the latest driver. You need to edit the Windows registry to add the the required connection attribute. For more information, see Using the Windows Registry.

  4. After uninstalling the old driver, run the file you downloaded and follow the wizard's instructions. Do one of the following:

    • If you chose Yes when you uninstalled the old driver, you need to create a new DSN using the ODBC administrator tool. For more information, see Using the ODBC Administrator Tool.

    • If you chose No when you uninstalled the old driver, the old values of the DSNs were kept and you need to update them using the Windows registry. For more information, see Using the Windows Registry.

Related Topics

General Notices