Accessing MS Access Database 2010 from Sender JDBC in PI 7.3

[Former Member]

Hi All ,

We are trying to access a MS Access(2010) db file i.e test.accdb file from Sender JDBC Adapter .

We are placing the file in PI Local server

We are giving the path in connection(In Sender JDBC Adapter) as below

jdbc:odbc:Driver={Microsoft Access Driver (*.accdb)};DBQ=//PIServerdetails/folder/PI/JDBC/test.accdb

But we are not able to access the file

We are getting the following error in channel

Error during database connection to the database URL 'jdbc:odbc:Driver={Microsoft Access Driver (*.accdb)};DBQ=//PIServerdetails/folder/PI/JDBC/test.accdb 'using the JDBC driver 'sun.jdbc.odbc.JdbcOdbcDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection with the registered driver. sun.jdbc.odbc.JdbcOdbcDriver returns: [unixODBC][Driver Manager]Data source name not found, and no default driver specified. : SQLException: [unixODBC][Driver Manager]Data source name not found, and no default driver specified'

Could any one please let us know how to proceed with the issue

Thanks

Swathi

[Bhargavakrishna · Accepted solution]

Hi Swathi,

There is some problem with the drivers.. also check is there any firewalls..

Refer below links

http://scn.sap.com/people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-...

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

http://scn.sap.com/thread/1285628

http://scn.sap.com/message/6398135

Hope it will helpful..

Regards

Bhargava krishna

[Former Member · Accepted solution]

Hi Bhargav

MY PI Server in an unix server....how should i check whether the driver for MS Access is installed or not??because am getting error as below

sun.jdbc.odbc.JdbcOdbcDriver returns: [unixODBC][Driver Manager]Data source name not found, and no default driver specified. : SQLException: [unixODBC][Driver Manager]Data source name not found, and no default driver specified'

Thnks

Swathi

[Bhargavakrishna · Accepted solution]

Hi Swathi,

we have to install the correct version to establish connection to the database. so check the D.B version and download the drivers which is supported by that version..

Inform basis team, to look into that, pi developer is not responsible for that..

Link for JDBC drivers (MS-Access DB)

http://www.easysoft.com/applications/microsoft-access/jdbc-odbc.html

For deploying JDBC drivers

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

For Driver not found issues

http://scn.sap.com/community/pi-and-soa-middleware/blog/2012/07/06/connecting-sap-pi-to-ms-access-an...

Hope it will helpful..

Regards

Bhargava krishna

[allamudi_loordh]

Hi ,

Have you deployed the JDBC drivers ?

you can try check with this as well.

http://host:port/ftp-jdbc  --> connection test.

Regards,

Loordh

[Former Member]

Hi swathi

Looks like somthing wrong with the connections string. pls double check the CC parameters

Rgds

Krishna

[Former Member]

Hi Swathi,

Try with file extension testaccdb.mdb ( Microsoft database ) in

jdbc:odbc:Driver={Microsoft Access Driver (*.accdb)};DBQ=//PIServerdetails/folder/PI/JDBC/test.accdb

make sure same DB should be created in in your system.

go through below link in detail reference.

http://www.sappi.sapag.co.in/jdbc2-jdbc-sap-xi-senario/jdbc-2-jdbc-step-by-step-guide/

Thanks ,

Naga