Passing the connection URL

After setting the CLASSPATH, the required connection information needs to be passed in the form of a connection URL.

jdbc:datadirect:sqlserver://hostname:port[;property=value[;...]]

where:

hostname

is the IP address or host name of the server to which you are connecting.

port

is the number of the TCP/IP port.

property=value

specifies connection properties.

Notes

Untrusted applets cannot open a socket to a machine other than the originating host.

Connection conn = DriverManager.getConnection
("jdbc:datadirect:sqlserver://MyServer:1433;
User=test;Password=secret;DatabaseName=MyDB");