How to Connect MsAccess database .accdb in Pega Robotics (OpenSpan)
Hi,
I have tried to connect to an access database in the format of .accdb, and can simply not get it to work.
I tried to convert to .mdb as a test, which works fine. However, my requirement is to use .accdb database.
All my future processes, which use a database will be using .accdb.
How do I connect to .accdb format, can I add more drivers?
Related question, which I also tried to follow but only .mdb works:
https://collaborate.pega.com/question/how-connect-msaccess-data-base-word-openspan
Accepted Solution
Pegasystems Inc.
US
The drivers are installed on your computer outside of Pega Robotics. Once you have created an ODBC connection to it, you should be able to use the SQLComponent to connect to it. I would search the web for instructions on creating an ODBC connection to an accdb file.