AQUILATM AQ2DB6 Caterpillar

User Account

Before creating an "Open Database Connectivity" (ODBC), make sure that the "Database Administrator" (DBA) has installed the Oracle ODBC driver on the target computer. The ODBC driver is provided with Oracle. The ODBC driver is NOT distributed by Caterpillar. Refer to Oracle's documentation for the ODBC driver installation.

A user account MUST be created by the DBA in Oracle that is dedicated to AQ2DB6. The user account must not have administrative rights to Oracle. Therefore, the "System" or "Sys" account which has administrative rights cannot be used.

AQ2DB6 will run scripts that will set up the table space within the user account. The user account will require that "Permissions" are assigned. Failure to assign permissions will cause errors when the scripts are run.

The following list contains the permissions that the user needs:

• Create Table

• Create Sequence

• Create Index

• Create Procedure

• Create Type

• Create View

Note: For example, the "WK_USER" user role in Oracle contains all of the above permissions.

The table space that the user account is assigned to should be set to "autoexpand". It is recommended to initially set the table space size to 500Mb and the autoexpand to a minimum of 100Mb increments.

Create the Database ODBC Connection

Show/hide table



Illustration 1	g01332802

1. Select the "Run..." option from the "Start" menu.

   The "Run" dialog box is shown in Illustration 2 appears.

Show/hide table



Illustration 2	g01332803

2. Enter "odbcad32" in the "Open" field.

3. Click the "OK" button.

   The "ODBC Data source Administrator" dialog box will open.

4. Select the "System DSN" tab (2) .

Show/hide table



Illustration 3	g01332805

5. Click on the "Add" button (3) .

6. Choose the driver "Oracle in <Database Name>" in the list.

7. Click the "finish" button.

Show/hide table



Illustration 4	g01332806

8. Enter a name for the connection in the "Data source name" field. For example, use "Aquila_Database".

9. Select the "TNS Service Name" from the list.

10. Enter the default user name in the "User ID" field.

Note: Both the "TNS name" and the "User ID" must be provided by the DBA.

11. Click the "Test Connection" button in order to verify the settings and the connection.

12. If the test is successful, then click the "Ok" button in order to confirm the connection.

    The connection will be shown in the list.

Show/hide table



Illustration 5	g01332807

13. Click the "OK" button in order to close the dialog box.