DB2 Connectivity

• Jim

  SSCrazy Eights

  Points: 8720

  More actions

  February 23, 2010 at 8:54 am

  #217246

  We have a DB2 database we need to connect to. One of our developers thinks we should use the JDBC drivers but that would require installing JRE on the SQL Server box.

  I have always heard that presents a significant security and reliability problem. Thoughts?

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  February 23, 2010 at 9:53 am

  #1123731

  Go with OLEDB, forget about JDBC.

  I'm using Hit Software OLEDB driver, quite expensive but works well.

  -- Gianluca Sartori

• Jim

  SSCrazy Eights

  Points: 8720

  More actions

  February 23, 2010 at 11:25 am

  #1123779

  Our DB2 DBA team has OLEDB disabled and only allows JDBC connections. They say that using JDBC only provides better performance.