FIX: Incorrect Results Using Distinct Keyword with Recordset DTC

MORE INFORMATION

Steps to Reproduce Behavior

The following steps require a data connection to SQL Server's PUBS database:

1. Create a new Active Server Pages (ASP) page.
2. Drag a Recordset DTC from the Design-Time Controls toolbox onto the page below the <BODY> tag. Right-click it, and open its Property page.
3. In the General tab, set its Connection property to the PUBS data connection.
4. Set the radio button in the "Source of Data" group box to the SQL Statement option.
5. In the area below the SQL Statement button, type the following:

   Select DISTINCT title_id from titleauthor

6. Close the Property page.
7. Drag a grid to the page.
8. Right-click and open its Property page. On the Data tab, set the Recordset property to the recordset on the page (usually Recordset1). In the Available Fields, choose the title_id field.
9. Click OK to close the Property page.
10. Save the page and preview it in the browser.

A grid will appear and contain 25 total records across two pages. (The default records per page is 20 for the grid. The grid should show 20 records on the first page, and 5 on the next page).

However, when running the same query in SQL Server's ISQL_w, or by changing the Recordset DTC's curor location to "server-side" the following correct results are returned (this is from ISQL_w):

   title_id
   --------
   BU1032
   BU1111
   BU2075
   BU7832
   MC2222
   MC3021
   PC1035
   PC8888
   PC9999
   PS1372
   PS2091
   PS2106
   PS3333
   PS7777
   TC3218
   TC4203
   TC7777

   (17 row(s) affected)