Windows IT Pro is the authoritative and independent resource for windows nt, windows 2000, windows 2003, windows xp. Features a collection of resources and magazines for windows IT professionals.
  
  
  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. . . .

Reader Comments

You must log on before posting a comment.

If you don't have a username & password, please 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
Command Prompt Tricks

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

Microsoft Touts Xbox 360 'Black Friday' Success

Microsoft this week revealed that its Xbox 360 video game console outsold its Sony PlayStation 3 rival 3-to-1 on "Black Friday," which curiously describes the three day weekend after Thanksgiving, a period that unofficially kicks off the holiday selling ...

How can I stop and start services from the command line?

...


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 SQL Server 2008 – Can You Wait? | Philadelphia

SQL Server 2008 – Can You Wait? | Atlanta

SQL Server 2008 – Can You Wait? | Chicago

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 Become a VIP member of the Windows IT Pro community!
Get it all with the VIP CD and VIP access. A $500+ value for only $279!

Subscribe to Windows IT Pro!
Solve your toughest technical problems with our experts and access 10,000 + articles online. 30% off

Monthly Online Pass - Only $5.95!
Get instant access to 10,000+ articles from Windows IT Pro Magazine!

TechNet Virtual Labs
Evaluate and test Microsoft's newest products.


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 Windows Dev Pro IT Job Hound ITTV
IT Library Technology Resource Directory Connected Home Windows Excavator Windows SuperSite 
 
 Windows IT Pro is a Division of Penton Media Inc.
 Copyright © 2008 Penton Media, Inc., All rights reserved. Terms and Use | Privacy Statement | Reprints and Licensing