什么是ADO？

jasonxiao2006

经常看到ADO这个名词，不知何意？有何用途，知道的告诉下啊！

godfrey

Microsoft ActiveX Data Objects (ADO) enable your client applications to access and manipulate data from a database server through an OLE DB provider. Its primary benefits are ease of use, high speed, low memory overhead, and a small disk footprint. ADO supports key features for building client/server and Web-based applications
简单说就是用来写客户端程序，高效地管理数据库服务器如SQL Server的。
       Set dbODNList = New ADODB.Connection
        strdbodnlist = "Provider='sqloledb';Data Source='10.211.100.123';" & _
        "Initial Catalog='RRMB_Live';User ID='rrmb_read_only';password='**********';"
        dbODNList.Open "select * from tb_ASC_LLI"
...