---------------------------------------------------------
Microsoft(R) ActiveX(R) Data Objects  2.1 ߰  
---------------------------------------------------------

(c) 1998 Microsoft Corporation. All rights reserved.

  Microsoft ADO   ֱٿ ٲ ̳ Ÿ   ֽϴ.

------

------

1. ǰ 
   
2. ο 
2.1 Seek  Index
2.2  Ʈ  ȭ
2.3 Microsoft OLE DB Persistence Provider
2.4 Microsoft Data Shaping Service for OLE DB
2.5 Microsoft OLE DB Remoting Provider

3.  
3.1   
3.2 ѵǴ 
3.3    

4. ˷ , Ѱ,     ֱٿ ٲ 

-------------
1. ǰ 
-------------

ActiveX Data Objects(ADO) ͸ ׼ϱ  ڵȭ  ̽Դϴ. ADO ODBC Ͽ  ͻӸ ƴ϶  ̿    ׼  ִ OLE DB ̽ մϴ.

ADO ü  OLE DB ̽  ڵ   ݿǾ Ƿ RDO DAO ڴ ADO α׷ϴ Ϳ  ͼ  ֽϴ.

Microsoft Remote Data Service(RDS) Microsoft Internet Explorer ȣƮ Ͽ   α׷  ȿ  Ἲ   Խ ӿũ ϴ ADO  Դϴ. RDS HTTP, HTTPS(HTTP over Secure Socket layer)  DCOM  α׷ ݿ ϴ л  Ŭ̾Ʈ/   ΰ ֽϴ. RDS  ν ActiveX Ʈ Ͽ ȸ Ʈݰ ͳݿ   ִ  ߽ л  α׷ ϰ ϴ  ڰ  Microsoft Visual Basic(R) ŸϷ  ׼ α׷   ֵ ݴϴ.

---------------
2. ο 
---------------

ADO 2.1 ڸ      ߰Ǿϴ.

2.1 Seek  Index
Seek ޼ Index Ӽ ε   ż  ġ ڵ տ ߰մϴ. 

2.2  Ʈ  ȭ
ο " "  JOIN   ڵ տ   Ʈ ȭ ڰ Ͽ   ֵ մϴ. 7 ο  Ӽ 5  ޼  մϴ.

2.3 Microsoft OLE DB Persistence Provider
Microsoft OLE DB Persistence Provider Recordset ü Save  Open ޼ Բ ڵ  Ͽ   մϴ. ̹  ͳ  ۵Ǵ    ±׸ ϴ ǥ  XML(Extensible Markup Language)  ڵ    ֽϴ.

2.4 Microsoft Data Shaping Service for OLE DB
  ϴ Microsoft Data Shaping Service for OLE DB Ͽ    ֽϴ.

2.4.1   ڵ  ٽ   ֽϴ.   ϱ  ڵ    Ⱓ  ϴ Name Ӽ ϴ.

2.4.2    Ӹ ƴ϶  ڵ     ü    ֽϴ.   ü η ĵ  ̸ Ͽ ϴ ذ   θ ϴ. 

2.4.3 Ű ȭ COMPUTE ɿ PARAMETER  Ű  μ ̿   COMPUTE    ֽϴ. 

2.5 Microsoft OLE DB Remoting Provider
Microsoft OLE DB Remoting Provider ǥ  ڰ Ǿ  , ȭ    ADO 2.0 ȣȯ  ο  Ӽ  Ǿϴ.


-------------
3.  
-------------

3.1   

  ADO  RDS ü    ȭǾǷ Internet Explorer "" 忡 ǰ ִ , Ϻ ۾  ް ˴ϴ.

3.1.1. 
Internet Explorer 4.0  ٸ ""    ٸ Ͽ   Ͼ ADO/RDS ü     ֽϴ.     Internet Explorer 4.0 ǵ˴ϴ.
*  ͳ 
*   Ʈ 
*  ѵ Ʈ 
*  ŷ  ִ Ʈ 

3.1.2.  
        ֽϴ.    Ʒ      ֽϴ.
*  
*  
*  
*   

