Introduction

This chapter details using SQL Direct with Microsoft SQL Server.

Note
You can use PDMS Provider from many clients, for example Excel, or clients using Microsoft Active Data Object (ADO) technology, without the involvement of SQL Server. Using SQL Direct - Some Examples details some of these methods of use.

However if you want to make more sophisticated SQL queries against the PDMS tables, or if you want to join PDMS rowsets with data obtained from other providers, SQL Direct requires SQL Server to do the SQL processing involved.