ActiveX Data Objects (ADO)
|
100 results found, displaying items 1 - 20
|
|
[October 14, 2008]
|
 |
Whip Script Data Into Shape
Two simple functions let WSH scripts export dictionary data to an XML file and read it back with no extra work.
Windows IT Pro
—
Alex K. Angelopoulos
|
[September 24, 2008]
|
|
Build Directory Tree Structure Reports
Documenting your directory structure provides insight about how your applications and server drives are built and where key components reside.
Windows IT Pro
—
Jim Turner
|
[September 5, 2008]
|
|
Data Manipulation with ADO
ActiveX Data Objects (ADO) let you access, filter, sort, and retrieve data from Microsoft SQL Server and Microsoft Access databases using VBScript and other scripting languages. Here are some of the most common uses of ADO for databases.
Windows IT Pro
—
Robert Sheldon
The ABCs of ADO
Here's what you need to know to start using ActiveX Data Objects (ADO) in VBScript scripts to interact with a variety of data sources.
Windows IT Pro
—
Karen Bemowski
|
[July 16, 2008]
|
|
Reading Delimited Files Using ADO
Find out how to set up ADO and Microsoft's Jet OLE DB text driver so that you can use them to read delimited files.
Windows IT Pro
—
Bill Stewart
|
[July 2, 2008]
|
|
Using ADO to Access Excel, Part 2
ADO lets you access your spreadsheets as databases that you can query, sort, search, and modify.
Windows IT Pro
—
Jim Turner
|
[June 25, 2008]
|
|
Using ADO to Access Excel, Part 1
Use a sample VBScript file to see how you can access Excel spreadsheets with ADO, to filter and modify your data.
Windows IT Pro
—
Jim Turner
|
[June 6, 2008]
|
|
Accessing Database Data with ADO
Windows IT Pro
—
Robert Sheldon
|
[June 4, 2008]
|
|
Specifying Alternate ADO Credentials
To change ADO's default user credentials when searching AD, you need to configure the Command object’s User ID, Password, and Encrypt Password properties.
Windows IT Pro
—
Bill Stewart
|
[June 4, 2008]
|
|
Use ADO for Easy AD Searches
Organizing user accounts using AD can make your IT structure more manageable and flexible, but will also result in arduous account searches. Using ActiveX Data Objects (ADO) scripts to search AD will simplify your searches and help you find what you need.
Windows IT Pro
—
Bill Stewart
Introduction to ADO
Windows IT Pro
—
Robert Sheldon
|
[May 14, 2008]
|
|
Introduction to ADO
Learn about the primary ADO objects--Connection, Command, Parameter, Recordset, and Field--and follow example scripts that demonstrate how to use ADO within VBScript.
Windows IT Pro
—
Robert Sheldon
|
[May 14, 2008]
|
|
ADO Acronyms
Learn the definitions for several basic ADO acronyms.
Windows IT Pro
—
Robert Sheldon
|
[May 7, 2008]
|
|
ADO Series Begins This Month
If you conduct a search on the Scripting Pro VIP Web site, you'll run across a lot of articles that discuss scripts in which ADO is used but few articles that explain how to use it. That's about to change.
Windows IT Pro
—
Karen Bemowski
|
[May 6, 2008]
|
|
Turn On, Tune In, and Disconnect, Part 2
SIDFinderLite.hta is a utility you can run to find and display records in any SID database that UpdateSIDdb.vbs creates.
Windows IT Pro
—
Jim Turner
|
[April 23, 2008]
|
|
Turn On, Tune In, and Disconnect, Part 1
Maintaining a SID database can come in handy when you need to retrieve a user's or group's ID but you have only a SID.
Windows IT Pro
—
Jim Turner
|
[February 13, 2008]
|
|
Finding Stale Accounts in Active Directory
StaleAccounts.js, a new tool written in JScript, makes finding stale accounts in Active Directory (AD) easy. It searches using the lastLogon, lastLogonTimestamp, or pwdLastSet attributes, and it can look for either user or computer objects.
Windows IT Pro
—
Bill Stewart
|
[November 7, 2007]
|
|
Much Ado About ADO
Not much has been written about ActiveX Data Objects (ADO) compared with how much coverage other technologies such as Windows Management Instrumentation (WMI) and Active Directory Service Interfaces (ADSI) have received. That's about to change.
Windows IT Pro
—
Karen Bemowski
Script Inventories Remote Computers and Writes the Information to a Database
If you often need inventory information about the remote computers you manage, check out Computer_Inventory.vbs. With this script, all you need to do is create an input file, run the script, then query the database that the script creates.
Windows IT Pro
—
Readers
|
[August 8, 2007]
|
|
Don't Let Your AD Scripts Hang on You
Getting a script to process all the machines in an AD domain is a challenging task, especially when it includes numerous machines. ScriptTemplate.vbs can give you a better chance of successfully automating a task on all the servers in an AD domain.
Windows IT Pro
—
Chang Lu
|
|
Register
