skip to main content
Getting Started : Configuring and Connecting on UNIX and Linux : Configuring a Data Source in the System Information File
  

Try DataDirect Drivers Now

Configuring a Data Source in the System Information File

The default odbc.ini file installed in the installation directory is a template in which you create data source definitions. You enter your site-specific database connection information using a text editor. Each data source definition must include the keyword Driver=, which is the full path to the driver.
The following examples show the minimum connection string options that must be set to complete a test connection, where xx represents iv for 32-bit or dd for 64-bit drivers, yy represents the driver level number, and zz represents the extension. The values for the options are samples and are not necessarily the ones you would use.
[ODBC Data Sources]
Amazon Redshift Wire Protocol=DataDirect 8.0 Amazon Redshift Wire Protocol Driver
[Amazon Redshift Wire Protocol]
Driver=ODBCHOME/lib/xxrsftyy.zz
Database=Redshiftdb1
HostName=RedshiftServer
PortNumber=5439
Connection Option Descriptions:
Database: The name of the database to which you want to connect by default.
HostName: Either the name or the IP address of the server to which you want to connect.
Port Number: The port number of the server listener. The default is 5439.