In order to access the
Oracle, MySQL, PostgreSQL, Sybase, DB2 for AS400 or Microsoft SQL Server
database, it is imperative that the corresponding JDBC JAR is present in the
installation directory of the Launcher server.
For instance:
C:\Program Files (x86)\LAUNCHERi\LAUNCHER_CONNECTORS\lnciconnector_lib.
List of official JDBC JARs to use inevitably (no guarantee of operation for any other used JAR):
•
For Oracle databases, you
must use the Thin driver provided by Oracle.
For instance, for Oracle Database 10g Release 2, the JDBC Thin driver is named ojdbc14.jar,
and can be downloaded using the following link:
http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-10201-088211.html
•
For MySQL databases, the JDBC driver mysql-connector-java-5.1.21-bin.jar
has to be used :
http://www.mysql.com/downloads/connector/j/
•
For PostgreSQL databases (≥ version 7.2), the JDBC driver postgresql-9.2-1000.jdbc4.jar
can be downloaded from :
http://jdbc.postgresql.org/download.html
•
For Sybase databases (all Sybase products using
JConnect-7_0: Adaptive Server Enterprise, SQL Anywhere, Sybase IQ, andÂ
Replication Server), the JDBC driver jconn4.jar has to be used :
http://www.sybase.fr/products/allproductsa-z/softwaredeveloperkit/jconnect
•
For Microsoft SQL Server (SQL Server2012, SQL
Server 2008 R2, SQL Server 2008, SQL Server 2005, and SQL Azure), the JDBC
driver sqljdbc4.jar has to be used :
http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774
•
For databases IBM DB2 for iSeries, you must use
the driver jt400.jar supplied with IBM System i Access for Windows.
After installing IBM Access on your PC, you can find the JDBC driver, for
example here:
C:\Program Files (x86)\IBM\Client Access\jt400\lib\jt400.jar
After having installed the JDBC JARs, it is mandatory to relaunch Launcher server.