XCLN: SELECT Statement Containing ORDER BY "DAV:href" Not Supported (255586)

MORE INFORMATION

Code Sample to Reproduce the Problem

'make a reference to Microsoft ActiveX Data Objects 2.5 Library and
'Active DS Type Library

Private Sub OrderByHref_Click()
    Dim Info As New ADSystemInfo
    Dim sDomainName As String
    Dim sUserName As String

    Dim sURL As String
    Dim sSQL As String
    Dim Rs As New ADODB.Recordset
    Dim Rec As New ADODB.Record
    
    sDomainName = Info.DomainDNSName
    sUserName = "UserName"
    
    sURL = "file://./backofficestorage/" & sDomainName & "/MBX/" & sUserName & "/Inbox"
    
    Rec.Open sURL
    
    ' use default shallow traversal 
    sSQL = "Select "
    sSQL = sSQL & " ""DAV:displayname"" "
    sSQL = sSQL & ", ""DAV:href"" "
    sSQL = sSQL & " from """ & sURL & """ "
    sSQL = sSQL & "order by ""DAV:href"" "
    
    Rs.Open sSQL, Rec.ActiveConnection
    
    If Not Rs.EOF Then
        Rs.MoveFirst
    End If
    
    While Not Rs.EOF
        Debug.Print Rs.Fields("DAV:displayname").Value
        Rs.MoveNext
    Wend
    Rs.Close
    Rec.Close
End Sub