Testing ODBC connectivity

ODBC connectivity is one of two layers of connectivity that are listed in the next table, along with the associated connectivity testing programs. Connectivity should be tested from the bottom up—the network layer first and then the ODBC layer.

Layer	Test with
ODBC driver	Test ODBC mstrtestodbc or mstrtodbcx
Network TCP/IP	Simple Network Layer Testing Tool Ping, PING.EXE, for TCP/IP

The test method described above reflects the situation when the ODBC driver and the database network software are bundled. If they are not bundled, they must be configured and tested separately, using database-specific tools.

Using the DB Query Tool

The MicroStrategy DB Query Tool is available in Windows, and Linux Intelligence Server installations. It is used to test and troubleshoot connectivity to databases, create and execute SQL commands through ODBC, and run scripts.

Before you use the DB Query Tool, test the network layer with the network layer utility, PING.EXE. Consult your operating system or network system documentation for details.

To use the DB Query Tool

1. To use the DB Query Tool:
   • On Windows using the DB Query Tool interface, perform the following step:

     From the Windows Start menu, go to Programs > MicroStrategy Tools > DB Query Tool.

   • On Windows from the command line, perform the following steps:
     1. From the Windows Start menu, select Run.
     2. In the Open drop-down list, type cmd and click OK. A command prompt opens.
     3. Type todbcx.exe and click Enter. Prompts guide you through testing your ODBC connection from the command line and should be used in place of the steps below. For detailed steps on how to use the command line version of this tool, see Testing ODBC connectivity in Configuring MicroStrategy Using Command Line Tools.
   • On Linux using the DB Query Tool interface, perform the following steps:
     1. In a Linux console window, browse to HOME_PATH, where HOME_PATH is the directory that you specified as the home directory during installation.
     2. Browse to the folder bin and type ./mstrdbquerytool, then click Enter.
   • On Linux from the command line, perform the following steps:
     1. In a Linux console window, browse to HOME_PATH, where HOME_PATH is the directory that you specified as the home directory during installation.
     2. Browse to the folder bin and type ./mstrtodbcx, then click Enter. Prompts guide you through testing your ODBC connection from the command line and should be used in place of the steps below. For detailed steps on how to use the command line version of this tool, see Testing ODBC connectivity in Configuring MicroStrategy Using Command Line Tools.
2. From the Session menu, select Open Connection, or click the Connect icon on the toolbar. The Connect dialog box opens. The connection interface varies depending on the destination database.
3. Select the DSN for a data source.
4. Enter the appropriate user name and password.
5. Click Connect. After your connection is opened, the connection string is displayed in the MicroStrategy DB Query Tool at the bottom. Your cursor is inserted automatically in the SQL Statement window.
6. In the SQL Statement window, type a SQL query such as:

select count (*) from Table

where Table is a system-defined table, such as SYSOBJECTS for Microsoft SQL Server or a MicroStrategy-created table such as DSSMDSYSPROP in the MicroStrategy metadata.

7. From the Queries menu, select Execute Query. A table of data from the database is displayed in the Query Result window.
8. From the Session menu, select Close Connection to close the database connection.
9. From the File menu, select Exit.