Connecting to MS Access Database

STEP 1:
Go to Administer > Connectors > Database Driver.

For v6, go to Develop > Services > Connector > Database Driver


Create a new driver for Access DB.
- Give name and description
- Skip the Upload Jar file step
- Paste the following in the 'Driver Main Class' field: sun.jdbc.odbc.JdbcOdbcDriver

--------------------
STEP 2:

Now go to Administer > Connectors > Database Info

In v6. go to Develop > Services > Connector > Database Info


- give name and description
- select the driver created in the previous step

- In the Server URL field of the DB Info object, manually enter the path of the Access database.
Example:
jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=\\Sfdfs-01\data\Group\actuary\Actdata\data\IBNR\Warehouse\Reference Tables.mdb


Path after DBQ= is a full path of the MDB file. If it is a local database where BPM is running then give the full path starting from the Drive. Such as C:\MyAccessDB.mdb
Thus the URL will be:
jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=C:\MyAccessDB.mdb

User is 'sa' and there is no password.

Have more questions? Submit a request

0 Comments

Article is closed for comments.