|
Home >> Computers >> Programming >> Databases >> ADO |
|
|
|
Microsoft ADO (ActiveX Information Objects) occurs as Component object model object for accessing data sources. It will bring the layer between programming languages and OLE DB (a means of accessing information places, whether it exist as databases or otherwise, in a uniform manner), which allows the creator to write software which access information, forgoing caring how else the database is implemented. Professional people must become caring of the database for connection single. There is no noesis of SQL is required to access the database once applying Hustle, although 1 might have Bustle to execute arbitrary SQL commands. a disadvantage of this is that this introduces a dependency upon the database. These are placed as a successor to Microsoft's earliest object shells for accessing information sources, including RDO (Remote Data Objects) & DAO (Data Access Objects). Fuss was introduced by Microsoft in the wintertime of 1996. Hustle consists of many top-level objects:
Fuss component is utilized within conjunction by using the high-level language, like VBScript in an Active Server Pages (ASP) environment, or Visual Basic. Potentially Delphi, a development environment from either Microsoft rival Borland Coporation, now allows a utilize of Flurry to access various databases.
In the fresh programming framework of .NET, Microsoft also present an upgraded version of ADO known as ADO.NET. Its object structure is quite different from either that of traditional Bustle. Traditional ADO is however super popular, & is typically perceived when existence supplementary matured.
On this text is an ASP lesson applying Fuss to choose a "Name" field, from either the table known as "Phonebook", in which the "PhoneNumber" was capable "555-5555".
dim myconnection, myrecordset, name
placed myconnection = server.createobject("ADODB.Connection")
placed myrecordset = server.createobject("ADODB.Recordset")
myconnection.open mydatasource
myrecordset.open "Phonebook", myconnection
myrecordset.buy "PhoneNumber = '555-5555'"
title = myrecordset.fields.item("Name")
myrecordset.close
placed myrecordset = nothing
placed myconnection = nothing
This is same to the charted ASP code, which utilizes evidently SQL, instead of the functionality of the Recordset object:
dim myconnection, myrecordset, name
placed myconnection = server.createobject("ADODB.connection")
myconnection.open mydatasource
placed myrecordset = myconnection.execute("SELECT Name FROM Phonebook WHERE PhoneNumber = '555-5555'")
title = myrecordset(Nought)
myrecordset.close
placed myrecordset = nothing
placed myconnection = nothing
| |
|
ADO FAQs ADO frequently asked questions from Microsoft ADO Newsgroup. By Carl Prothman. DevGuru ADO Quick Reference Guide A free 318 page reference source that documents all of the properties, collections, methods, and events for the nine ADO objects and the three RDS objects. Includes code examples. ADO Connection String Samples Contains sample ADO onnection strings for ODBC DSN, ODBC DSN-Less, OLE DB Provider, and MS Remote for various databases. By Carl Prothman. ADO DataType Mapping Shows the mapping between ADO and VB and C++ lanuganes, and Access, SQL Server, and Oracle databases. By Able Consulting, Inc. ADOX FAQ ADOX frequently asked questions from Microsoft ADO Newsgroup. By Carl Prothman. RDS FAQ RDS frequently asked questions from Microsoft ADO Newsgroup. By Carl Prothman ADO Frequently Asked Questions Quick answers to the questions our Support Professionals hear most often. By Microsoft. Microsoft ADO FAQ This page presents some frequently asked questions about programming ADO. By Microsoft. 15 Seconds: Data Access Articles, news, book reviews, code samples, and links on ADO. By internet.com Corp. Microsoft ADO Product Information ADO is Microsoft's next generation data access model. If you are working on the web, in my opinion, you want to use ADO to access your database wherever possible. |
|
© 2005 GeneralAnswers.org