AnySQL is a command line database interface tools wrote in Java, just like Oracle's SQL*Plus, but connect to the database via JDBC. There are 3 connect methods available.
The default method is Oracle JDBC Thin driver, no Oracle client software is required, but you must keep Oracle listener running for connection.
ASQL> set driver thin
Oracle driver set to : thin
ASQL> conn system/oracle@localhost:1521:db10g
Database connected.
The second method is Oracle JDBC OCI driver, which require you install the Oracle client software and use the JDBC driver with the same platform and version of the Oracle client. You can connect to local database with out Oracle listener running.
ASQL> set driver oci
Oracle driver set to : oci
ASQL> conn system/oracle
Database connected.
If you have valid datadirect JDBC driver, you can use it, no Oracle client software is required, but you must keep Oracle listener running for connection.
ASQL> set driver datadirect
Oracle driver set to : datadirect
ASQL> conn system/oracle@localhost:1521;sid=db10g
Database connected.
If you want to use TNS alias, please copy the TNS configuration file to where you installed the AnySQL utility (Just download and extract it).