Receive Microsoft Knowledge Base articles by E-Mail?

Every night we scan the Microsoft Knowledge Base. If technologies you're interested in are updated, we'll send you an e-mail. You only get one e-mail a day, and only when new articles are added.

Click here to create a
FREE account

Already have an account?
[Click here to Login]


	Search KbAlertz Advanced Search

Webmasters
Put kbAlertz on your website.
[ Click Here for more! ]

Discount ASP.NET Hosting
ASP.NET 2.0 and 3.5
Windows2008 and SQL2008
US and UK Hosting
The ad says 3 - but KBAlertz referrals get
** SIX MONTHS FREE **

For bug tracking software or defect tracking software or issue tracking software, visit Axosoft.

Community Site

We Send hundreds of thousands of emails using ASP.NET Email

Expert Web Design & Graphic Design
Design44.com

Discount ASP.NET Hosting
ASP.NET 2.0 and 3.5
Windows2008 and SQL2008
US and UK Hosting
The ad says 3 - but KBAlertz referrals get
** SIX MONTHS FREE **

Mentioned In

Leave / Read
Community Feedback

Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks

Article ID: 308044 - Last Review: December 4, 2007 - Revision: 7.4

Roadmap for using ADO in .NET

Retired KB Content Disclaimer

View products that this article applies to.

This article was previously published under Q308044

Caution ADO and ADO MD have not been fully tested in a Microsoft .NET Framework environment. They may cause intermittent issues, especially in service-based applications or in multithreaded applications. The techniques that are discussed in this article should only be used as a temporary measure during migration to ADO.NET. You should only use these techniques after you have conducted complete testing to make sure that there are no compatibility issues. Any issues that are caused by using ADO or ADO MD in this manner are unsupported. For more information, see the following article in the Microsoft Knowledge Base:

840667 Â (http://kbalertz.com/Feedback.aspx?kbNumber=840667/ ) You receive unexpected errors when using ADO and ADO MD in a .NET Framework application

SUMMARY

This article provides a roadmap for learning and mastering how to use ActiveX Data Objects (ADO) via Component Object Model (COM) Interop on the Microsoft .NET platform. Roadmap articles provide links to useful information, including online documentation, Microsoft Knowledge Base (KB) articles, and white papers to assist you with learning a Microsoft product or technology.

This article contains the following sections:

Key Concepts
How Tos
Troubleshooting
Migration to ADO.NET

Back to the top

MORE INFORMATION

Key Concepts

For more information about key concepts, see the following Microsoft Web sites:

General ADO Overview:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconoverviewofadonet.asp (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconoverviewofadonet.asp)

General ADO Documentation:
http://msdn2.microsoft.com/en-us/library/ms805098.aspx (http://msdn2.microsoft.com/en-us/library/ms805098.aspx)

ADO Rocks and Rolls in .NET:
http://www.microsoft.com/downloads/details.aspx?FamilyID=8bfe85a3-a957-4744-88ec-89112eae45c3&DisplayLang=en (http://www.microsoft.com/downloads/details.aspx?FamilyID=8bfe85a3-a957-4744-88ec-89112eae45c3&DisplayLang=en)

Revisiting the Use of ADO in .NET Applications:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndive/html/data08092001.asp (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndive/html/data08092001.asp)

Help topic: COM Interop Part 1: C# Client Tutorial

Back to the top

How Tos

For how-to information, see the following resources:

Help topic: Accessing an ADO Recordset or Record from ADO.NET

Help topic: ADO Type mapping to .NET Framework Type

Help topic: Filling a DataSet with an ADO Recordset or Record

Quick Start: ADO Interoperability Technology Sample

The following sample illustrates how to retrieve data via an ADO Recordset on an ASPX page.

NOTE: The following path may be different, depending on where you installed the Microsoft .NET Framework Solution Developer Kit (SDK):

C:\Program Files\Microsoft.NET\FrameworkSDK\Samples\technologies\interop\basic\aspxtoado

Back to the top

Troubleshooting

If you encounter problems and need answers to your questions, it is recommended that you refer to the Microsoft Newsgroups, where you can share your experiences with your peers, or the Microsoft Knowledge Base, where you can search for articles about specific issues.

Microsoft ADO .NET public newsgroup:
news:microsoft.public.dotnet.framework.adonet (news:microsoft.public.dotnet.framework.adonet)

Search the Knowledge Base online:
http://support.microsoft.com/ (http://support.microsoft.com/)

Use the following keywords in your search to narrow the scope to ADO via COM Interop:

kbADONET kbInterop kbADO

MSDN .NET site:
http://msdn.microsoft.com/net/ (http://msdn.microsoft.com/net/)

Data access technologies Web site:
http://msdn.microsoft.com/dataaccess (http://msdn.microsoft.com/dataaccess)

Another useful method for learning and troubleshooting is first to verify that the ADO code works in Visual Basic 6, and then open the Visual Basic 6 project in Visual Studio .NET. The Upgrade Wizard creates a new Visual Basic .NET project that contains the converted ADO code.

Back to the top

Migration to ADO.NET

For information about migrating to ADO.NET, see the following:

Help topic: Comparison between ADO and ADO.NET

ADO.NET for the ADO programmer:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndive/html/data09132001.asp (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndive/html/data09132001.asp)

Back to the top

REFERENCES

For more information about the training that is available for Microsoft .NET technologies, see the following Microsoft Web site:

http://www.microsoft.com/learning/training/roadmap/default.mspx (http://www.microsoft.com/learning/training/roadmap/default.mspx)

Back to the top

APPLIES TO

Microsoft ActiveX Data Objects 2.7
Microsoft Web Services Enhancements for Microsoft .NET 1.1
Microsoft Web Services (included with the .NET Framework) 1.0

Back to the top

kbarttyperoadmap kbinfo KB308044

Back to the top

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Back to the top

Community Feedback System

Very often, it takes hours to solve a problem. Very often, you've looked high and low, and have tried a lot of solutions. When you finally found it, chances are, it was because someone else helped you. Here's your chance to give back. Use our community feedback tool to let others know what worked for you and what didn't.

Please also understand that the community feedback system is not warranted to be correct, it's simply a system that we've built to let people try and help each other. If something in a feedback response doesn't make sense to you, or you're not comfortable making changes that the feedback talks about (like registry edits), please consult a professional.

Thank you for using kbAlertz.com Feedback System.

-- Scott Cate

Be the first to leave feedback, to help others about this knowledge base article.

(Optional) Name

(Optional) Public URL Or Email

Comments
No HTML -- Text Only Please


	Copyright © 2002-2007 KBALERTZ.COM. All Rights Reserved. Terms / Privacy. Discount ASP.NET Hosting

KBAlertz.com: (308044) - This article provides a roadmap for learning and mastering how to use ActiveX Data Objects (ADO) via Component Object Model (COM) Interop on the Microsoft .NET platform. Roadmap articles provide links to useful information, including online...

Microsoft Knowledge Base Article

Roadmap for using ADO in .NET

On This Page

SUMMARY

MORE INFORMATION

Key Concepts

How Tos

Troubleshooting

Migration to ADO.NET

REFERENCES

APPLIES TO

Keywords:Â