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