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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.