Using IP addresses
- Last Updated: March 4, 2024
- 1 minute read
- DataDirect Connectors
- ODBC
- Microsoft SQL Server 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 SQL Server
server is specified in IPv4
format:
DRIVER=DataDirect 8.0 SQL Server Wire Protocol;
HostName=123.456.78.90;PORT=1433;
DB=SQLSACCT;UID=JOHN;PWD=XYZZYYouIn the following connection string example, the IP address for the SQL Server server is specified in IPv6 format:
DRIVER=DataDirect 8.0 SQL Server Wire Protocol;
HostName=2001:DB8:0000:0000:8:800:200C:417A;PORT=1433;
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 SQL Server Wire Protocol;
HostName=2001:DB8:0:0:8:800:200C:417A;PORT=1433;
DB=SQLSACCT;UID=JOHN;PWD=XYZZYYou
For complete information about IPv6 formats, go to the following URL: