The following section describes the minimum options required to establish a connection for drivers that support both 32 and 64-bit platforms. For a complete list of supported connection options, refer to the chapter for your driver.
Greenplum Wire Protocol Sybase Wire Protocol
Progress OpenEdge Teradata

Greenplum Wire Protocol

The following example demonstrates the minimum connection information required to establish a connection:

[Greenplum Wire Protocol]
...
Driver=ODBCHOME/lib/xxgplmnn.zz
...
Database=Gplumdb1
...
HostName=GreenplumServer
...
PortNumber=5432
...

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.
  • PortNumber: The port number of the server listener. The default is 5432.

Impala Wire Protocol

The following example demonstrates the minimum connection information required to establish a connection:

[Impala Wire Protocol]
Driver=ODBCHOME/lib/xximpala.zz
...
Database=Impala1
...
HostName=ImpalaServer
...
PortNumber=21050
...

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.
  • PortNumber: The port number of the server listener. The default is 21050.

Progress OpenEdge Wire Protocol

The following example demonstrates the minimum connection information required to establish a connection: 

[Progress OpenEdge Wire Protocol]
Driver=ODBCHOME/lib/xxoenn.zz
...
Database=odb1
...
HostName=OpenEdgeServer
...
PortNumber=5432
...

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.
  • PortNumber: The port number of the server listener.

Sybase Wire Protocol

The following example demonstrates the minimum connection information required to establish a connection:

[Sybase Wire Protocol]
Driver=ODBCHOME/lib/xxasenn.zz
...
Database=master
...
NetworkAddress=123.226.224.34,5000
...
Connection option descriptions:
  • Database: The name of the database to which you want to connect by default. If you do not specify a value, the default is the database defined by the system administrator for each user.
  • NetworkAddress: The IP address of the server to which you want to connect. Specify this address as: IP_address, port_number. For example, you can enter 123.226.224.34, 5000.

    If your network supports named servers, you can specify an address as: server_name, port_number. For example, you can enter SSserver, 5000.

Driver for the Teradata Database

Prerequisites:
  • You must have all components of your database client software installed and connecting properly; otherwise, the driver will not operate correctly.

The following example demonstrates the minimum connection information required to establish a connection: :

[Teradata]
Driver=ODBCHOME/lib/xxterann.zz
...
DBCName=123.123.12.12
...
SecurityMechanism=TD2
...
SecurityParameter=5678
...
UserID=John
...
Connection option descriptions:
  • DBCName: The IP address or the alias name of the Teradata Server. Using an IP address reduces the time it takes to connect, but if that address is not available at connection time, the connection fails and the driver does not attempt to fail over to another address.

    Using an alias name increases the time it takes to connect because the driver must search a local hosts file to resolve the name to the IP address information, but it allows the driver to try and connect to alternate IP addresses if the first address fails. If you use an alias name, you must have or create a local hosts file that contains the alias names. The alias name cannot be more than eight characters long.

  • SecurityMechanism: Enter TD2.
  • SecurityParameter: A string of characters that is to be regarded as a parameter to the authentication mechanism. The string is ignored by the ODBC driver and is passed on to the TeraSSO function that is called to set the authentication mechanism. The characters [] {} () , ; ? * = ! @ must be enclosed in curly braces.
  • UserID: The default UserID for the Teradata database.