Using IP Addresses
- Last Updated: May 10, 2024
- 1 minute read
- DataDirect Connectors
- ODBC
- Cloudera Impala 7.1
- dBase 7.1
- Flat files/Text 7.1
- MySQL 7.1
- Pervasive (Btrieve) 7.1
- XML 7.1
- Documentation
The drivers support Internet Protocol (IP) addresses in IPv4 and IPv6 format as shown in the following tables.
| Driver | IPv4 | IPv6 |
|---|---|---|
| Progress OpenEdge Wire Protocol | All supported versions | All supported versions |
| Sybase Wire Protocol | All supported versions | Sybase 12.5.2 and higher |
| Driver | IPv4 | IPv6 |
|---|---|---|
| Greenplum Wire Protocol | All supported versions | All supported versions |
| Impala Wire Protocol | All supported versions | Not supported |
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 Progress
OpenEdge server is specified in IPv4
format:
DRIVER=DataDirect 7.1 Progress OpenEdge Wire Protocol;
HOST=123.456.78.90;PORT=2055;
DB=OEACCT;UID=JOHN;PWD=XYZZYYouIn the following connection string example, the IP address for the Progress OpenEdge server is specified in IPv6 format:
DRIVER=DataDirect 7.1 Progress OpenEdge Wire Protocol;
HOST=2001:DB8:0000:0000:8:800:200C:417A;PORT=2055;
DB=OEACCT;UID=JOHN;PWD=XYZZYYou
In addition to the normal IPv6 format, the drivers in the preceding tables support IPv6 alternative formats for compressed 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 7.1 Progress OpenEdge Wire Protocol;
HOST=2001:DB8:0:0:8:800:200C:417A;PORT=2055;
DB=OEACCT;UID=JOHN;PWD=XYZZYYou
For complete information about IPv6 formats, go to the following URL: