Chapter 9
Using SPD Server With Other
Clients
Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 93
Using Open Database Connectivity (ODBC) to Access SPD Server Tables . . . . . . 94
Why Use ODBC? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 94
Installing OBDC Drivers on the Server . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 95
Configuring ODBC on the Client . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 95
Preparing your Client Machine for ODBC Installation . . . . . . . . . . . . . . . . . . . . . . 96
Two Types of ODBC Connections . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 96
Primary and Secondary LIBNAME Domains . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 97
Configuring an ODBC Data Source to Connect Directly to an SPD Server . . . . . . 97
Configuring an ODBC Data Source for SPD SNET . . . . . . . . . . . . . . . . . . . . . . . . 98
Editing the Services File on Your Machine - ODBC Details . . . . . . . . . . . . . . . . . . 98
Creating a Query Using an ODBC-Compliant Program . . . . . . . . . . . . . . . . . . . . . 99
Using JDBC (Java) to Access SPD Server Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . 99
Why Would I Want to Use JDBC? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 99
How Is JDBC Set Up on the Server? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 100
How Is JDBC Set Up on the Client? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 100
How Do I Use JDBC to Make a Query? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 100
JDBC Code Examples and Tips . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 101
Limitations of Using JDBC with the SPD Server . . . . . . . . . . . . . . . . . . . . . . . . . 102
Using htmSQL to Access SPD Server Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 102
Why Would I Want to Use htmSQL? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 102
How Is htmSQL Set Up on the Server? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 103
How Is htmSQL Set Up on the Client? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 103
How Do I Use htmSQL to Make a Query? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 104
Examples of Setting Up an htmSQL Web Page . . . . . . . . . . . . . . . . . . . . . . . . . . . 104
Using SQL C API to Access SPD Server Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . 104
Why Would I Want to Use SQL C API? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 104
Overview
This chapter describes using SPD Server to connect with ODBC, JDBC, htmSQL, and SQL
C API clients.
Scalable Performance Data Server provides ODBC, JDBC, htmSQL, and SQL C API
access to SPD Server data stores from all supported platforms.
93
