23.8.07

Missing ODBC connection strings?

Here is a cool site for instructing how to define OCBC connection strings for different data sources:

http://www.connectionstrings.com

Oracle BAM 10.1.3 External Data Source and Access DB

When preparing for a BAM demo I needed to show information from BAM external data source (MS Access sample database Northwind). Manual only described how to configure Oracle Database, but didn't give a sample how to configure Access DB.

After a while of tweaking out the configuration I got Access DB set up as an external data source. The key is to define following values as a sample:

Driver: Microsoft Access Driver (*.mdb)

Connection string: Dbq=d:\demodb\Nwind.mdb;