The following table shows the URL formats for DataDirect Connect for JDBC drivers, where:

  • server_name identifies the server using one of the following methods:
    • IP address
    • Host name (if your network resolves host names to IP addresses) 1
  • The integer value that appears after the server name is the port number on which the database is listening.
Table 1. URL Formats for DataDirect Connect for JDBC Drivers
Driver URL Format
DB2 for Linux/UNIX/Windows 2 
jdbc:datadirect:db2://server_name:50000;
DatabaseName=your_database
DB2 for z/OS and i 3 
jdbc:datadirect:db2://server_name:446;
LocationName=db2_location
MySQL 
jdbc:datadirect:mysql://server_name:3306
Oracle 4 
jdbc:datadirect:oracle://server_name:1521;
ServiceName=your_servicename
Progress OpenEdge 
jdbc:datadirect:openedge://server_name:2003;
DatabaseName=your_database
Microsoft SQL Server 5 
jdbc:datadirect:sqlserver://server_name:1433
Sybase 
jdbc:datadirect:sybase://server_name:5000
1 You can use the ping command to verify this feature (for example, ping server1). Verify that the correct IP address is returned in the reply from the command.
2 See the DB2 driver chapter for more information about creating DB2 packages.
3 See the DB2 driver chapter for more information about creating DB2 packages.
4 See the Oracle diver chapter for instructions on retrieving connection information from an Oracle tnsnames.ora file.
5 See the SQL Server driver chapter for instructions on connecting to named instances.