User`s guide

Microsoft SQL Server ODBC for Windows
2-31
tab. The Close button turns into a red circle ( ). Click it to close the database
connection. If 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 Microsoft SQL Server using the native ODBC connection command line.
1
To connect with Windows authentication, connect to the database with the
authenticated ODBC data source name and blank user name and password. For
example, the following code assumes you are connecting to a data source named MS
SQL Server Auth.
conn = database.ODBCConnection('MS SQL Server Auth','','');
Or, to connect without Windows authentication, connect to the database with
the ODBC data source name. For example, the following code assumes you are
connecting to a data source named MS SQL Server with user name username and
password pwd.
conn = database.ODBCConnection('MS SQL Server','username','pwd');
2
Close the database connection conn.