mssqlserver.jar, etc.

[Former Member]

hi all,

i know this question has been asked already. i did what the solution for the old posts said. I downloaded sqljdbc_3.0 1301.101_enu (jdbc driver) but i cannot find the necessary jar files. all i can see is sqljdbc.jar. am i missing something? thanks for the replies!

regards,

ix

[Former Member · Accepted solution]

Hi ix,

The sqljdbc*.jar is the JDBC driver for MSSQL server Db. Please check the compatibility of the Driver with the DB version of MSSQL server.

Then, download the correct driver (sqljdbc*.jar) from internet.

You can then add this jar to the "com.sap.aii.adapter.lib.sda" (if you are on PI 7.10 and above version else search on SDN for the jms provider lib.sda which is the correct sda to be edited for earlier versions of PI) and deploy it on your PI Server using JSPM tool available from PI 7.10. (else use SDM tool to deploy for lower versions of PI).

The deployment of this .sda file would trigger a re-start of the PI server. You can then run your DB scenarios smoothly using the mssql driver you just deployed on PI server.

Please take a look at the following link for a sample overview:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/00b4a020-4ae6-2c10-5a95-fed4ad9a4...

I hope this helps.

Regards, Gaurav.

Edited by: Kumar Gaurav on Jan 6, 2011 7:50 AM