Open topic with navigation
Configuring a Windows ODBC Connection for Use with Kourier
When configuring a windows ODBC connection for use with Kourier in a U2 environment, you must first take the following steps to ensure that all of your data will be returned when performing an ODBC to SQL export:
- You must setup an ODBC data source on your windows machine that is running UniVerse.
- You must install ODBC drivers that match the architecture on your Windows machine (32 or 64 bit).
- Download the ODBC drivers if necessary.
- You must setup a System DSN on your Windows machine (follow the Microsoft process for setting up a System DSN).
Once the above steps are complete, configure the System DSN using the defaults with the following exception:
- For Windows ODBC drivers that allow you to configure the Int8, BigInt, or Postgres datatypes, select the varchar option if it is available in the driver configuration. If the ODBC driver on your Windows system does not have an Int8 or BigInt option, or if the varchar option is not available, refer to the Configuring ODBC Data Sources - Workaround for BigInt procedure.