For each database listed below
Line 1 is the JDBC URL and Line 2 is the driver name.
Please email us at contact@infocaptor.com if you see a missing JDBC entry or there is some error in the listing.
Oracle (using SID)
oracle.jdbc.driver.OracleDriver
jdbc:oracle:thin:@<HOST>:<PORT>:<DB>
Oracle (using service)
oracle.jdbc.driver.OracleDriver
jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=<HOST>)(PORT=<PORT>))(ADDRESS=(PROTOCOL=TCP)(HOST=<HOST2>)(PORT=<PORT>))(CONNECT_DATA=(SERVICE_NAME=<service_name>)))
IBM DB2
jdbc:db2://<HOST>:<PORT>/<DB>
COM.ibm.db2.jdbc.app.DB2Driver
JDBC-ODBC Bridge
jdbc:odbc:<DB>
sun.jdbc.odbc.JdbcOdbcDriver
Microsoft SQL Server
jdbc:weblogic:mssqlserver4:<DB>@<HOST>:<PORT>
weblogic.jdbc.mssqlserver4.Driver
PointBase Embedded Server
jdbc:pointbase://embedded[:<PORT>]/<DB>
com.pointbase.jdbc.jdbcUniversalDriver
Cloudscape
jdbc:cloudscape:<DB>
COM.cloudscape.core.JDBCDriver
Cloudscape RMI
jdbc:rmi://<HOST>:<PORT>/jdbc:cloudscape:<DB>
RmiJdbc.RJDriver
Firebird (JCA/JDBC Driver)
jdbc:firebirdsql:[//<HOST>[:<PORT>]/]<DB>
org.firebirdsql.jdbc.FBDriver
IDS Server
jdbc:ids://<HOST>:<PORT>/conn?dsn='<ODBC_DSN_NAME>'
ids.sql.IDSDriver
Informix Dynamic Server
jdbc:informix-sqli://<HOST>:<PORT>/<DB>:INFORMIXSERVER=<SERVER_NAME>
com.informix.jdbc.IfxDriver
InstantDB (v3.13 and earlier)
jdbc:idb:<DB>
jdbc.idbDriver
InstantDB (v3.14 and later)
jdbc:idb:<DB>
org.enhydra.instantdb.jdbc.idbDriver
Interbase (InterClient Driver)
jdbc:interbase://<HOST>/<DB>
interbase.interclient.Driver
Hypersonic SQL (v1.2 and earlier)
jdbc:HypersonicSQL:<DB>
hSql.hDriver
Hypersonic SQL (v1.3 and later)
jdbc:HypersonicSQL:<DB>
org.hsql.jdbcDriver
Microsoft SQL Server (jTDS driver - Preferred)
"jdbc:jtds:sqlserver://<HOST>:<PORT>/<DB>
net.sourceforge.jtds.jdbc.Driver
Microsoft SQL Server 2000 (Microsoft Driver)
jdbc:microsoft:sqlserver://<HOST>:<PORT>[;DatabaseName=<DB>]
com.microsoft.jdbc.sqlserver.SQLServerDriver
MySQL
jdbc:mysql://<HOST>:<PORT>/<DB>
com.mysql.jdbc.Driver
PostgreSQL (v6.5 and earlier)
jdbc:postgresql://<HOST>:<PORT>/<DB>
postgresql.Driver
PostgreSQL (v7.0 and later)
jdbc:postgresql://<HOST>:<PORT>/<DB>
org.postgresql.Driver
Sybase (jConnect 4.2 and earlier)
jdbc:sybase:Tds:<HOST>:<PORT>
com.sybase.jdbc.SybDriver
Sybase (jConnect 5.2)
jdbc:sybase:Tds:<HOST>:<PORT>
com.sybase.jdbc2.jdbc.SybDriver
----------------
Excel and Access using JDBC - ODBC
Microsoft Excel (prior to Excel 2007)
jdbc:odbc:Excel Files;DBQ=<file_path>
sun.jdbc.odbc.JdbcOdbcDriver
Microsoft Excel (new)
jdbc:odbc:Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=<file_path>;DriverID=22;READONLY=true;
sun.jdbc.odbc.JdbcOdbcDriver
Microsoft Access .mdb files (prior to 2007)
jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=<file_path>;DriverID=22;READONLY=true;
sun.jdbc.odbc.JdbcOdbcDriver
Microsoft Access .accdb files (prior to 2007)
jdbc:odbc:Driver={Microsoft Access Driver (*.accdb)};DBQ=<file_path>;DriverID=22;READONLY=true;
sun.jdbc.odbc.JdbcOdbcDriver
Microsoft Access (new)
jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=<file_path>;DriverID=22;READONLY=true;
sun.jdbc.odbc.JdbcOdbcDriver
