cancel
Showing results for 
Search instead for 
Did you mean: 

Connection to MS Office access database

Former Member
0 Kudos

Hi All,

i am tring to connect to MS access database from PI, can anyone please provide me the connection details that needs to be confiqured in the communication channel to connect to it.

I have created the table in the database , dont know how to connect from PI. Please help .

Thanks,

Hemanth.

Accepted Solutions (1)

Accepted Solutions (1)

sunilchandra007
Active Contributor
0 Kudos

Hi Hemanth,

The connection details are as follows :

JDBC Driver : sun.jdbc.odbc.JdbcOdbcDriver

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

For more details, pls refer to /people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn .

Regards,

Sunil Chandra

Answers (0)