Database Test
This is the most difficult task to implement correctly. Please read this entire documentation very carefully.
This utility helps you to test your connection to a database on your system or on any remote system. It connects to your database using an intermediate JDBC (Java Database Connectivity) driver, provided by a database vendor or third party vendor. Detailed JDBC driver and connection information for popular databases like MSAccess, Oracle, Informix, MySql, mSql, Postgres are included in our knowledge base online at www.hiteksoftware.com. Go to our main support page and use the knowledge base link. Our knowledge base will have the latest information on these databases and other databases provided by our users. If you succeed in connecting to a database which is not listed in our knowledge base, please provide us with your information so that other users may benefit.
Detailed information on JDBC drivers that are available for most databases is provided by www.javasoft.com. Please read the JDBC driver documentation very carefully on what values to enter for the Driver Class Name and Database Url. These have to be entered very accurately as specified by the JDBC driver vendor.
Database JDBC driver
For your database, you need to obtain the JDBC driver from your database
vendor or other 3rd party vendor. Most of the commercial database
vendors have free JDBC drivers available at their web site. Legal
issues may prevent us from redistributing some of these free JDBC drivers
in our software or at our web site.
The JDBC driver is generally in the form of a .zip or .jar file. You
need to place the JDBC driver in the following folder depending on your
installation method. Then restart the engine and the user interface.
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
Driver class name
Enter the class name for the driver. This information will be
available in the driver documentation. For Microsoft Access database,
simply enter "access". Also, the JDBC driver required for MSAccess
is included within java itself.
Database Url
Enter the Url connection information. This information will be
available with the Java JDBC driver documentation.
The Url format will vary with vendor, but generally includes the server
name, port, database name, username, password.
Authorization
If your database requires authentication, then select this option and
enter your username and password.
Username
Enter your username if required for database access. It is case
sensitive.
Password
Enter your password if required for database access. It is case
sensitive.