Example of using the ADO DSC
This example uses the Northwind database that is provided by Microsoft as part of SQL Server.
1 In Windows Explorer, go to the folder in which the Visual Basic .NET version of DM Query was installed. By default, this is [INSTALL_FOLDER]\IBM\SPSS\DataCollection\7\DDL\Code\Tools\VB.NET\DM Query.
2 Double-click the DM Query.exe file.
This opens the DM Query window and the Connection tab in the Data Link Properties dialog.
3 On the Connection tab, in Case Data Type choose ADO Database (read-only).
4 Click Browse next to the Case Data Location box.
This opens another Data Link Properties dialog.
5 On the Provider tab, select Microsoft OLEDB Provider for SQL Server and then click Next.
6 In "Select or enter a server name" type a period (.) to use SQL Server on the local computer; otherwise, choose the name of the server to be used.
7 Select Use Windows NT Integrated Security.
8 In "Select the database on the server" select Northwind.
9 Click OK to close the dialog and return to the original Data Link Properties dialog.
10 In Case Data Project, type Employees, and then click OK.
This tells ADO DSC to use the Employees table as the VDATA table.
11 On the DM Query window, type a query against VDATA in the SQL box, and then press Enter.
See also