DtSQL Users Guide - Connect to Database

http://www.dtsql.com
support@dtsql.com

 
 

up

  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

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

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

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

 

top
 

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

top
 

3. Sample Database Connections

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_license_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\\derbyclient.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

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;DB_LOCALE=EN_US.UTF8;CLIENT_LOCALE=EN_US.UTF8;charSet=UTF8

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 = jdbc:oracle: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=demo

top

Copyright DigerTech Inc