User`s guide

2 Getting Started with Database Toolbox

2-102

you want to close Database Explorer and all database connections, click the Close

button ( ) in the top-right corner.

If Database Explorer is docked, click the Close button ( ) to close all database

connections and Database Explorer.

Connect to Sybase using the JDBC connection command line.

Create a URL string using the format jdbc:subprotocol:subname. The

jdbc part of this string stays constant for any JDBC driver. subprotocol

is a database type. In this case, subprotocol is sybase:Tds. The last part

of the URL string is subname. For Sybase, this contains the server name,

the port number, and the database name. For example, your URL string is

jdbc:sybase:Tds:ServerName:PortNumber/dbname, where ServerName is

your server name, PortNumber is your port number, and dbname is your database

name.

Connect to the Sybase database using the database function. For example, the

following code assumes you are connecting to a database named dbname with user

name username and password pwd. The fourth argument is the driver Java class

object. This code assumes the class object is com.sybase.jdbc4.jdbc.SybDriver.

The last argument is the URL string URL.

conn = database('dbname','username','pwd',...