O'Reilly logo

MicroStrategy Quick Start Guide by Fernando Carlos Rivero Esqueda

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required