Using IP Addresses

Part 1: Getting Started : Using The Product : Using IP Addresses

Using IP Addresses

The drivers support Internet Protocol (IP) addresses in IPv4 and IPv6 format as shown in the following tables.

Table 1. IP Address Formats Supported by 32- and 64-bit DataDirect Connect for ODBC Drivers
Driver	IPv4	IPv6
DB2 Wire Protocol	All supported versions	DB2 9.1 and higher for Linux/UNIX/Windows DB2 9.1 for z/OS and higher DB2 for i5/OS V5R3 and higher
Informix Wire Protocol	All supported versions	Informix 10 and higher
MySQL Wire Protocol	All supported versions	Not supported
Oracle Wire Protocol	All supported versions	Oracle 11gR2
Microsoft SQL Server Legacy Wire Protocol (UNIX/Linux only)	All supported versions	Microsoft SQL Server 2005 and higher
Microsoft SQL Server Wire Protocol	All supported versions	Microsoft SQL Server 2005 and higher
PostgreSQL Wire Protocol	All supported versions	PostgreSQL 8.2 and higher
Progress OpenEdge Wire Protocol	All supported versions	Progress OpenEdge 10.0 and higher
Sybase Wire Protocol	All supported versions	Sybase 12.5.2 and higher

Table 2. IP Address Formats Supported by 32- and 64-bit DataDirect Connect XE for ODBC Drivers
Driver	IPv4	IPv6
Driver for Apache Hive	All supported versions	Not supported
Greenplum Wire Protocol	All supported versions	Not supported
Impala Wire Protocol	All supported versions	Not supported
Salesforce	All supported versions	All supported versions
Sybase IQ Wire Protocol	All supported versions	All supported versions

If your network supports named servers, the server name specified in the data source can resolve to an IPv4 or IPv6 address.

In the following connection string example, the IP address for the DB2 server is specified in IPv6 format:

DRIVER=DataDirect DB2 Wire Protocol;
IpAddress=2001:DB8:0000:0000:8:800:200C:417A;PORT=5179;
DB=DB2ACCT;UID=JOHN;PWD=XYZZYYou

In addition to the normal IPv6 format, the drivers in the preceding tables support IPv6 alternative formats for compressed and IPv4/IPv6 combination addresses. For example, the following connection string specifies the server using IPv6 format, but uses the compressed syntax for strings of zero bits:

DRIVER=DataDirect DB2 Wire Protocol;
IpAddress=2001:DB8:0:0:8:800:200C:417A;PORT=5179;
DB=DB2ACCT;UID=JOHN;PWD=XYZZYYou

Similarly, the following connection string specifies the server using a combination of IPv4 and IPv6:

DRIVER=DataDirect DB2 Wire Protocol;
IpAddress=2001:DB8:0:0:8:800:123.456.78.90;PORT=5179;
DB=DB2ACCT;UID=JOHN;PWD=XYZZYYou

For complete information about IPv6 formats, go to the following URL:

http://tools.ietf.org/html/rfc4291#section-2.2