Universal Database Tools - DtSQL Logo
  Site Map
Universal Database Tools - DtSQL  pixel
Universal Database Tools - DtSQL  pixel
Universal Database Tools - DtSQL  pixel
Universal Database Tools - DtSQL navigator box   Home Universal Database Tools - DtSQL navigator box   Features Universal Database Tools - DtSQL  navigator box   Download Universal Database Tools - DtSQL  navigator box   Purchase Universal Database Tools - DtSQL  navigator box   Support Universal Database Tools - DtSQL  navigator box   Contact Universal Database Tools - DtSQL  navigator box   Events
Universal Database Tools - DtSQL  pixel
Universal Database Tools - DtSQL  pixel

Connect to Database



  1. Download JDBC driver file(s)
  2. Create database connection
  3. Sample Database connections

1. Download JDBC driver file(s)

There are several ways to connect to database, and the best way to download the proper JDBC driver that works with your database type and version. Below provides links to download most database drivers. Please read the driver instruction and download the proper driver to local machinean folder :

Cache : http://www.cachemonitor.de/intersystems-documentation/cache-jdbc-driver

DB2 : http://www-01.ibm.com/support/docview.wss?uid=swg21363866

Derby : http://db.apache.org/derby/derby_downloads.html

FireBird : http://www.firebirdsql.org/en/jdbc-driver/

FrontBase : http://www.frontbase.com/cgi-bin/WebObjects/FBWebSite

H2 : http://www.h2database.com/html/download.html

HSQLDB : http://sourceforge.net/projects/hsqldb/files/hsqldb/hsqldb_2_2/

Informix : http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=ifxjdbc

Ingres : http://community.actian.com/w/index.php/Ingres_JDBC_Driver_Downloads

MariaDB : https://downloads.mariadb.org/client-java/

MaxDB : http://www.sapdb.org/sap_db_jdbc.htm

Mckoi : http://www.mckoi.com/originalmckoisql/index.html

MongoDB : https://github.com/mongodb/mongo-java-driver/downloads

MySQL : http://dev.mysql.com/downloads/connector/j/

Oracle(Thin SID) : http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html

Pervasive : http://www.pervasivedb.com/support/Pages/PSQLSDK-Archives.aspx

PostgresSQL : http://jdbc.postgresql.org/download.html

Solid : the jar file can be found in Solid installation directory JDBC folder

SQLServer : http://www.microsoft.com/en-us/download/details.aspx?id=11774

Sybase : http://www.sybase.com/products/allproductsa-z/softwaredeveloperkit/jconnect


2. Create database connection

To create a database connection, select Connections -> Create Connection in the main menu bar. The adding new connection panel will be populated. Select the database driver on the left list and it will show required options.

DtSQL proivdes some default values if they are available for the database. For the DB2 JCC connection, the default connection name, port number, user id and driver name are available.

  • Connection Name - Default is same as the database connection name, it should be unique in existing connections and can be changed after the connection
  • Host Address - address of machine where the database is installed.
  • Port - Database connectino port number
  • User Id - User id used to connect to the database
  • Password - Password used to connect to the database
  • Driver Jar Files - Full path of database JDBC driver jar files.
  • Driver name - Database driver name
  • Database Name - Name of the database which will be connected.

To fill driver jar files, please click the file select button right after the text field. A file choice memu will be populated. Find and select the database driver file and then click 'Open'. If multiple driver jar files are used, then press Ctrl button and select these jar files and then click 'Open'. And then the selected driver files will be displayed in the text field. If there are multiple files selected, thoese files will be displayed in the text field seperated by semicolon. The driver files also can be filled manually.

After all information is completed, click the 'Test' button to test the connection to the database. If you have any questions, please contact us at support@dtsql.com


3. Sample Database Connections

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

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

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

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

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

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

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

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

Note: if your OS locale is different from your database locale, please specify locale in the URL to avoid locale mismatch error :
url = jdbc:informix-sqli://localhost:9088/testdb:INFORMIXSERVER=ol_svr_custom;


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

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

user = root
pwd =
driver = org.mariadb.jdbc.Driver
jar = C:\\JDBC\\mariadb\\mariadb-java-client-1.1.7.jar
url = jdbc:mysql://localhost:3306/test

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

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

user =
pwd =
host = localhost
port = 27017

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 = jdbc:oracle:thin:@localhost:1521:XE

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

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

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

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

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:


Copyright DigerTech Inc