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
[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.