Here is useful reference to connect different databases:

From : DtSQL Users Guide - Installation

Cache
user = _SYSTEM
pwd =
driver = com.intersys.jdbc.CacheDriver
jar = C:\\JDBC\\Cache\\CacheDB.jar
url = jdbc:Cache://localhost:1972/SAMPLES

DB2 (APP)
user = db2admin
pwd =
driver = COM.ibm.db2.jdbc.app.DB2Driver
jar = C:\\JDBC\\DB2\\db2java.zip
url = jdbc:db2:TESTDB

DB2 (JCC)
user = db2admin
pwd =
driver = com.ibm.db2.jcc.DB2Driver
jar = C:\\JDBC\\DB2\\db2jcc.jar;C:\\JDBC\\DB2\\db2jcc_li cense_cu.jar
url = jdbc:db2://localhost:50000/TESTDB

Derby
user =
pwd =
driver = org.apache.derby.jdbc.ClientDriver
jar = C:\\JDBC\\Derby\\derby.jar;C:\\JDBC\\Derby\\derbyc lient.jar
url = jdbc:derby://localhost:1527/test;create=true

FireBird
user = sysdba
pwd =
driver = org.firebirdsql.jdbc.FBDriver
jar = C:\\JDBC\\Firebird\\jaybird-full-2.1.6.jar
url = jdbc:firebirdsql://localhost:3050/C:\\Program Files\\Firebird\\Firebird_2_1\\examples\\empbuild\ \EMPLOYEE.FDB

FrontBase
user = testuser
pwd =
driver = com.frontbase.jdbc.FBJDriver
jar = C:\\JDBC\\FrontBase\\frontbasejdbc.jar
url = jdbc:FrontBase://localhost/firstdb

H2
user = sa
pwd =
driver = org.h2.Driver
jar = C:\\JDBC\\H2\\h2-1.2.126.jar
url = jdbc:h2:~/test

H2 (Embedded)
user = sa
pwd =
driver = org.h2.Driver
jar = C:\\JDBC\\H2\\h2-1.2.126.jar
url = jdbc:h2:file:C:\\Program Files\\H2\\bin\\test.h2.db

HSQLDB (Embedded)
user = SA
pwd =
driver = org.hsqldb.jdbcDriver
jar = C:\\JDBC\\HSQLDB\\hsqldb.jar
url = jdbc:hsqldb:file:C:\\JDBC\\HSQLDB\\test

Informix
user = dtsql
pwd =
driver = com.informix.jdbc.IfxDriver
jar = C:\\JDBC\\Infomix\\ifxjdbc.jar
url = jdbc:informix-sqli://localhost:9088/testdb:INFORMIXSERVER=ol_svr_custom

Ingres
user =
pwd =
driver = com.ingres.jdbc.IngresDriver
jar = C:\\JDBC\\Ingres\\iijdbc.jar
url = jdbc:ingres://localhost:II7/demodb

JDataStore
user = sysdba
pwd =
driver = com.borland.datastore.jdbc.DataStoreDriver
jar = C:\\JDBC\\JDataStore\\jds.jar;C:\\JDBC\\JDataStore \\jdsremote.jar
url = jdbc:borland:dsremote://localhost/c:\\JDataStore\\datastores\\employee.jds

MaxDB
user = DBADMIN
pwd =
driver = com.sap.dbtech.jdbc.DriverSapDB
jar = C:\\JDBC\\MaxDB\\sapdbc.jar
url = jdbc:sapdb://localhost:7210/MAXDB1

Mckoi
user = test_user
pwd = la:ldj6::
driver = com.mckoi.JDBCDriver
jar = C:\\JDBC\\Mckoi\\mkjdbc.jar
url = jdbc:mckoi:local://C:/mckoiddb_1.1.01/demo/sdb/client.conf?create=true

MySQL
user = root
pwd =
driver = com.mysql.jdbc.Driver
jar = C:\\JDBC\\MySQL\\mysql-connector-java-5.1.8-bin.jar
url = jdbc:mysql://localhost:3306/test

Oracle(Thin SID)
user = SYSTEM
pwd =
driver = oracle.jdbc.driver.OracleDriver
jar = C:\\JDBC\\Oracle\\ojdbc14.jar
url = jdbcracle:thin:@localhost:1521:XE

Pervasive
user =
pwd =
driver = com.pervasive.jdbc.v2.Driver
jar = C:\\JDBC\\Pervasive\\jpscs.jar;C:\\JDBC\\Pervasive \\pvjdbc2.jar;C:\\JDBC\\Pervasive\\pvjdbc2x.jar
url = jdbc:pervasive://localhost:1583/demodata

PointBase
user =
pwd =
driver = com.pointbase.jdbc.jdbcUniversalDriver
jar = C:\\JDBC\\PointBase\\pbclient44.jar
url = jdbc:pointbase:server://localhost/sample

PostgresSQL
user = postgres
pwd = ji:l,ka:
driver = org.postgresql.Driver
jar = C:\\JDBC\\Postgres\\postgresql-8.4-701.jdbc3.jar
url = jdbc:postgresql://localhost:5432/test

Solid
user = dba
pwd =
driver = solid.jdbc.SolidDriver
jar = C:\\JDBC\\SolidDB\\SolidDriver2.0.jar
url = jdbc:solid://localhost:1315

SQLite
user =
pwd =
driver = org.sqlite.JDBC
jar = C:\\JDBC\\SQLite\\sqlitejdbc-v056.jar
url = jdbc:sqlite:C:\\sqlite\\sqlite-shell-win32-x86-3070400\\test.db

SQLServer (Microsoft 2005)
user = sa
pwd =
driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
jar = C:\\JDBC\\SQLServer\\sqljdbc4.jar
url = jdbc:sqlserver://localhost:1433;DatabaseName=testdb

Sybase SQL Anywhere
user = DBA
pwd =
driver = com.sybase.jdbc3.jdbc.SybDriver
jar = C:\\JDBC\\Sybase\\jconn3.jar
url = jdbc:sybase:Tds:localhost:2638?DatabaseName=demo

Sybase ASE:
user = sa
pwd =
driver = com.sybase.jdbc3.jdbc.SybDriver
jar = C:\\JDBC\\Sybase\\jconn3.jar
url = jdbc:sybase:Tds:192.168.1.102:5000?DatabaseName=de mo