Dear expects,

I am facing an error when i trying to connect Ms access Database from SAP PI server.

ERROR :

Error during database connection to the database URL

jdbc:odbc:Driver = {Microsoft Access Driver ( *.accdb)}; DBQ=//10.2.0.171/C:/Inetpub/wwwroot/Atakiit/App_Data/WebAtaS.accdb using the Jdbc driver 'sun.jdbc.odbc,JdbcOdbcDriver' cannot establish connection with the registered server sun.jdbc.odbc.JdbcOdbcDriver returns : (microsoft)(ODBC Driver Manager) data source name not found and no default driver specified. : SQLException : (microsoft)(ODBC Driver Manager) data source name not found and no default driver specified.

-----

I gone through many blogs and showing its not necessary to deploy Jdbc driver in the SAP PI server when its running on Windows.

Kindly request expects to give a better solution for this issue.

Regards,

senthil.