Ÿ  ActiveX Ʈ Internet Explorer 4.0 ϴ  ADO/RDS ü ϰ Ϸ   "" Ǵ "" ؾ մϴ.    ADO/RDS ü  峪  忡 ϵ   ˴ϴ.

3.2 ѵǴ 

⺻ Internet Explorer 4.0 ADO/RDS ü   ۾ Ǹ "ŷ  ִ  ", "ŷ  ִ Ʈ "  "ͳ "   ׼  ޽ Ÿϴ. ⺻ ADO/RDS ü    ۾ "ѵ Ʈ " ε  ֵǾ  ʽϴ.  ̵ 忡   ADO/RDS ۿ  մϴ.

3.2.1  ü
Ʒ   ü ""  ֵ˴ϴ. ̰   ۾(3.2.3 ڼ )  ȯ(: Internet Explorer ⺻  -  忡 ϴ      ʴ )  ʰ   ȯ(: Visual Basic) ȴٴ ǹԴϴ.
a. RDS.DataControl ü
b. RDS.DataSpace ü
c. ADO Recordset ü

3.2.2   ü
Ʒ   ü " "  ֵǸ  ȯ濡  Ǵ   ۼ   ڿ  ʽϴ.
a. RDSServer.DataFactory ü
b. ADO Connection ü
c. ADO Command ü

3.2.3  ü   ۾
 "" ü(: RDS.DataControl, RDS.DataSpace, ADO Recordset) Ǵ   ۾ ֵ˴ϴ. ̷ ۾  ȯ濡     ȯ濡 ˴ϴ.

a. RDS.DataControl
i)  RDS.DataControl ü   2 DCOM óԴϴ. ̰  ǻ Ǵ DCOM  Ͽ ϴ  ͺ̽    ٴ  ǹմϴ.
ii) HTTP ϴ  3 ۾ ش  ٿε    ֽϴ. ̰ RDS.DataControl ü  Server Ӽ  ٿε ȣƮ ̸(http://server) ƾ Ѵٴ  ǹմϴ.

b. RDS.DataSpace
i) RDS.DataSpace ü   2 DCOM óԴϴ. ̰ RDS.DataSpace ü Ͽ  ǻͿ Ǵ DCOM  Ͽ Ͻ ü ȣ  ٴ  ǹմϴ. 
ii) HTTP ϴ  3 ó ش  ٿε    ֽϴ. ̰ DataSpace ü CreateObject ޼ ȣ⿡   ° Ű  ش  ٿε    Ѿ Ѵٴ  ǹմϴ.

c. ADO Recordset
i) ڰ MS Remote ƴ  ϴ.   ڿ "Provider=MS Remote" ۵Ǿ մϴ.   ڿ ִ "Remote Server" ±״ ش  ٿε  ̸ ƾ մϴ.  2 DCOM   ʽϴ.
ii)  Ӽ ۾(:   ýۿ ڵ   ΰ  ǻ Ͽ  ڵ   ۾) մϴ.

3.3    

ADO/RDS  [ ʴ  ǥõ ActiveX Ʈ ʱȭ  ũƮ] ɼǿ   ˴ϴ. Ư     ٲ㼭     ֽϴ. Ʈ  [ ʴ  ǥõ ActiveX Ʈ ʱȭ  ũƮ] ɼǿ  ⺻   ϴ.
  = 		 = " "
  = 		 = " "
  = 		 = "Ʈ"

ٸ   ⺻  ؼ Internet Explorer  Ͻʽÿ.

  ٲν,  Ǵ   ADO Recordset ü    ֽϴ.   ۾  ϰ ϰ Ͱ ׷ ۾ õ  Ȯ ޽ ǥõǴ   ,  ɼ   "" ؾ մϴ.  RDS DataControl  ADO ڵ տ (  ýۿ Recordset Ϸ ϴ Ͱ )   ۾ õ   ɼ  "" ؾ մϴ. "Ʈ" ϸ ׷ Recordset ü(RDS.Datacontrol ) " "ó մϴ.

 ɼǿ      Ͽ ⺻  ٲ  ֽϴ.  ߵ,   ۾    ְ ׷ ۾ õ   ǥõǵ    ƹ   ׷ ۾ ϵ   ֽϴ.  ٸ     ٸ      ֽϴ. Ư       Ϸ  ܰ踦  մϴ.

