Using IP addresses
- Last Updated: March 4, 2024
- 1 minute read
- DataDirect Connectors
- ODBC
- PostgreSQL 8.0
- Documentation
The driver supports Internet Protocol (IP) addresses in the IPv4 and IPv6 formats.
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 PostgreSQL
server is specified in IPv4
format:
DRIVER=DataDirect 8.0 PostgreSQL Wire Protocol;
HOST=123.456.78.90;PORT=5432;
DB=PSQLACCT;UID=JOHN;PWD=XYZZYYouIn the following connection string example, the IP address for the PostgreSQL server is specified in IPv6 format:
DRIVER=DataDirect 8.0 PostgreSQL Wire Protocol;
HOST=2001:DB8:0000:0000:8:800:200C:417A;PORT=5432;
DB=SQLSACCT;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 8.0 PostgreSQL Wire Protocol;
HOST=2001:DB8:0:0:8:800:200C:417A;PORT=5432;
DB=SQLSACCT;UID=JOHN;PWD=XYZZYYou
For complete information about IPv6 formats, go to the following URL: