Oracle

Use the Database Test utility from the Utility menu to test and debug your database connection settings.

Step 1. Download Driver to the jre/lib/ext folder
Go to the Oracle website products page. Go to Java JDBC driver downloads.  You will need to register.  Download the driver from there.
Oracle 7.x Driver Name = classes111.zip
Oracle 8.x Driver Name = classes12.zip
You need to place the JDBC driver in the following 'ext' folder below depending on your installation method.  If the ext folder does not exist, create it.
For installs including JVM : ...Automize/jre/lib/ext
For installs without JVM : ...jre/1.3/lib/ext or JDK1.3/jre/lib/ext etc.. depending on your system.  

Step 2. Shutdown and Restart Automize

Step 3. Driver Class Name
For the Oracle 7.x driver, the classname is:
oracle.jdbc.driver.OracleDriver

Step 4. Database Url
The Url has to be constructed using the following syntax, where items contained in square brackets are optional:
jdbc:oracle:thin:@hostname:port:dbname

Example:
jdbc:oracle:thin:@192.168.0.1:1526:dms

if the database is on your computer, use localhost.  Otherwise use the IP address or Domain name of the server where the database resides.  If you installed your database and you do not know what your port number is, chances are you do not need to specify a port number. Most installations use the default ports.

Step 5. Test the Connection
Hit the Test the Connection button.  If everything was setup correctly, you will see some database information.