: [ ʴ  ǥõ ActiveX Ʈ ʱȭ  ũƮ]   ֵ ϸ(Ʒ ܰ 5) ϰų    ActiveX Ʈ ( ִ Ʈ̳  ִ ũ 忡  ǻ͸ ų ɼ ִ)      ִٴ  Ͻʽÿ. ׷Ƿ   "Ʈ" ̳ "ŷ  ִ Ʈ"   ɼ ϰ "ͳ"   ʴ  ϴ.

1. Internet Explorer 4.0 [] ޴ [ͳ ɼ] Ͽ [ͳ ɼ] ȭ ڸ  [ý ] մϴ.
2. [] Ӵٿ Ͽ      մϴ.
3. õ   [ ] մϴ. ̷ ϸ ȭ ڿ [] ߸   ְ ˴ϴ.
4. []  [ ] ȭ ڸ ϴ.
5. ADO/RDS   ۾(3.2.3 )    ޽ ǥõ ʰ Ϸ [ ] ȭ ڿ [ ʴ  ǥõ ActiveX Ʈ ʱȭ  ũƮ] ɼǿ  [] ϰ [Ȯ] ϴ. 
6. ADO/RDS ü   ۾(3.2.3 ) õ   ǥõǰ Ϸ [ ] ȭ ڿ [ ʴ  ǥõ ActiveX Ʈ ʱȭ  ũƮ] ɼǿ  [Ʈ] ϰ [Ȯ] ϴ.
7. ADO/RDS ü   ۾(3.2.3 )  ʰ Ϸ [ ] ȭ ڿ [ ʴ  ǥõ ActiveX Ʈ ʱȭ  ũƮ] ɼǿ  [ ] ϰ [Ȯ] ϴ.
8. ʿ   ܰ踦 ݺϿ ٸ       մϴ.
9. [Ȯ] ϴ.

 ADO/RDS ü    忡 ϰ ˴ϴ. 3.2.3 ߵ ̷      2  , DCOM ϱ, ó  ٿε  ̿ ٸ  ϱ Ǵ  ǻ Ͽ ڵ  ϱ⳪  ǻ Ͽ ڵ    ADO/RDS ü ۿ  ݴϴ.

  ɼ [Ȯ]  ADO/RDS ü   ۾ õǴ  Ʒ   Ÿϴ.

"The page is accessing a data source on another domain. Do you want to allow this?"  , ڴ [] Ǵ [ƴϿ]   ֽϴ. [] ϸ ۾ Ϸǰ [ƴϿ] ϸ ۾ մϴ.

--------------------------------------------------------
4. ˷ , Ѱ,     ֱٿ ٲ 
--------------------------------------------------------

4.1 RDS Ŭ̾Ʈ ȭ  ü  Ƿ   ʽϴ.

4.2 Internet Infomation Server 4.0 " "  ,  RDS ϵ Ϸ Ʒ    ܰ谡 ߰ ʿմϴ.

A)   , " ׼ " ׸ մϴ.
B) msadcs.dll vroot\msadc űϴ. ⿡ vroot   Ȩ ͸Դϴ.

4.3 IIS  RDS   μ  Ǵ     ִ Ʈ Ͽ   ֽϴ. μ    Ʈ  Ȳ Ǵ Ʈ   ũⰡ ū ó ɿ    ֽϴ. ڴ ֻ  򵵷  ƾ մϴ.  Ư   ϴ.

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\W3SVC\Parameters\ADCThreads


⼭ ADCThreads ڰ ߰ REG_DWORDԴϴ. ȿ   1 - 50̸ ⺻ 6Դϴ. Ʈ Ű   50 ũ ִ밪 (50) ˴ϴ. ڴ  Ʈ  ۼ ʿ䰡    ⺻ Ʈ Ե ʽϴ. 

