You use this window to connect to a database and to run SQL commands.
On the menu bar, click File > Database Type Test and Query to open this window.
Database type
In this group box, you select the platform on which your database runs. The following options are available:
-
Oracle
-
SQL Server
If you click Actions > Use INI File, the software selects the database type automatically.
ODBC driver
Accept the default value for the database platform, or type a different value. If your database is Oracle, you must enter the DBMS parameter of your Oracle version. For example, for Oracle 11g, enter ORA. If you click Actions > Use INI File, the software retrieves the DBMS parameter value from the [Database] section of Intools.ini file and displays this value in the ODBC driver box automatically.
When the database platform is SQL Server, make sure that the ODBC driver box displays MSS in upper case. In the Intools.ini file, the string DBMS=MSS must display MSS in upper case; otherwise, it is not possible to work with specifications in .
Connection settings
Displays the connection settings retrieved from the Intools.ini file or allows you to enter the connection settings manually if you need to connect to another database.
Schema logon name
Allows you to type the logon name of the Admin or Domain schema.
Schema logon password
Allows you to type the logon password of the Admin or Domain schema. The password characters appear masked.
Server name
Allows you to type the Oracle instance alias for the server to which you want to connect.
Only required when the database type is Oracle.
Database name
Allows you to type the Oracle instance alias for the database to which you want to connect. The alias name is the same for both boxes.
Only required when the database type is Oracle.
DBParm
Displays the connection string as defined for the DBParm parameter under the [Database] section of the Intools.ini file.
Only required when the database type is SQL Server.
On SQL Server, if you first connected to the Admin schema by using the Intools.ini
file parameters, when connecting to a Domain schema on SQL Server, you must manually
change the UID and PWD values to match the displayed target Domain schema logon name and password respectively.
Auto commit
Allows you to execute a batch of SQL commands. If you clear the check box, when executing SQL commands, the software prompts you to execute each SQL command manually.
Query
Allow you to enter the SQL command that you want to execute for the database to which you are connected.
Results
Displays the result of making a database connection or executing SQL commands. On connecting to the database, a zero (0) parameter indicates a successful connection.
Database Type Test and Query Toolbar
Use .INI
Allows you to copy the database settings from the Intools.ini file to the boxes in the Connection setting dialog box.
Connect
Connects to the database specified in the Database type and Connection setting parameters.
The following icons are active only after you connect to a database.
Execute
Executes the SQL commands that you typed in the Query pane.
Open
Opens an .sql file.
Save as
Save the results of an SQL Select command in a specified format.
Print
Print the results of an SQL Select command.