Skip to Content
0
Former Member
Feb 25, 2009 at 09:23 AM

Accessing MS Access Database

182 Views

Hi All,

I have some doubts regarding accessing MS Access Database.

I am using JDBC Driver : sun.jdbc.odbc.JdbcOdbcDriver

Connection String : jdbc:odbc:Driver ={Microsoft Access Driver (.mdb)};DBQ=
ABC\Wegsoft.mdb*

1. Do I need to deploy any Driver file in PI Server? if yes then which one?

2. Do I need to define DSN? and where I have to define in PI Server or third party database server?

3. Does driver Microsoft Access Driver (.mdb)* need to be present on PI Server?

4. And what are the other setting I need to do?

Thanks & Regards,

RP