Jdbc Odbc Bridge Driver For Windows 7 32 Bit Free Download

Posted on
  1. Jdbc Odbc Bridge Driver For Windows 7 32 Bit Free Download

Question

  1. Download ojdbc14.jar. Ojdbc14/ojdbc14.jar.zip( 1,454 k) The download jar file contains the following class files or Java source files. META-INF/MANIFEST.MF oracle.
  2. Progress DataDirect offers a Powerful JDBC-ODBC Bridge. You can read more about their solution in this overview document to understand more about why you need such a bridge. You should also read this blog: JDBC-ODBC Bridge Replacement Yields 310%.

For Tableau Bridge, use the same drivers as Tableau Desktop. Under ODBC and JDBC Drivers, select the ODBC driver download for your environment (Hive or Impala). Click the Download link and install the Windows 32-bit Microsoft SQL Server driver for Tableau Server.

Which JDBC driver (JCC) version corresponds with each DB2 release and Fix Pack level?

Jdbc Odbc Bridge Driver For Windows 7 32 Bit Free Download

Answer

The IBM Data Server Driver for JDBC and SQLJ package includes two JDBC drivers:

  • db2jcc.jar - This driver is based on the JDBC 3 specification
  • db2jcc4.jar - This driver is based on the JDBC 4 or later specifications

The db2jcc.jar driver is now deprecated. After version 3.72, which is delivered with DB2 Version 11.1 for Linux, UNIX, and Windows Mod 1 Fix Pack 1, db2jcc.jar will include no new features. However, fixes will continue to be delivered.

DB2 Level
JDBC APAR List
Size (bytes)
v11.5 FP0 (GA)4.26.146,550,443

DB2 Level
JDBC 4.0 Driver (db2jcc4.jar)
Driver version
Driver version
v11.1 FP0 (GA)3.71.223,657,9904.21.293,894,263
v11.1 M1 FP13.72.243,668,6264.22.293,905,812V11.1 M1 FP1
v11.1 M1 FP1 iFix13.72.243,668,6264.22.293,905,812NA
v11.1 M2 FP23.72.303,671,1024.23.423,924,511V11.1 M2 FP2
v11.1 M2 FP2 iFix13.72.303,671,1024.23.423,924,511NA
v11.1 M3 FP33.72.443,813,6414.24.924,234,170
v11.1 M4 FP43.72.523,813,9314.25.134,239,628V11.1 M4 FP4
v11.1 M4 FP4 iFix13.72.523,813,9314.25.13014,239,596V11.1 M4 FP4 iFix 1
DB2 Level
JDBC 4.0 Driver (db2jcc4.jar)
Driver version
Driver version
v10.5 FP0 (GA)3.66.463,656,1054.16.533,866,524
v10.5 FP13.66.463,656,1054.16.533,866,524v10.5 FP1
v10.5 FP23.67.263,669,2344.17.283,880,767v10.5 FP2
v10.5 FP33.67.273,670,7074.17.293,882,031v10.5 FP3
v10.5 FP43.68.613,618,7584.18.603,838,131v10.5 FP4
v10.5 FP53.69.243,214,1714.19.263,411,524v10.5 FP5
v10.5 FP63.69.243,214,1714.19.263,411,524v10.5 FP6
v10.5 FP73.69.493,235,1294.19.493,433,725v10.5 FP7
v10.5 FP83.69.663,632,5014.19.663,853,921v10.5 FP8
v10.5 FP93.69.713,636,3864.19.724,022,185v10.5 FP9
v10.5 FP103.69.763,772,5834.19.774,022,817
DB2 Level
JDBC 4.0 Driver (db2jcc4.jar)
Driver version
Driver version
v10.1 FP0 (GA)3.63.12335163754.13.1273714904Not Applicable
v10.1 FP13.64.10436000474.14.1113801427v10.1 FP1
v10.1 FP23.65.7736114234.15.823816252v10.1 FP2
v10.1 FP33.65.9735373654.15.1003743487v10.1 FP3
v10.1 FP43.65.11035393004.15.1133745518v10.1 FP4
v10.1 FP53.65.13135412344.15.1343747996v10.1 FP5
v10.1 FP63.65.13731603034.15.1463347772v10.1 FP6
DB2 Level
JDBC 4.0 Driver (db2jcc4.jar)
Driver version
Driver version
v9.7 FP0 (GA)3.57.8231467164.7.853312885
v9.7 FP13.58.8232266204.8.873395609v9.7 FP1
v9.7 FP23.59.8132959504.9.783472296v9.7 FP2
v9.7 FP33.61.6533480304.11.693527921v9.7 FP3
v9.7 FP3a3.61.7533486814.11.773528544v9.7 FP3
v9.7 FP43.62.5634111914.12.553593832v9.7 FP4
v9.7 FP53.63.7535027594.13.803700005v9.7 FP5
v9.7 FP63.64.8235955734.14.883796846v9.7 FP6
v9.7 FP73.64.10636000604.14.1133801439v9.7 FP7
v9.7 FP83.64.11436004634.14.1223801792v9.7 FP8
v9.7 FP93.64.13336085974.14.1373810635v9.7 FP9
v9.7 FP103.64.13336085974.14.1373810635v9.7 FP10
v9.7 FP113.64.14136114424.14.1463813730v9.7 FP11