4.4 ⺻ ADO "" RDS Server DataFactory  ġ˴ϴ. RDS Server        ǹմϴ.

	1. DataFactory Բ óⰡ ʿմϴ.
	   (̴ Ʈ Ű  ˴ϴ.)

	2. ⺻ ó msdfmap.handler ϵǾ  ó Ͽ ⺻ ó ǥõ˴ϴ.

	3. Msdfmap.ini  Windows ͸ ġ˴ϴ. 3 忡 RDS ϱ  ʿ信    ؾ մϴ.

ɼ,   DataFactory ġ   ֽϴ. DataFactory   ó     ֽϴ. ڴ  ڿ Ͽ   ó⸦     ݵ ׷ ʿ ϴ.

   ó Ʈ ׸ ġϱ  handsafe.reg Ʈ  Ͽϴ.
 忡 Ϸ handsafe.reg Ͻʽÿ. 

    ó Ʈ ׸ ġϱ  handunsf.reg Ʈ  Ͽϴ.   忡 Ϸ handunsf.reg Ͻʽÿ.

RDS   ó  ϴ   ڼ   Ʈ http://www.microsoft.com/data/techmat.htm 湮Ͽ "Using the Customization Handler Feature in RDS 2.0"   縦 Ͻʽÿ.

4.5 Find ޼   ġ   Recordset ü ˻Ͽ  ؿ ´ ڵ带 ãϴ. Find ޼带 ȣϱ    ġ    ߻մϴ.

4.6 Visual Basic ADO FetchProgress  FetchComplete ̺Ʈ Ϸ Visual Basic  ּ 6 ̻̾ մϴ.

4.7    CALC Ŀ ϱ⿡ ""ϴٰ ֵǴ Դϴ. 

Abs, Asc, Atn, CBool, CByte, CCur, CDate, CDbl, Chr, ChrB, ChrW, Chr$, ChrB$, CInt, CLng, Cos, CSng, CStr, Cvar, CVDate, CVErr, Date, Date$, DateAdd, DateDiff, DatePart, DateSerial, DateValue, Day, DDB, Error, Error$, Exp, Fix, Format, Format$, FV, Hex, Hex$, Hour, IIF, InStr, Int, IPmt, IRR, IsDate, IsEmpty, IsError, IsNull, IsNumeric, IsObject, LCase, LCase$, Left, LeftB, Left$, LeftB$, Len, Log, LTrim, LTrim$, Mid, Mid$, Minute, MIRR, Month, Now, NPer, NPV, Oct, Oct$, Pmt, PPmt, PV, QBColor, Rate, RGB, Right, RightB, Right$, RightB$, Rnd, RTrim, RTrim$, Second, Sgn, Sin, SLN, Space, Space$, Sqr, Str, Str$, StrComp, StrConv, String, String$, SYD, Tan, Time,Time$, Timer, TimeSerial, TimeValue, Trim, Trim$, TypeName, UCase, UCase$, Val, VarType , Weekday, Year

4.8 ADO 2.1 XML    Recordset ü  ʽϴ.

4.9  ͸ XML  ϰ XML  ϸ б  Recordset ü ͸ Ʈ  ϴ. XML ͸  ,  Ͽ Recordset ü ٽ  ϸ  ߻մϴ.

4.10 adUseClient ϰų SQL Server 6.5   4  ۾  ,  DISTINCT Ű带 ϸ Ʈ   տ  õ˴ϴ. ̴ SQL Server ̸   ѿ ذ Դϴ.

4.11 ActiveX Data Objects α׷  Type Ӽ ׸  DataTypeEnum   ֽϴ. Ʒ  enum      ϴ.

adArray, adByRef, adVector

Ʒ  Ͽ   ϴ ̸   ֽϴ.

adChapter       (DBTYPE_HCHAPTER)  ĺϴ   4Ʈ  

adDBFileTime   ð (DBTYPE_DBFILETIME)

adFileTime    1601 1 1 ĺ 100nsec  Ÿ 64Ʈ (DBTYPE_FILETIME)

adPropVariant ڵȭ PROPVARIANT(DBTYPE_PROP_VARIANT)

adVarNumeric   (Parameter ü ش)

