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 


June 06, 2008

Accessing Database Data with ADO


A Web Exclusive from Windows IT Pro
Robert Sheldon
Feature
InstantDoc #99419
Windows IT Pro
Email this Article
Printer Friendly
Reader Comments
Digg This
Del.icio.us
RSS
View this exclusive article with VIP access -- click here to join |
See More SQL Server and Database Articles Here | Reprints | Or sign up for our VIP Monthly Pass!
Executive Summary: Learn how to use Microsoft ActiveX Data Objects (ADO) to access, filter, sort, and retrieve data from Microsoft SQL Server and Microsoft Access databases from VBScript scripts.

 


VBScript applications often access data in Microsoft SQL Server or Microsoft Access databases. An easy way to facilitate that access is to use Microsoft ActiveX Data Objects (ADO). ADO is a set of COM objects that act as an interface between VBScript and the OLE DB provider specific to SQL Server or Access. Even if you don’t use VBScript and ADO in your current scripting projects, existing production scripts might still use VBScript and ADO. COM-based scripting languages are still the primary focus in some organizations, and Microsoft continues to support ADO access in SQL Server 2008 and Access 2007.

By using ADO, you can connect to an instance of SQL Server or to an Access database file, issue an SQL command against database objects, and retrieve and modify data. The ADO objects let you access both types of data sources —SQL Server and Access—in a consistent manner. The primary difference between the two is in how you define the connection string. . . .

Reader Comments

You must log on before posting a comment.

If you don't have a username & password, please register now.




Learning Path Windows IT Pro Resources
"An ADSI Primer, Part 5: Using ADO to Script Fast ADSI Searches"

"ADO Acronyms"

"Use ADO for Easy AD Searches"

"Introduction to ADO"

"Much Ado About ADO"

"Using ADO to Access Excel, Part 1"

"Understanding ADO Search Filters in LDAP Queries"

"Using ADO to Access Excel, Part 2"

"Reading Delimited Files Using ADO"

"Specifying Alternate ADO Credentials"

"ADO: A Data-Centric Object Model"

"In Focus: Guidelines for Working with ADO"


Microsoft Resources
"Using ADO to Query an Excel Spreadsheet"

"ADO API Reference"

"Hey, Scripting Guy!"

"Much ADO About Text Files"
Top Viewed ArticlesView all articles
Understanding File-Size Limits on NTFS and FAT

A general confusion about files sizes on FAT seems to stem from FAT32's file-size limit of 4GB and partition-size limit of 2TB. ...

IE Usage Share Fell in 2008

According to researchers at Net Applications, use of Microsoft's Web browser, Internet Explorer, fell from 74 percent to 68 percent of the market by the end 2008. The main beneficiary of that decline was Mozilla Firefox, which jumped to 21 percent usage ...

The Day the Music Died: First-Gen Zune Devices Failed for One Day Last Week

For the few people in North America who bought a first generation Zune 30 portable media player, December 31, 2008 will be a day that lives in infamy. On that day, all Zune 30 devices fell silent after succumbing to a weird date-related bug. The fix was ...
Related Articles Use ADO for Easy AD Searches

ADO Acronyms

Introduction to ADO

Much Ado About ADO
SQL Server and Database Whitepapers StoreVault SnapManagers for Microsoft Exchange and SQL Server
Related Events Storage Consolidation for Your Microsoft Applications: Reducing Cost and Complexity

Virtualization for Mission-Critical BI with SQL Server

SQL Consolidation: Insights from Customers, Analysts & HP

Check out our list of Free Email Newsletters!
SQL Server and Database eBooks Safeguarding Your Windows Servers

SQL Server Administration for Oracle DBAs

Taking Control: Monitoring the Windows Platform Proactively
Related SQL Server and Database 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.



ADS BY GOOGLE

Job Openings in IT SPONSORED LINKS FEATURED LINKS
Maximize speed, performance and reliablity of your PCs and servers—automatically!
Speed Up Your PC! Try Diskeeper 2008 with InvisiTasking Free Now!

Microsoft Learning Snack - Green IT Through Virtualization
Many organizations face rising operating costs caused by excessive energy consumption. Virtualization and "Green IT" can help cut these costs. Get the information you need to bring Green IT savings to your business.

Order Your Fundamentals CD Today!
Register today for your in-depth copy of one of three Fundamental CDs on the following topics – Exchange, SQL, and SharePoint.

Microsoft Learning Snack - Virtualization With Windows Server 2008
Windows Server 2008 includes virtualization technology that allows many operating systems - including open source - to run on a single host. Come learn the basics of implementing these features.

Microsoft Learning Snack - Virtualization Basics
With virtualization, computing components essentially become on-demand services, freeing each element of a system from the others. This short video explains the needs, benefits, and technologies behind virtualization.


Microsoft Learning Snack - Virtualization Basics
With virtualization, computing components essentially become on-demand services, freeing each element of a system from the others. This short video explains the needs, benefits, and technologies behind virtualization.

Microsoft Learning Snack - Virtualization With Windows Server 2008
Windows Server 2008 includes virtualization technology that allows many operating systems - including open source - to run on a single host. Come learn the basics of implementing these features.

Empower Your Processes with PowerShell 201
Paul Robichaux delves deep into PowerShell how-tos in 3 informative lessons, each followed by live Q&A—all on your own computer! Register today!

Microsoft Learning Snack - Green IT Through Virtualization
Many organizations face rising operating costs caused by excessive energy consumption. Virtualization and "Green IT" can help cut these costs. Get the information you need to bring Green IT savings to your business.

New Release: Windows IT Pro Master CD
13 years of content archives, fast answers with advanced search tools, and full access to WindowsITPro.com—order today!
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 © 2009 Penton Media, Inc., All rights reserved. Terms and Use | Privacy Statement | Reprints and Licensing