skip to main content
Using the driver : Using IP addresses
  

Try DataDirect Drivers Now

Using IP addresses

The driver supports Internet Protocol (IP) addresses in IPv4 and IPv6 formats.
The server name specified in a connection URL, or data source, can resolve to an IPv4 or IPv6 address. In the following example, the server name MyServer can resolve to either type of address:
jdbc:datadirect:sqlserver://MyServer:1433;
DatabaseName=Test;User=admin;Password=secret
Alternately, you can specify addresses using IPv4 or IPv6 format in the server portion of the connection URL. For example, the following connection URL specifies the server using an IPv4 address:
jdbc:datadirect:sqlserver://123.456.78.90:1433;
DatabaseName=MyDB;User=admin;Password=secret
You also can specify addresses in either format using the ServerName data source property. The following example shows a data source definition that specifies the server name using an IPv6 address:
SQLServerDataSource mds = new SQLServerDataSource();
mds.setDescription("My SQLServer DataSource");
mds.setServerName("2001:DB8:0:0:8:800:200C:417A");
...
Note: When specifying IPv6 addresses in a connection URL or data source property, the address must be enclosed by brackets.
In addition to the normal IPv6 format, the drivers support IPv6 alternative formats for compressed and IPv4/IPv6 combination addresses. For example, the following connection URL specifies the server using IPv6 format, but uses the compressed syntax for strings of zero bits:
jdbc:datadirect:sqlserver://[2001:DB8:0:0:8:800:200C:417A]:1433;
DatabaseName=MyDB;User=admin;Password=secret
Similarly, the following connection URL specifies the server using a combination of IPv4 and IPv6:
jdbc:datadirect:sqlserver://[0000:0000:0000:0000:0000:FFFF:123.456.78.90]:1433;
DatabaseName=MyDB;User=admin;Password=secret
For complete information about IPv6, go to the following URL:
http://tools.ietf.org/html/rfc4291#section-2.2