ADO 21, 21 Sams Teach Yourself ADO 2.5 in 21 Days., 21., 2 1 ADO., ADO.? ADO 21 (VB, VBA, VB ), ADO. 3 (Week). 1, 2, COM+ 3.. HTML,. 3 (week), ADO.
24 1 - ADO OLE DB SQL, UDA(Universal Data Access) ADO.,, ( ). 1.,., SQL. 2 - ADO (Transaction).,,. OLAP., MDX ADO MD OLAP. (Semistructured) ADO 2.5 Record, Stream. 2.,,. 3 - COM+, COM+... 3
25 DNA. DNA, - -. NT 4, 2000.,, 2000. 3 (IIS : Internet Information Server) 5., 2000.,, 2000., ASP. 3 ASP,.,, SQL 7.0 (MSDE ). Day 11 Day 12 OLAP (SQL 7.0, MSDE ), Day 13 2000.
WEEK 1
28 Wee k 1 Day 3-3. Day 4 -, Day 4. Day 5 -,.,. Day 6 - Day 6. (paging). Day 7 - SQL 7.0.. Day 6.
1 ADO
30 Wee k 1, ADO 2.5 (Microsoft Data Access Components : MDAC). MDACADO 2.5 (provider). ADO. (Universal Data Access : UDA) - UDA DB. ADO UDA (MDAC ). ADO - ADO. ADO - (Component Checker), ADO. SDK - ADO, (SQL ), MDAC. ADO - ADO,. ADO. ADO 2.5 (ADO), ADO (ADO Extensions for Dat a Definition Language and Security : ADOX), ADO(ADO Multidimensional : ADO MD). ADO UDA (), ADO.
Day 1 ADO 3 1, ADO., (UDA : Universal Data Access).,,., UDA ADO, OLE DB, ODBC MDAC., ADO. ADO., C+ +, VB ( (IIS),, ), J + +, J, (,, )., ADO., SQL 7.0, 2000 2000 ADO 2.5.,, ADO SQL 2000, - ODBC,, - ADO. (Indexing Service) NT 2000, (indexing). ADO. Indexing Service Query Language Dialect (Dialect 2) SQL., ADO.,., ADO, SQL
32 Wee k 1. ADO OLE DB,. OLE DB Object Linking and Embedding for DataBases, OLE DB.,., OLE DB ODBC(ODBC OLE DB ). ODBC. ODBC(Open DataBase Connectivity ; ). ODBC, (Access) ODBC, ODBC (ODBC ) ( ). ADO ODBC. ADO., ADO.,. IIS 4.0 () ADO DHTML, ( ). DHTML(Dynamic Hypertext Markup Language ; ) HTML. ADO, IE 4.0( )., ADO.,,. ADO
Day 1 ADO 33 SQL,,, IBM DB2. ADO, OLE DB, ODBC, [1.1]. 1.1 (Consumer) ADO, OLE DB, ODBC, Active Data Object(ADO) OLE DB OLE DB ODBC ODBC ODBC SQL (Data Provider). ADO.
34 Wee k 1 ADO (Dat a Consumer). ADO OLE DB (OLE DB ), OLE DB ( (Data Provider) )., ADO OLE DB ADO ( ) OLE DB. ADO, OLE., OLE DB., ADO. OLE DB (OLE DB provider) OLE DB. ADO OLE DB. OLE DB ADO. ADO ADO,, ADO SDK. ADO, SDK ADO. ADO ADO 2.5 2000 MDAC 2.5., MDAC 2.5 2000, ( 2000, ).
Day 1 ADO 35 2000 95/ 98/ NT 4.0, http :/ / www.microsoft.com/ data/ MDAC 2.5 RTM, ADO 2.5., ADO 2000MDAC 2.5 RTM, () (Platform) SDK. http :/ / msdn.microsoft.com/ developer/ sdk/ platform.asp., SDK 4.01 2 ( ) (DHTML ). 95/ 98/ NT 4.0 (Windows Installer) 1.1., SDK (setup), ADO. ADO 2.5 ADO MDAC., ADO 2.5 MDAC 2.5. MDAC 2.5. 95/ 98/ NT 4.0 http :// www.microsoft.com/ data/mdac (mdac_typ. exe). MDAC 2.5( ) x86. (Alpha), MDAC 2.1( 2). 2000 MDAC 2.5. 2000 (Windows File Protection : WFP) (System File Protection : SFP ). MDAC., MDAC, 2000.
36 Wee k 1 MDAC ADO : MDAC MDAC. 1. MDAC. 95/ 98/ NT 4.0 http :// www.microsoft. com/ data/mdac (mdac_typ.exe), 2000 (MDAC 2.5, ). 2. 95 DCOM95,. htt p :/ / www.microsoft.com/ com/ resources/ downloads.asp 98 DCOM98,. 3. MDAC 2.5 IE 4.01,. 4. mdac_typ.exe MDAC NT. - -. 5. NT 4.0, (Administrator). 6.,,. 7. MDAC, 50MB. MDAC Program Files (Windows\ System WinNT\ System32). 8. TEMP 50MB., SET TEMP., SET, TEMP = TMP =. 9. 95MDAC MDAC.
Day 1 ADO 37 10. 95 MDAC. Q216149, How to Install ODBC or MDAC on Terminal Server.. http :/ / support.microsoft.com/ support/ kb/ articles/ Q216/ 1/ 49.ASP 11. MDAC mdac_typ.exe MDAC ADO. DCOM95 DCOM98, (dcom95.exe dcom98.exe) MDAC. SQL OLE DB SQL ODBC SQL 6.5 MDAC 2.5, SQL 6.5 (Catalog Stored Procedure) SQL.,, SQL 6.5 instcat.sql. MDAC 2.5., instcat.sql SQL 6.5 5( ). MDAC, MDAC. MDAC, (Component Checker) MDAC,,. ADO. MDAC ADO OLE DB, ODBC. OLE DB ODBC,. MDAC. MDAC (MDAC 2.5 End-User License Agreement (EULA) ). MDAC http :/ / www.microsoft.com/ data/,.
38 Wee k 1, MDAC DCOM, 95 98 DCOM95 DCOM98. MDAC ADO MDAC.,. ODBC. ODBC (ODBC Data Source) ( 2000, ), ODBC (Data Source Name : DSN). 1. ODBC (Data Source Administrator) DSN. 2. (Add) DSN. 3. Microsoft Access Driver (*.mdb), (Finish). 4. (Data Source Name) CHECK. 5. (Dat abase) (Create) : (New Dat abase). 6. (Dat abase Name) C:\ CHECK.MDB OK. C:\ CHECK.MDB. (OK). 7.. 8.., ODBC (core) ODBC. ADO RDS, (Component Checker)..
Day 1 ADO 39 ADO ADO (ComCheck. exe). ADO MDAC, SDK., http :// www.microsoft.com/ Dat a/ download.htm. 32 64.. MDAC ADO MDAC MDAC ADO.,.dll.dll [1.2]. 1.2
40 Wee k 1 S DK ADO 2.5 SDK. MSDN SDK (http :/ / msdn.microsoft.com/ library/ )., SDK. http :/ / www.microsoft. com/ downloads/ Platform SDK, (, http :// msdn.microsoft. com/ developer/ sdk/ platform.asp). SDK,. Custom Inst allation,. C++ 6.0, SDK MFC ActiveX. MSDN http://msdn. microsoft.com MSDN, SDK. SDK ADO, ODBC ADO. SDK,, Microsoft Platform SDK, Platform SDK Documentation. [1.3]. [1.3] (index), (search), (Show).
Day 1 ADO 4 1 1.3 SDK ADO? ADO,. ADO ADO. ADO. ADO ADO. ADO, ADO. ADO ADO, ADO. ADO 2.5 3 ADO, ADOX, ADO MD. ADO ADO....
42 Wee k 1. (row), (recordset )..,., ADO.,. (transaction),.,.. - -. Day 8. ADO ADO. ADO. [ 1.1]. [ 1.1] ADO Connection Recordset Field Property Command Parameter. ( (resultset)). (column). Recordset Fields. ADO. Properties Connection, Command, Recordset, Field.. Command
Day 1 ADO 43 [ 1. 1] Record Stream Error (row). ( ). Connection. Connection Errors. ( ADO., Connection -, RecordSet - ) ADO, SDK. [1.4] ADO. 1.4 ADO SDK. ADO. (Connection)., (connection string)url. ADOConnection.
44 Wee k 1 (Recordset) (Query). ADO Recordset, ( ). Recordset (cursor), ( ).,., Recordset. (Field) (Entity).,,,.. ADO Command - -. Connection.,. [1.5] Connection, Recordset, Field. 1.5 Connection, Recordset, Field Connection (Execute) (Active Connection) Recordset (Fields Collection) Field, (resultset). ( ) Recordset, Fields. (,,, ). ADO (collection) ADO., Recordset Fields Field..
Day 1 ADO 45 [1.6]., ( ). 1.6 Recordset ADO, D ADO. ADO,. ADO.,, 3., DAO RDO,. DAO(Data Access Object ; ), (J ET ). RDO(Remote Data Obj ect ; ). RDO ADO, ODBC (ADO OLE DB ). ADO UDA, (OLE DB ).,,,, 2000, - (full-text) ( ) ADO. ADO. IE
46 Wee k 1, ASP (Active Server Pages ; ) IIS ADO. ADO,.,, (Day 16 ). (, ). ADO,.,. ADO. Recordset,. ADO,, Day16. C+ + 6.0, (ASP ) ADO,. ADO ADO 2.5 (). ADO 2.5, ADO. OLE DB, /. ADOX(ADO Extensions 2.5 for Data Definition Language and Security) ADO.,. ADOX ( Day 14 ). ADOX
Day 1 ADO 47 ADO MD(ADO Multidimensional 2.5) (Multidimensional). Cube (Met adata).,,, ( Day 11 OLAP Day 12 ADO MD ). ADO MDAC, B. MDAC ADO ADO 2.5 - ADO 2.5. (ProgID),,. (ProgID) (unique identifier), COM (ADO ADOX COM ). ADO, ADODB.Recordset ADO (=ProgID) - ADODB ADOX - (Recordset Connection ). COM(Component Object Model ; ). COM COM, COM COM. ADODB - ActiveX. msado15.dll, Connection, Recordset, Record, Command, Field, Stream. ADOR - ADO 2.5 (msador 15.dll). ADOR 2.5 ADO 2.5 Recordset ( Field Property ). IE.
48 Wee k 1 RDS RDSServer - (Remote Data Services) 2.5 ( RDS, msadco.dll ) RDS 2.5 ( RDS, msadcf.dll ). ADO, IIS RDS. (, IIS) (IE ). (Day 1 - Day 7) ADO 2.5. (J et and Replication Objects : J RO) 2.5 ADO. J RO ADO. ADOX ADOX. ADO,,,,. ADOX.,. ADOX Day 14. ADO MD 2.5 ADO 2.5 ADO MD((ADO Multidimensional) 2.5 OLE DB. OLAP OLE DB. OLAP OLE DB(OLE DB for OLAP(Online Analytical Processing)). OLAP.
Day 1 ADO 49 OLAP OLE DB SQL (multidimensional expressions : MDX). OLAP ADO MD Day 11 Day 12. ADO -,,, -. ADO. OLE DB ODBC,. ADO,,, SDK, ADO. ADO,., VBA, VB ADO D. Q&A.? ADO 2.5? ADO OLE DB, ODBC.
50 Wee k 1.. C+ + OLE DB, ODBC, ADO?, SDK. MSDN (Microsoft Developer Network).,. A. 1. 2000. MDAC 2.5,? 2. MDAC 2.5, ADO 2.5, OLE DB.? 3. 98 ADO. MDAC ADO? 4. MDAC 2.5.