JDBC drivers in PI 7.1X

[former_member379572]

Hello,

Today we are using JDBC 2.0 MS SQL driver in SAP PI 7.1, and this driver not support MS SQL 2012. 

So, I know that I need upgrade for JDBC 4.0 that support MS SQL 2012. 

My question is:

Is it possible install 2 drivers in SAP PI 7.1 , one jdbc 2.0 ms sql  and other jdbc 4.0 ms sql ?

I'm asking it because the jdbc 4.0 ms sql does not support sql 2000 and I'm still using this driver for some old interfaces.

Regards

Wendell

[Private_Member_12188]

If you install the new version in Windows it will overwrite some OS level things that will cause you problems.  You might be able to get away with it be adding the 2.0 drivers directly into PI.  I wrote a article on how to do this with AS\400 drivers (the process works for any JDBC drivers).  You can then change your legacy connections to use the internal JDBC driver for testing.  Assuming that works, then you should be able to install the 4.0 drivers in Windows.

http://scn.sap.com/community/pi-and-soa-middleware/blog/2013/06/24/as400-jdbc-on-pi