4.12 Connection  Command ü Execute ޼忡 Ǵ Options Ű  ȿ  Ͽ  ֽϴ. Ʒ ExecuteOptionEnum    Ǿϴ.    ü   Ǿ մϴ.

adCmdTable    ADO CommandText ̺ ̸ ϰ CommandText  ̺   ȯϱ  SQL  ؾ Ѵٴ  Ÿϴ.

Ʒ CommandTypeEnum  Ͽ   ϴ ̸   ֽϴ.

adCmdFile     ڰ CommandText  ̸ ؾ Ѵٴ  Ÿϴ.

Ʒ ExecuteOptionEnum  Ͽ   ϴ ̸   ֽϴ.

adAsyncFetchNonBlocking      尡 ߴܵ ʴ´ٴ  Ÿϴ. û      ڵ  (EOF) ̵մϴ.

adExecuteNoRecords        CommandText  ȯ ʴ  Ǵ  ν(:  Ը ϴ ) Ÿϴ.  ˻Ǹ  ǰ ȯ ʽϴ.   ׻ adCmdText Ǵ adCmdStoredProc Բ ˴ϴ.

4.13 Connection ü OpenSchema ޼忡 Ǵ QueryType Enum  Ͽ  ֽϴ. Ʒ  Ͽ   ϴ ̸   ֽϴ.

Enum			 

adSchemaDBInfoKeywords	

adSchemaDBInfoLiterals	

adSchemaCubes		CATALOG_NAME
			SCHEMA_NAME
			CUBE_NAME

adSchemaDimensions	CATALOG_NAME
			SCHEMA_NAME
			CUBE_NAME
			DIMENSION_NAME
			DIMENSION_UNIQUE_NAME

adSchemaHierarchies	CATALOG_NAME
			SCHEMA_NAME
			CUBE_NAME
			DIMENSION_UNIQUE_NAME
			HIERARCHY_NAME
			HIERARCHY_UNIQUE_NAME

adSchemaLevels		CATALOG_NAME
			SCHEMA_NAME
			CUBE_NAME
			DIMENSION_UNIQUE_NAME
			HIERARCHY_UNIQUE_NAME
			LEVEL_NAME
			LEVEL_UNIQUE_NAME

adSchemaMeasures	CATALOG_NAME
			SCHEMA_NAME
			CUBE_NAME
			MEASURE_NAME
			MEASURE_UNIQUE_NAME

adSchemaProperties	CATALOG_NAME
			SCHEMA_NAME
			CUBE_NAME
			DIMENSION_UNIQUE_NAME
			HIERARCHY_UNIQUE_NAME
			LEVEL_UNIQUE_NAME
			MEMBER_UNIQUE_NAME
			PROPERTY_TYPE
			PROPERTY_NAME

adSchemaMembers		CATALOG_NAME
			SCHEMA_NAME
			CUBE_NAME
			DIMENSION_UNIQUE_NAME
			HIERARCHY_UNIQUE_NAME
			LEVEL_UNIQUE_NAME
			LEVEL_NUMBER
			MEMBER_NAME
			MEMBER_UNIQUE_NAME
			MEMBER_CAPTION
			MEMBER_TYPE
			Ʈ (Ʒ )

 7 Enum (adSchemaCubes adSchemaMembers)   ڿ Բ Ǿ Ѵٴ Ϳ Ͻʽÿ. adSchemaMembers Ʈ   Ǹ ԽŰ   ڼ  OLE DB for OLAP α׷  Ͻʽÿ.

4.14 ActiveX Data Objects α׷  CancelBatch ޼ ׸  AffectEnum   ֽϴ. Ʒ  Ͽ   ϴ ̸   ֽϴ.

adAffectAllChapters      忡      մϴ.

4.15 adModeShareDenyNone ConnectModeEnum  Mode Ӽ ׸񿡼 ߸ Ǿ ֽϴ.   Ʒ  Ǿ մϴ.

adModeShareDenyNone	ٸ ڵ      ְ մϴ. ٸ ڵ б   ׼    ֽϴ.

4.16
 ڵ  ü   ʾ Index Ӽ  ȯ߽ϴ.  MDAC 2.1 Service Pack 1 ADO 2.1  ڿ   ȯմϴ.


