Settings Tab (Visual Basic Batch T-SQL Debugger Dialog Box)

Tab Options

DSN (Data Source Name)

Displays a list of DSNs currently installed on your computer to which you can connect. Use the 32-bit ODBC icon in the Control Panel to install new DSNs.

Register DSN

Displays the ODBC SQL Server Setup dialog box. See your ODBC documentation for additional information.

SQL Server

Allows you to type the name of the SQL server where the database resides. This information is required, even if a DSN is already provided.

Database

Allows you to type the name of the database to which you want to connect.

UID (User ID)

Allows you to type the User ID required to connect to this data source. If the data source does not require a user ID, you can leave this box blank.

Password

Allows you to type the password required to connect to the data source. If the data source does not require a password, you can leave this box blank.

Lock Type

Sets a long integer value indicating the type of concurrency handling.

Result Set

Specifies the type of cursor used to manage the result set.

Options

Specifies whether to use SQLExecDirect instead of SQLPrepare and SQLExecute.

Execute

Invokes the debugger and allows you to debug the SQL statements you are interested in.

Close

Closes the Batch T-SQL Debugger dialog box.