Instruction manual

ODBC Driver and Installation

CentreVu®

CMS Open Database Connectivity

Test Desktop Computer Connectivity 2-35

Test Desktop Computer Connectivity 2

Introduction 2

Once you have installed the

OpenLink

ODBC driver software on both the

client and the server, you may open a demonstration connection to a data

source on the server to show connectivity and test SQL access. To

connect to an administered data source, use the following procedure.

Connect to and

Access Data

To connect to a data source from the client, complete the following steps:

1. From the Start button select Programs,

OpenLink

Data Access

Drivers and C++ Demo 32 bit. on your computer.

The ODBC SDK 2.0 C++ Demo window displays.

2. From the Environment menu, select Open Connection. The SQL

Data Sources dialog box displays.

Depending on the ODBC driver version you are using, the Select

Data Source dialog box may display and you will be prompted to

select a file or machine data source.

Select the Machine Data Source tab and select the CMS data

source.

3. Select the data source that you want to use from the list.

The

OpenLink

ODBC login dialog box displays.

This dialog box only displays if you did not check the No Login

Dialog Box check box on the Setup dialog box.

You should have already configured the CMS data source. If you do

not see a data source on the SQL Data Sources dialog box, see

“

Desktop Computer Client Configuration” in this chapter.

4. Enter your CMS server user name and password (CMS server

5. Select OK. You will return to the ODBC SDK 2.0 C++ Demo screen.

6. Select SQL to begin writing your SQL query.

7. Select Execute SQL. The ODBC SDK 2.0 C++ Demo SQL dialog

box displays.

8. Enter the following SQL query in the text box: select count (*) from

hsplit. The queried data displays in the ODBC SDK 2.0 C++ Demo

window; however, any valid SQL query may be entered.

NOTE: