User`s guide

2 Getting Started with Database Toolbox

2-116

Connect to Microsoft SQL Server using the JDBC connection command line.

When using the command line, you do not have to set up a data source with Database

Explorer. You can use the command line to pass all the required parameters for

connection.

Use the Vendor name-value pair argument of database to specify a connection to

a Microsoft SQL Server database. Set the AuthType name-value pair argument to

Server. For example, the following code assumes you are connecting to a database

named dbname on a database server named sname with user name username,

password pwd, and port number as 123456.

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

'Vendor','Microsoft SQL Server','Server','sname',...

'AuthType','Server','PortNumber',123456);

Close the database connection conn.

close(conn)