Read data from MSaccess

[Former Member]

Hi Experts

I have installed my PI system on Solaris. Can you please let me know whether we need to install any driver to read data from MS access .If yes please provide driver.

Or else what needs to be configured on sender jdbc channel for driver to read data from msaccess

Regards

Sandeep

[GabrielSagaya]

Deploy the ojdbc14.jar,msbase.jar, mssqlserver.jar, msutil.jar in the aii_af_jmsproviderlib.sda file

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/70ffd890-0201-0010-708f-d5dad2dfc...

It will work.

[Former Member]

Hi Gabriel

Can you please provide me the jar files

Regards

Sandeep

[Former Member]

Hi Gabriel

The drivers suggested by you ojdbc14.jar,msbase.jar, mssqlserver.jar, msutil.jar are of Oracle & MS which works only on Windows OS

Will these drivers work on Solaris OS?

Please help as i have the same requirement as that of Sandeep where my PI is installed on Solaris OS and i need to connect to MS access DB.

[Former Member]

Hi,

> I have installed my PI system on Solaris. Can you please let me know whether we need to install any driver to read data from MS access .If yes please provide driver.

> Or else what needs to be configured on sender jdbc channel for driver to read data from msaccess

If MS Access is in the same system (where PI is installed) then no need to install the MS Access drivers. There is a standard path that is

JDBC Driver: sun.jdbc.odbc.JdbcOdbcDriver

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

Here <<DB_Path>> Means where the DB is stored in the server.

FYR

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/2590

Regards,

Venkata Ramesh

[Former Member]

Hi Venkata

I did but i am getting error as class not found exception

Regards

Sandeep

[Former Member]

Here all the letters are case sensitive, PI and MS Access are in same server/system.

When you are creating the table in MS Access then create that table without using Primary key and try.

Where you are getting the error, at com channel?

Regards,

Venkata Ramesh

[Former Member]

Hi

yes i am getting error in communication channel. The Ms access file is on another server its not on PI server.I think that doesn't make any difference

Regards

Sandeep

[Former Member]

> yes i am getting error in communication channel. The Ms access file is on another server its not on PI server.I think that doesn't make any difference

In the connection path we have to give the MS Access database path (After we create the MS Access database we can save in some where like C:\Documents and Settings\name\Desktop so the PI server searches for this path in the same system/server.

Below link may be useful to you

http://forums.sdn.sap.com/thread.jspa?threadID=71136

Regards,

Venkata Ramesh

[Former Member]

Hi Sandeep,

for database, SAP does not provide the drivers as it's a non-SAP product. You have to get them from your supplier: MSAccess.

Then by reading SAP help, you will know exactly where and how to deploy these drivers to your SAP PI server: [http://help.sap.com/saphelp_nwpi711/helpdata/en/22/b4d13b633f7748b4d34f3191529946/content.htm], see chapter "prerequisite".

On SDN, by using search button you will find plenty of docs, blogs, etc.. on the same subject: JDBC adapter.

Regards.

Mickael