How does one connect to a POL database?

To connect to a POL database, the username is typically SYSTEM (with POL v2.4 the default username was OOT_SCH). The password is ignored as the POL database is initially not password protected, but must be specified for SQL*Plus. The connect string should be ODBC:data_source_name. The "ODBC:" tells SQL*Plus that this is not a SQL*Net connection, and that it must use the Oracle Open Client Adapter (OCA) to access the database.

The following command line is used to access the default starter database via SQL*Plus (8i and below):

sqlplus system/manager@odbc:polite:polite
SQL> select * from all_tables;

SQL> exit;

For Oracle 9i, use the Mobile SQL (msql) utility:

C:>msql system/manager@jdbc:polite:polite
Oracle MSQL Version 1.0.0.0.2
(c) Copyright 2001 Oracle Corporation. All rights reserved
Connected to: Oracle9i Lite ORDBMS
Database Name: POLITE (Read Write)
Database Version: 4.0.3.0.0
Auto Commit: off
Driver Name: oracle.lite.poljdbc.POLJDBCDriver (OLite 4.0)
SQL>