Using IP Addresses
- Last Updated: April 16, 2026
- 1 minute read
- ADO.NET
- Documentation
The DataDirect Connect for ADO.NET data providers support Internet Protocol (IP) addresses in IPv4 and IPv6 format. IPv6 addresses are only supported when connecting to certain database versions, as shown in the following table.
IP Address Formats Supported by the DataDirect Connect for ADO.NET Data Providers
| Data Provider | IPv4 | IPv6 |
| DB2 | All supported versions | DB2 V9.1 and higher for Linux/UNIX/Windows DB2 V5R2 for i and higher |
| Oracle | All supported versions | Oracle 11g R2 (IPv6 supported in single instance mode only) |
| Microsoft SQL Server | All supported versions | Microsoft SQL Server 2005 and higher |
| Sybase | All supported versions | Sybase 12.5.2 and higher |
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 examples, the IP address for the DB2 server is specified in IPv6 format:
Host=2001:DB8:0000:0000:8:800:200C:417A;Port=5179;
Database Name=DB2ACCT;User ID=JOHN;Password=XYZZYYou
Host=2001:DB8:0:0:8:800:123.456.78.90;Port=5179;
Database Name=DB2ACCT;User ID=JOHN;Password=XYZZYYou
In addition to the normal IPv6 format, DataDirect Connect for ADO.NET data providers support IPv6 alternative formats for compressed addresses and addresses for environments containing a mixture of IPv4 and IPv6 nodes.
For example, the following connection string specifies the server using IPv6 format, and uses the compressed syntax for strings of zero bits:
Host=fe80::202:55ff:fe97:afd2%4;Port=5179;
Database Name=DB2ACCT;User ID=JOHN;Password=XYZZYYou
For complete information about IPv6 formats, go to the following URL: