Fetch data from MSAccess

[Former Member]

Hi

PI is installed on Windows and need to fetch data from Ms Access present on remote server.

Please let me know whether any driver need to be installed.

I tried without installing any driver . The parameters provided in channel are

JDBC Driver : jdbc.odbc.JdbcOdbcDriver

Connection : jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=//<FilePath>

But i am getting error as

'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Can not establish connection:: SAPClassNotFoundException: jdbc.odbc.JdbcOdbcDriver'

Please let me know what needs to be done.

[Former Member]

Hi, Sandeep

You need to deploy the drivers on your PI system to do it. Check above response and ask to your basis team to do it.

After that you must configure that in your communication channel:

JDBC driver --> com.microsoft.sqlserver.jdbc.SQLServerDriver

Connection --> jdbc:sqlserver://YOUR_SERVER:YOUR_PORT;DatabaseName=YOUR_DATABASE

Regards,

Carme.

[Former Member]

Hi Sandeep,

You need to deploy the drivers on the PI system . Only then you will be able to connect to the MS Access DB via the JDBC adapter using the corresponding driver. The steps involved are:

1. Check & download the right MS Access driver (drivers are DB version dependent)

2. Edit the .sda file to include the driver classes (.jars)

3. Deploy the edited .sda file on the PI system.

4. Configure the JDBC channel with the right drivers and connection string and you are ready.

The following link might be useful:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/8000cffc-6b92-2d10-3493-f2ac13992...

Hope this helps.

Regards, Gaurav

[Former Member]

Hi All

Thanks for replies.

My PI system is also on windows . As per below forum thread it is said that driver is not required

[PriyankaAnagani]

Hi Sandeep,

You might need to install the jdbc drivers. Please refer the below links also once check with basis team whether they've installed it or not.

http://help.sap.com/saphelp_nwpi711/helpdata/en/48/cafc972fbb5c97e10000000a42189d/frameset.htm

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/8000cffc-6b92-2d10-3493-f2ac13992...

Also refer this

Regards,

Priyanka