MSSQL JDBC 2.0 driver configuration

[Former Member]

Hi ALL

I am using PI7.0 with database MSQL 2005

for JDBC scenario i have downloaded MSSQL JDBC 2.0 driver from microsoft website

But as per the deployement guides available on SDN and help section , i have to add files

msbase.jar,mssqlserver.jar and msutility.jar to aii_af_jmsprovider.sda

but i cant see anyone of the three file inside the downloaded driver.

downloaded Driver path is

http://www.microsoft.com/downloads/details.aspx?FamilyID=f914793a-6fb4-475f-9537-b8fcb776befd&Displa...

Is there different procedure to install MSSQL JDBC2.0 driver?

or have i downloaded the wrong driver?

If any JDBC driver is already deployed on XI server then How to confirm that driver is installed and which version?

Thanks

Sandeep Sharma

Edited by: sandeep sharma on Jan 23, 2009 10:49 AM

[Former Member · Accepted solution]

Hi Sandeep,

Below I provide info about installation drivers for JDBC & JMS adapters

FIRST: drivertool you can find at https://www.sdn.sap.com/irj/sdn/howtoguides

Then Exchange Infrastructure How-to Guides for SAP NetWeaver 2004 How to Install and Configure External Drivers for JDBC & JMS AdaptersDownload attached system files (ZIP 16KB)

SECOND:

New version of installation guiade:

External Driver Configuration for Process Integration 7.0

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/60237e74-ef19-2b10-5a9b-b35cc6a2...

BR,

Dzmirty

[Former Member]

I don't remember know where and when i got this soft so I've send drivertool to mail which mention in your business cards.

BR,

Dzmitry

[Former Member]

Hello,

I have installed JDBC driver for MSSQL 2005 on my project for this purpose i use "Microsoft SQL Server 2005 JDBC Driver 1.2" and installation guide "How to install and configure external drivers for the JDBC and JMS adapters" https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f04ce027-934d-2a10-5a8f-fa0b1ed4...

BR,

Dzmitry

[Former Member]

Hi Dzmitry Novik

Thanks for reply

JDBC 1.2 have bug and then need to install hotfix

after 1.2 version , in feb 2008 there comes new version JDBC 2.0 , i want to install that.

any help?

Regards

sandeep

[Former Member]

Hi Dzmitry Novik

i can see only the guide on this link but how can i download the tool with this guide ?

Thanks

sandeep