Executive Summary: You can use ActiveX Data Objects (ADO) to manipulate Microsoft SQL Server and Microsoft Access data. You can run action queries such as INSERT, UPDATE, and DELETE statements, call stored procedures, use ADO recordsets to modify data,. insert XML and binary data into SQL Server and Access databases, handle ADO errors, and define transactions.
ActiveX Data Objects (ADO) is a set of COM objects that provide an interface between VBScript (as well as other programming languages) and the OLE DB provider specific to Microsoft SQL Server or Microsoft Access. In "Accessing Database Data with ADO" (InstantDoc ID 99419), I provided an overview of the ADO object model and explained how to use the ADO objects to retrieve data. In this article, I describe how to use ADO to manipulate SQL Server and Access data. You’ll learn how to run action queries such as INSERT, UPDATE, and DELETE statements, call stored procedures, and use ADO recordsets to modify data. You’ll also learn how to insert XML and binary data into SQL Server and Access databases, handle ADO errors, and define transactions.
You should be knowledgeable about VBScript and familiar with general database concepts. In addition, if you don’t know how to use ADO to retrieve data, be sure to read "Accessing Database Data with ADO" first. You can also refer to the ADO API Reference at MSDN for specific details about the ADO objects and their methods and properties. . . .
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
It's official: Google will compete head-to-head with Microsoft's dominant Windows OS with a new system called Google Chrome OS. Based on the Google Chrome browser and not its previous OS effort, the smart phone-based Android system, Google Chrome OS will ...
How Thin-Client Virtual Desktops Can Improve ROI Read this Essential Guide to get a technical overview of VDI and understand what you need to consider when planning for desktop virtualization.
New from Left-Brain.com - Exchange Server 2007 Training Package This intensive, 21-hour training course can easily eliminate up to four years of trial, error, and frustration! You’ll learn how to avoid the costly misconfigurations that even the most seasoned experts make. Find out more!
Improve SharePoint Performance on a WAN Learn how to increase in user-perceived remote performance in SharePoint 2007 while decreasing the load on W front-end servers (WFE).
Get Windows IT Pro To Go & Save 25% The Windows IT Pro Master CD is a powerful combination of content and convenience. Instantly search over 10K solution-driven articles instantly, and get online access to new articles each month at windowsitpro.com. Subscribe today!
Register
