JDBC Driver in PO single stack

[Former Member]

Where will the drivers be installed in single stack PO?

Where do I check to see if they are installed correctly?

I am getting errors and I want to check version of drivers installed is correct or not

[vicky20691 · Accepted solution]

Hi Midhun,

It goes in usr/sap/<systemname>/<java instance>/cluster/bin/ext

you can directly check this in NWA

Go to NWA->Configuration->Infrastructure-> Java Class Loader Overview

then search for com.sap.aii.adapter.lib under that "Resources"

You must find the jar/driver you deployed

Regards,

Vikas

[Former Member · Accepted solution]

Hi Vkas,

I see sqljdbc4.jar there.

This is Microsoft JDBC Driver 4.0 for SQL Server.

The sql version of the database is SQL Version, release 2.0.

Should they match?

Is this the right version of driver I need?

[vicky20691 · Accepted solution]

HI,

don't think so Midhun, because backward compatibility is always there.

And also the deployment is done by taking jar file from sql installation folder only not from any other source. There must be a folder "lib" in SQL installation folder in "program files" (if you use windows).

You can check the jar file in that folder. if there u have sqljdbc4 then this is the correct driver. else you can ofcourse redeploy with that jar file which is in the "lib" folder".

Hope it helps you now.

Regards,

Vikas

[Former Member · Accepted solution]

Vikas,

thanks for help

One more question, where should I check folder. In the PI server machine?

[Former Member · Accepted solution]

Hi Midhun,

As mentioned correctly by Vikas,

in the SQL installation folder, which will be definitely on the SQL server.

Regards,

Alka

[vicky20691 · Accepted solution]

Hi Midhun,

the machine on which sql server is installed.

c:/program files/Microsoft/..... so on lib folder

Regards,
Vikas