NOTE: There were no new JDBC APARS for 9.7 Fix Pack 10

DB2 Level
JDBC 4.0 Driver (db2jcc4.jar)
Driver version
Driver version
v9.5 FP0 (GA)3.50.15228337244.0.1002939868
v9.5 FP13.51.9028752474.1.852983662v9.5 FP1
v9.5 FP23.52.9530186244.2.733130687v9.5 FP2
v9.5 FP2a3.52.9530186244.2.733130687v9.5 FP2
v9.5 FP33.53.7030599354.3.853218291v9.5 FP3
v9.5 FP3a3.53.7030599354.3.853218291v9.5 FP3
v9.5 FP3b3.53.7030599354.3.853218291v9.5 FP3
v9.5 FP43.53.9530848724.3.1113242907v9.5 FP4
v9.5 FP53.57.11031489844.7.1123314848v9.5 FP5
v9.5 FP6a3.59.8132959504.9.783472296v9.5 FP6
v9.5 FP73.61.8633500974.11.883530073v9.5 FP7
v9.5 FP83.62.5734115914.12.563594358v9.5 FP8
v9.5 FP93.62.5734115914.12.563594358v9.5 FP9
v9.5 FP103.64.9635979764.14.1033799278v9.5 FP10
DB2 Level
JDBC APAR List
Driver versionSize (Bytes)
v9.1 FP0 (GA)3.1.571973658
v9.1 FP13.2.491997894v9.1 FP1
v9.1 FP23.3.542011601v9.1 FP2
v9.1 FP33.4.652063122v9.1 FP3
v9.1 FP3a3.4.652063122v9.1 FP3
v9.1 FP43.6.602096050v9.1 FP4
v9.1 FP53.7.732120684v9.1 FP5
v9.1 FP63.8.352125577v9.1 FP6
v9.1 FP73.8.472109253v9.1 FP7
v9.1 FP83.8.622113391v9.1 FP8
v9.1 FP93.8.702113627v9.1 FP9
v9.1 FP103.8.802115146v9.1 FP10
v9.1 FP113.8.852115528v9.1 FP11
v9.1 FP123.8.882115537v9.1 FP12
DB2 Level
JDBC 3.0 driver
Driver versionSize
v8.1 FP0 (GA)s0210231.0.581663346
v8.1 FP1s0301301.2.34798931
v8.1 FP2s0305081.2.117845603
v8.1 FP3s0307281.3.70872718
v8.1 FP4as0401221.5.54900501
v8.1 FP5s0402121.9.231017444
v8.1 FP6s0406162.2.491058458
v8.1 FP6as0409142.2.491058458
v8.1 FP6cOD_140732.2.491058458
v8.1 FP7s0408122.3.631075286
v8.1 FP7bOD_140802.3.631075286
v8.1 FP8s0412212.5.331080551
v8.1 FP8aOD_140812.5.331080551
v8.1 FP9s0504222.6.801124512
v8.1 FP9aOD_140862.6.801124512
v8.1 FP10s0508112.7.581145514
v8.1 FP11s0601202.8.461191149
v8.1 FP12s0604292.9.311201760
v8.1 FP13s0608012.10.271209104
v8.1 FP14s0611082.10.521212904
v8.1 FP15s0707202.10.721216068
v8.1 FP16s0801112.11.241257312
v8.1 FP17s0808132.11.651266347
v8.1 FP17as0808132.11.651266347
v8.1 FP18s0907152.11.941269358
Free


NOTES:
Download the driver you need by visiting the DB2 Fix Packs by Version page or the IBM Data Server Client Packages fix pack page, which contain links to all available Fix Packs
The following command will retrieve the JCC driver version if executed from the command line:

    • java com.ibm.db2.jcc.DB2Jcc -version


Or for drivers that are not yet installed:

    • java -cp ./db2jcc.jar com.ibm.db2.jcc.DB2Jcc -version


The 'Build Number' indicates the date the driver was compiled and can be used to determine the drivers age. The build number naming convention is sYYMMDD, where YY is the year, MM is the month, and DD is the day.
JDK/JRE 1.8 support first included with JDBC drivers bundled with v10.5 FP7.


For further discussion on this topic, visit this developerWorks forum thread:
https://www.ibm.com/developerworks/community/forums/html/topic?id=657d4182-257b-45dc-8a68-00cb2fa260dc

Related information

Knowledge Collection: JDBC driver
Cross reference information
ProductComponentPlatformVersionEdition
IBM Data Server Client PackagesAIX, HP-UX, Linux, Solaris, Windows10.1, 9.7, 9.5, 9.1
DB2 ConnectAIX, HP-UX, Linux, Solaris, Windows9.7, 9.5, 9.1, 10.1