Database Search
If you can't find the information using the categories below, post a question over in our WinBatch Tech Support Forum.
TechHome
ADO DAO
 | |
|
- !!! Simple ADO Example !!!
- !ADO Object Model
- 1255 OLE Member Not Found
- ADO - ADOX requirements
- ADO - DAO Constants
- ADO AD Sort Problem
- ADO and GetObject
- ADO and Large Numbers
- ADO Convert Access data to Tab Delimited Text File
- ADO CreateParameter
- ADO Data Control Constants
- ADO Data Shaping
- ADO Error Issue
- ADO Error Object
- ADO Find vs DAO Seek Access Example
- ADO Jet Order By Clause
- ADO links
- ADO Sample for Stored Procedure
- ADO SaveAs and Excel or Convert Before Closing
- ADO Schemas
- ADO softseek
- ADO SQLOLEDB Example
- ADO Stream Binary File Download
- ADO Stream to Binary Buffer
- ADO with mySQL
- ADOX Append Table Columns
- ADOX Grant Permissions
- ado_seek
- Auto Form For ADO Database Tables
- Auto Generate GUIDs
- Basic Database Dialog Sample
- Beginner ADO Question
- Check Who is Using an MDB
- Close an Active Connection
- Connect to SQL Server 2000 MSDE
- Converting Text String to 4-char Soundex String
- Create Address Book XML File
- Create ADO Get and Put UDFs for Selected Database Table
- Create an AutoIncrement Column in Access
- csv2acc - ADO - CSV-delimited to MDB conversion
- csv2acc2 - ADO - CSV-delimited to MDB conversion2
- DAO CreateTableDef
- Delete All Records from Access Table
- Error 1261 using SetInfo Method
- Extract Column Data Using ADO
- Generic Recordset to Text file UDF
- Get Create_date From SQL Server Table Properties
- Get Extended ADO Connection-Version Info
- Get Result Data of Select Statement
- Get Users Email Address in Active Directory
- GetRows Array Results Explained
- How to Filter Records
- Import Data into My SQL
- Insert Rows From One Database to Another
- Inserting Rows that Contain Apostrophe
- Large Database Query Example
- Learning ADO Conversion to Winbatch
- Lock Database in ADO
- Long Discussion on ADO and Creating a Table
- Microsoft Access Database Engine 2010 Redistributable
- MySQL UDFs
- OLE and DAO Example
- OLE DB Data Link Properties Dialog
- Ole Exception ADODB Recordset
- OLE Exception Connecting to Oracle ODBC Driver
- Ole Exception ParentCatalog ADOX
- Parent-Child Fabricated Recordsets
- Playing around with ADO Schemas
- Problem Getting Record Count via ADO
- Retrieve all user objects in a domain via ADO
- Return a Value from an ADO array
- Samples for creating ADO connections
- Simulate Alter Structure for Persisted XML Recordset
- SQL Server 2005 XML with Winbatch
- SQL Server Blank Password
- SQL Server Update Using ADO
- SQLOLEDB Provider Error
- Stored Procedure with Return Value
- Streaming Recordset To Browser
- Tip - Avoid Duplicate Errors in Bulk INSERTS
- Use ADO to Insert Data From CSV Into Excel
- Use the Datalinks Dialog to insert ADO Connection info into a script
- Very Basic Database - Dialog ADO Sample
- Visual ADO Connection
- Wildcard for SQL LIKE Using ADO
- Write BLOB to MySQL
Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
ADO AD Sort Problem
Question:
I can't seem to figure out how to sort/filter this recordset. When I try to sort or filter I get an error "Current provider does not support the necessary interfaces for sorting or filtering." According to the ADO documentation, these functions should be available. What am I doing wrong?
objConnection = CreateObject("ADODB.Connection")
objConnection.Open("Provider=ADSDSOObject")
objCommand = CreateObject("ADODB.Command")
objCommand.ActiveConnection = objConnection
;change these variables to alter your search
ADPath=""
filter="(&(objectCategory=Person)(objectClass=user)(!userAccountControl:1.2.840.113556.1.4.803:=2))"
fields="samAccountName,mail,employeeNumber,department"
scope="subtree";all children
;scope="onelevel";Immediate children
;scope="base";no subfolders
objCommand.CommandText = strCat(ADPath,";",filter,";",fields,";",scope)
objRecordSet = objCommand.Execute
objRecordSet.sort=("EmployeeNumber")
objConnection.Close
Answer:
Declare a Recordset Object, and set the cursorlocation to adUseClient. The ADO Client Cursor Engine does support the Sort method. Set the CursorLocation property of the ADO recordset object to adUseClient before opening it. Check out the following MS Knowledge base article: http://support.microsoft.com/default.aspx?scid=kb;en-us;253248 Sort sample code: http://msdn.microsoft.com/library/en-us/ado270/htm/mdprosortx.asp?frame=trueArticle ID: W16565
File Created: 2005:02:18:12:21:28
Last Updated: 2005:02:18:12:21:28