Exercise – Establish connectivity to a new database

In this exercise, you will establish connectivity to a new Microsoft Access database, creating a Database Instance, Database Connection, and Database Login:

You will need Microsoft Access installed to create a new database.
  1. Create a new Microsoft Access database. Add a dummy table. Name both the database and the table Chapter7.
If you don't know how to create a MS Access database, simply right-click on the Data Explorer in the machine where it is installed | New | Microsoft Access Database.
  1. For this exercise, we will use an MS Access 2000 file with the *.mdb. If your machine has an MS Access driver for .accdb, you can use such a file. We will learn in the following step how to add a DSN ...

Get MicroStrategy Quick Start Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.