Database Exchange > Using MS SQL Server 2000 as a Data Source

Using MS SQL Server 2000 as a Data Source

For SQL Server, tables, views and stored procedures are the objects working with Database Exchange. Once the connection established, the Database Exchange control retrieves the schema and list tables and views on the Data Table list, and stored procedures on the Stored Procedure list. You should select the type of record source you want by using the properties form.

The examples use Northwind, which is an example SQL database normally shipped with MSDE or the full version of SQL Server. The examples illustrate the following:

Using a stored procedure as a record source

Changing parameters of a stored procedure at runtime

Using SQL statements as a record source

Using a table or view as a record source