ODBC set up for MicroStrategy 64 bit I-Server.

ODBC

Open Data Base Connectivity, a standard database access method developed by the SQL Access group. The goal of ODBC is to make it possible to access any data from any application, regardless of which database management system (DBMS) is handling the data.

Why we use ODBC

The Open Database Connectivity (ODBC) standard is a common application programming interface for accessing data files. In other words, ODBC allows you to move data back and forth easily between ODBC compliant applications. So, for example, you can easily extract data from a Microsoft Excel spreadsheet or Paradox database without having to go through any tedious translation procedure. With ODBC, all you have to do is specify the type of file you are accessing and the data you want, and the ODBC driver will do the rest of the work.

Types

There are two types:

32-bit

64-bit

NOTE: MicroStrategy allows only 32-bit drivers. By default Microstrategy has some drivers inbuilt. In some cases we do not find all the drivers. So we should install.

Problem

When we have a 64-bit version of the Microsoft Windows operating system. We should install 64-bit drivers only but Microstrategy supports 32-bit drivers only. So when we install 64-bit drivers odbc does not invoke the drivers.

Solution

To overcome this problem 64-bit ODBC Administrator tool can be invoked from c:/windows/system32/odbca32 to manage user DSNs and system DSNs that are used by 64-bit processes. On a 64-bit operating system, the 32-bit ODBC Administrator tool is used for Windows on Windows 64 (WOW64) processes.