Windows IT Pro is the leading independent community for IT professionals deploying Microsoft Windows server and client applications and technologies.
  
  
  Advanced Search 


May 06, 2008

Turn On, Tune In, and Disconnect, Part 2

An HTA makes searching the SID database easy
RSS
View this exclusive article with VIP access -- click here to join |
See More Systems Administration Articles Here | Reprints | Or sign up for our VIP Monthly Pass!
SideBar    Using setInterval to Overcome an HTA Shortcoming
Executive Summary:

In "Turn On, Tune In, and Disconnect, Part 1," Jim Turner discussed how to use a VBScript script to create a database that holds SID history information for group and user objects in a domain. This VBScript script also demonstrated how to use disconnected recordsets, which are Microsoft ActiveX Data Objects (ADO) recordsets that reside only in memory. In "Turn On, Tune In, and Disconnect, Part 2," Jim discusses an HTML Application (HTA) that you can use to locate and display records in the SID database. You'll learn how this HTA finds and opens SID databases, and how it filters database records. You'll also learn how the HTA overcomes a common HTA annoyance.


Disconnected recordsets are ActiveX Data Objects (ADO) recordsets that reside only in memory while they're active. Because they're in memory, accessing data within them can be quick and efficient. UpdateSIDdb.vbs demonstrates how to create and use disconnected recordsets. This script creates and updates a low-maintenance database that holds SID history information for group and user objects in a domain. 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. . . .


Already a VIP member?
Please log on to view the full article

Why become a VIP member?

VIP-only online access
VIP CD delivered twice a year: offline access to the entire Windows IT Pro article library
Monthly issue of your choice of Windows IT Pro or SQL Server Magazine

Subscribe Now
Reader Comments

You must be a registered user or online subscriber to comment on this article. Please log on before posting a comment. Are you a new visitor? Register now




Learning Path For additional examples of disconnected recordsets in use, check out
"Keep Your Favorite URLs Handy on the Desktop"

"Gathering File System Data"


For more information about how to create HTAs, read
"How to Learn and Even Master the Art of Writing HTAs"


To read Part 1, go to
"Turn On, Tune In, and Disconnect, Part 1"


Top Viewed ArticlesView all articles
WinInfo Short Takes: Week of November 9, 2009

An often irreverent look at some of the week's other news, including some more Windows 7 sales momentum, some Sophos stupidity, Microsoft's cloud computing self-loathing, more whining from the browser makers, Zoho's "Fake Office," and much, much more ...

Command Prompt Tricks

One reader shares his tip for setting up the command prompt to reflect a remote path. ...

Windows 7 Sets Sales Record

Microsoft CEO Steve Ballmer described Windows 7's first ten days of sales as "fantastic" while in Japan yesterday. ...


Related Articles The Event Log Query Utility

Use an HTA as a UI for Your VBScript Scripts

Hooked on HTAs

Auditing File Ownership

Related Events WinConnections and Microsoft® Exchange Connections

Cutting Costs with Client Management

Introduction to Identity Lifecycle Manager "2"

Check out our list of Free Email Newsletters!

Scripting eBooks Keeping Your Business Safe from Attack: Encryption and Certificate Services

Best Practices for Managing Linux and UNIX Servers

Building an Effective Reporting System

Related Scripting Resources Introducing Left-Brain.com, the online IT bookstore
Looking for books, CDs, toolkits, eBooks? Prime your mind at Left-Brain.com

Discover Windows IT Pro eLearning Series!
Clear & detailed technical information and helpful how-to's, all in our trademark no-nonsense format


Windows IT Pro Home Register FAQ for Windows WinInfo News
Europe Edition About Us Contact Us/Customer Service Media Kit Affiliates / Licensing  
SQL Server Magazine Office & SharePoint Pro DevProConnections IT Job Hound
Left-Brain.com Technology Resource Directory asp.netPRO ITTV Windows SuperSite 
 
 Windows IT Pro is a Division of Penton Media Inc.
 © 2009 Penton Media, Inc. Terms of Use | Privacy Statement