Syntax

jdbc:datadirect:drivername://server_name:port[;property=value[;...]]

where:

drivername
is the name of the driver, for example, sybase.
server_name
is the IP address or TCP/IP server name of the server to which you are connecting. See Using IP Addresses for details on using IP addresses.
port
is the number of the TCP/IP port.
property=value
specifies connection properties. Multiple properties are separated by a semi-colon. For a list of connection properties supported for each driver and their valid values, see the appropriate driver chapter.
Note: Untrusted applets cannot open a socket to a machine other than the originating host.

The following table shows some typical driver connection URLs for each driver.

Table 1. Example URLs for DataDirect Connect for JDBC
Driver URL
DB2 for Linux/UNIX/Windows 1 
jdbc:datadirect:db2://server1:50000;DatabaseName=jdbc;
User=test;Password=secret
DB2 for z/OS and i 2 
jdbc:datadirect:db2://server1:446;LocationName=Sample;
User=test;Password=secret
MySQL 
jdbc:datadirect:mysql://server1:3306;User=test;
Password=secret
Oracle 3 
jdbc:datadirect:oracle://server3:1521;ServiceName=ORCL;
User=test;Password=secret
Progress OpenEdge 
jdbc:datadirect:openedge://server1:2003;User=test;
Password=secret
Microsoft SQL Server 4 
jdbc:datadirect:sqlserver://server1:1433;User=test;
Password=secret
Sybase 
jdbc:datadirect:sybase://server2:5000;User=test;
Password=secret
1 See the DB2 driver chapter for more information about creating DB2 packages.
2 See the DB2 driver chapter for more information about creating DB2 packages.
3 See the Oracle driver chapter for instructions on retrieving connection information from an Oracle tnsnames.ora file.
4 See the SQL Server driver chapter for instructions on connecting to named instances.