---------------------------------------------------------
Microsoft(R) ActiveX(R) Data Objects version 2.1 README
---------------------------------------------------------

1998 (C) Copyright Microsoft Corporation. All rights reserved.

̃t@Cɂ́AhLgɋLڂȂŐV̏񂨂ѕ⑫Iȏ񂪋LqĂ܂B

----
ڎ
----

1. i

2. V@\
2.1 Seek  Index
2.2 s̍XVƓ
2.3 Microsoft OLE DB Persistence Provider
2.4 Microsoft Data Shaping Service for OLE DB
2.5 Microsoft OLE DB Remoting Provider

3. ZpIȏ
3.1 ZLeB̊g
3.2 @\
3.3 ZLeBݒ̃JX^}CY

4. oOAAύXAэŐṼhLg

-----------
1. i
-----------

ActiveX f[^ IuWFNg (ADO) ́Af[^ɃANZX邽߂̃I[g[V x[X̃C^[tFCXłBADO ́AOLE DB C^[tFCXgpāAODBC ʂĒ񋟂f[^͂̂ƁAȊÔ܂܂ȃf[^ \[XɃANZX܂B

ADO ́ARDO  DAO C^[tFCXJ̌oɊÂđŜ݌vĂ邽߁ARDO  DAO ̃[U[ł΁AADO ̃vO~OɂɐeނƂłł傤B

Microsoft [g f[^ T[rX (RDS) ́AŌIȃf[^ڑƁAMicrosoft Internet Explorer ɂăzXgAvP[Ṽf[^s̃t[[N񋟂AADO ̃R|[lgłB́AHTTPAHTTPS (Secure Sockets Layer (SSL)  HTTP)A DCOM AvP[V vgRœ삷NCAg/T[o[̕UZpɊÂĂ܂BRDS ́Af[^A ActiveX Rg[gpāAƓCglbgуC^[lbgŎgpAU^уf[^W^̃AvP[V\z Web J҂ɁAMicrosoft Visual Basic(R) X^Cł̃f[^ ANZX vO~O񋟂܂B

---------
2. V@\
---------

ADO 2.1 ɂ́AJҌ̐V@\ǉĂ܂B

2.1 Seek  Index
Seek \bh Index vpeB́AR[hZbg̃CfbNXts̈ʒu΂₭ǉ܂B

2.2 s̍XVƓ
V "stBbNX Abv" [h́AJOIN Zqɂč쐬郌R[hZbg̍s̍XVƓsA[U[ JX^ Rg[񋟂܂B7 ̐VIvpeBA5 ̊̃\bh𐧌䂵܂B

2.3 Microsoft OLE DB Persistence Provider
Microsoft OLE DB Persistence Provider ́ARedordset IuWFNg Save  Open \bhƘAāAt@Cւ̃R[hZbg̕ۑъi[s܂B{[Xł́AR[hZbg XML (eXtensible Markup Language : g\}[NAbv) `ŕۑł܂BXML ł́AC^[lbgē]f[^ɑ΂ă[U[Ǝ̃^O`ł܂B

2.4 Microsoft Data Shaping Service for OLE DB
Microsoft Data Shaping Service for OLE DB ́Af[^ VFCvT|[g܂B

2.4.1 ȑOɃVFCvꂽR[hZbgăVFCv܂B̋@\T|[gɂ́AR[hZbgłɐڑ Name vpeBKv܂B

2.4.2 VFCvꂽR[hZbg̊ex (eR[hZbĝ̎qR[hZbgȊO)ȀWvvZsƂł܂B̋@\́AړĨxїɓntH[ɁASȃ`v^gp܂B

2.4.3 p[^ꂽ COMPUTE R}h́APARAMETER 储уp[^̊Ԃɑ} COMPUTE ̔Cӂ̐܂B

2.5 Microsoft OLE DB Remoting Provider
Microsoft OLE DB Remoting Provider ͕W̃T[rX voC_łAptH[}X̌A[U[ Rg[̋AADO 2.0 Ƃ̌݊̂߂̐VȓIvpeB擾܂B

---------------
3. ZpIȏ
---------------

3.1 ZLeB̊g

̃o[Wł́AADO  RDS IuWFNg̃ZLeBgAInternet Explorer  "S" ȃ[hŎsĂ鎞A̑삪܂B

3.1.1. ][
Internet Explorer 4.0 ł́AقȂ "][" ɑ΂ĈقȂZLeBݒݒ肷邱ƂłÃ][ɂ ADO/RDS IuWFNg̓JX^}CY邱Ƃł܂BInternet Explorer 4.0 ł́A 4 ̃][`Ă܂B
*  C^[lbg ][
*  Cglbg ][
*  tTCg ][
*  Mς݃TCg ][

3.1.2. ZLeB x
ꂼ̃][ɂ́AgpZLeB xw肷邱Ƃł܂Be][ɑ΂ÃZLeB xݒł܂B
*  
*  
*  
*  JX^

ׂ̂Ă ActiveX Rg[ƓlAInternet Explorer 4.0  ADO/RDS IuWFNgSɓ삷悤ɂɂ́AZLeB x "" ܂ "" ɐݒ肳ĂKv܂BJX^ݒ́AADO/RDS IuWFNgS܂͔S[hœ삳邽߂Ɏgp܂B

3.2 @\
ftHgł́AInternet Explorer 4.0 ł ADO/RDS IuWFNg̈Sł͂ȂׂĂ̑́A"Cglbg ]["A"Mς݃TCg ][" ܂ "C^[lbg ][" Ńy[WɃANZXۂɁA[U[ɎsmF_CAO {bNX\܂B"tTCg ][" ǂݍ܂ꂽy[WŁAADO/RDS IuWFNgւ̈Sł͂Ȃ̓ftHgŖɂ܂BɁÃ[hŎsĂ鎞 ADO/RDS ̓܂B

3.2.1 SȃIuWFNg
̃IuWFNǵA"Sł" Ɣf܂B́ASł͂Ȃ (3.2.3 Q) SȊ (Ⴆ΁AftHgł Internet ExplorerBAJX^ݒɂS[hŎsꍇ) ɂĂ͖ɂASł͂Ȃ (Ⴆ΁AVisual Basic) ł͗Lɂ邱ƂӖ܂B
a. RDS.DataControl IuWFNg
b. RDS.DataSpace IuWFNg
c. ADO Recordset IuWFNg

3.2.2 Sł͂ȂIuWFNg
̃IuWFNǵA"Sł͂Ȃ" Ɣf܂B́ASȊő삷鎞AړI܂͊ԐړIɍ쐬 (ă[U[ւ̔zz) 邱Ƃ͂ł܂B
a. RDS Server.DataFactory IuWFNg
b. ADO Connection IuWFNg
c. ADO Command IuWFNg

3.2.3 SȃIuWFNgł̈Sł͂Ȃ
̑́A"S" IuWFNg (RDS.DataControlARDS.DataSpaceAADO Recordset) ł̈Sł͂ȂłƔf܂B̑́AZLeB x (Sx) ݒ肳ꂽł͖ɂAZLeB x (Sx) Ⴍݒ肳ꂽł͗LɂȂ܂B

a. RDS.DataControl
i) RDS.DataControl IuWFNgłׂ̂Ă 2 w DCOM ViIB́AgpĂ郍[J Rs[^ŁA܂ DCOM vgRgpĐڑĂT[o[Af[^x[XڑJƂłȂƂӖ܂B
ii) HTTP łׂ̂Ă 3 ẃAy[W̃_E[h̃T[o[ɐĂ܂B́ARDS.DataControl IuWFNg Server vpeBAy[W̃_E[h̃zXg (http://server) ƓȂ΂ȂȂƂӖ܂B

b. RDS.DataSpace
i) RDS.DataSpace IuWFNgłׂ̂Ă 2 w DCOM ViIB́A[J Rs[^A܂ DCOM vgRł̃rWlX IuWFNǧĂяo RDS.DataSpace IuWFNggpłȂƂӖ܂B
ii) HTTP łׂ̂Ă 3 wViÍAy[W̃_E[h̃T[o[ɐĂ܂B́ADataSpace IuWFNg CreateObject \bȟĂяo 2 Ԗڂ̃p[^Ay[W̃_E[hƓT[o[|CgĂȂ΂ȂƂӖ܂B

c. ADO Recordset
i) MS Remote voC_łȂׂĂ̐ڑBāAڑ "Provider=MS Remote" Ŏn܂Kv܂Bڑ "Remote Server" ^OAy[W̃_E[h̃T[o[ƓOłȂ΂Ȃ܂B[Jł 2 w DCOM ڑ͂ł܂B
ii) R[hZbg[J̃t@C VXeɕۑA[J Rs[^̃t@C烌R[hZbgJ悤ȁA[Jł̉iB

3.3 ZLeBݒ̃JX^}CY

ADO/RDS ̓́A"Sƃ}[NĂȂ ActiveX Rg[̏ƃXNvgs" IvV̐ݒŐ䂳܂B̃][ɂẴZLeB xύX邱ƂɂāÃZLeBݒύX܂B"Sƃ}[NĂȂ ActiveX Rg[̏ƃXNvgs" IvVݒł́ACglbg ][̃C^[lbg IvV͎̂悤ɂȂĂ܂:

ZLeB x =       l = "ɂ"
ZLeB x =         l = "ɂ"
ZLeB x = Ⴂ      l = "_CAO\"

̑̃ZLeB ][̊̐ݒɂẮAInternet Explorer ̃hLgQƂĂB

ZLeB xύX邱ƂŁAuEUœ삵Ă ADO Recordset IuWFNg̐ؒfύX邱Ƃł܂BSł͂ȂAxoȂ悤ɂꍇ́ÃIvVK "Lɂ" ɐݒ肵mFĂBRDS.DataControl IuWFNgl ADO Recordset ȂǂŁASł͂Ȃ ([J t@C VXẽt@C Recordset ۑȂ) sɂ́Al "Lɂ" ɐݒ肵Ȃ΂ȂȂƂɒӂĂB"_CAO\"  Recordset IuWFNg (RDS.DataControl IuWFNgl) ɊւāA"ɂ" Ɠ悤ȓ܂B

L̃IvVݒ肷邱ƂŁA̐ݒgȂ悤ɂ邱Ƃł܂BׂĂ̈Sł͂Ȃ (OqŐ) Sɖɂ邩Â悤ȑ삪݂ꂽۂɌx\邩A܂͌xȂł̂悤ȑLɂ邩Ił܂BقȂZLeB ][ƂɁAقȂJX^ݒݒ肷邱Ƃł܂B̃ZLeB ][̃ZLeBݒJX^}CYɂ́A̎菇ɏ]Kv܂B

: "Sƃ}[NĂȂ ActiveX Rg[̏ƃXNvgs" (菇 5 Q) Lɂ邱ƂɂASȁA܂͈Sł͂ȂAׂĂ ActiveX Rg[ Web y[Wł̎gp邱ƂɂȂ܂ (ʂƂāAӂ̂Rg[A܂͈ӂ̂XNvg R[hɃ[U[炳邱ƂɂȂ܂)B́A"Cglbg" ܂ "Mς݃TCg" ZLeB ][ł̂ݎsA"C^[lbg" ][ł͎sȂƂE߂܂B

1. Internet Explorer 4.0  [\] j[ [C^[lbg IvV] NbNA[C^[lbg IvV] _CAO {bNX\܂BꂩA[ZLeB] ^uNbN܂B
2. [][] hbv_E XgAݒJX^}CY][I܂B
3. I][ɑ΂A[JX^] ZLeB xI܂BɂA_CAO {bNX [ݒ] {^LɂȂ܂B
4. [ݒ] {^NbNāA[ZLeBݒ] _CAO {bNX\܂B
5. x\ɁAADO/RDS IuWFNgł̈Sł͂Ȃ (3.2.3 Q) LɂꍇA[ZLeBݒ] _CAO {bNX "Sƃ}[NĂȂ ActiveX Rg[̏ƃXNvgs" IvV "Lɂ" IA[OK] NbN܂B
6. ADO/RDS IuWFNgł̈Sł͂Ȃ (3.2.3 Q) ݂ꂽAɌx\ꍇA[ZLeBݒ] _CAO {bNX "Sƃ}[NĂȂ ActiveX Rg[̏ƃXNvgs" IvV "_CAO\" IA[OK] NbN܂B
7. ADO/RDS IuWFNgł̈Sł͂Ȃ (3.2.3 Q) SɖɂꍇA[ZLeBݒ] _CAO {bNX "Sƃ}[NĂȂ ActiveX Rg[̏ƃXNvgs" IvV "ɂ" IA[OK] NbN܂B
8. Kvł΁ÃZLeB ][ɂĂA̎菇JԂAZLeBݒJX^}CY܂B
9. [OK] NbN܂B

ŁAADO/RDS IuWFNg͎w肳ꂽJX^ [hœ삷悤ɂȂ܂B̐ݒ́Aw肳ꂽZLeB ][ŁAADO/RDS IuWFNg̎̓ (3.2.3 Q) ɉe܂B[J 2 wڑ̃I[vADCOM ł̍ƁAy[W̃_E[hȊÕT[o[ւ̐ڑA[J Rs[^ł̃t@Cւ/t@C̃R[hZbg̕ۑ܂̓I[vB

[ZLeBݒ] _CAO {bNX [_CAO\] IɂꍇAADO/RDS IuWFNgł̈Sł͂Ȃ삪݂ꂽAsǂ̊mF߂܂Bsɂ́A[͂] NbN܂B[] NbNꍇ́A삪s܂B

-----------------------------------------------------
4. oOAAύXAэŐṼhLg
-----------------------------------------------------

4.1 RDS ł̃NCAg̋^[U[́AIy[eBO VXẽT|[gȂ߂Ɍ݃T|[gĂ܂B

4.2 Internet Information Server 4.0  "zT[o[" 쐬ہAT[o[ RDS ƘAgł悤ɐݒ肷邽߂ɁA 2 ̎菇ǉKv܂B

A) T[o[ݒ肷ہA[s] ANZXIɂ܂B
B) vroot zT[o[̃z[ fBNgɂĂꍇAmsadcs.dll  vroot\msadc Ɉړ܂B


4.3 IIS T[o[ RDS gp鎞AvZbTƂɍ쐬Xbh Web T[o[̃WXg𑀍삷邱ƂɂĐł܂BvZbTƂ̃Xbh́AgtBbN󋵁A܂́AgtBbN͒ႢNG TCY ViI傫󋵂ł́AptH[}Xɉe܂BőP̌ʂ悤ɁA[U[͒lύXĂ݂Kv܂Blw肷̂́ÃWXgłB

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\W3SVC\Parameters\ADCThreads
ADCThreads ́A[U[ɂĒǉ REG_DWORD ŁAftHgl 6 ŁA͈͂ 1  50 łB50 𒴂lݒ肵ꍇ́Aől 50 gp܂B̃WXg̒lK쐬Kv͂ȂAftHgł́A̒l̓WXgɊ܂܂Ă܂B

4.4 ftHgł́AADO  "S" RDS Server DataFactory IuWFNgƋɃCXg[܂B"S" [hƂ́ÂƂ܂:

1. nh DataFactory ƋɕKvB
   (̓WXg̃L[ݒɂ܂)

2. nh (msdfmap.handler) Sȃnh̃Xgɑ݂AftHg̃nhƂēo^ĂB

3. Msdfmap.ini t@C Windows tH_ɃCXg[ĂBRDS  3 w[hŎgpOɁÃt@CKvɉč\Ȃ΂Ȃ܂B

܂ADataFactory ̐ăCXg[邱Ƃł܂B̏ꍇADataFactory JX^ nhȂŒڎgƂł܂BڑύXāAK{ł͂ȂȂJX^ nhgƂł܂B

nh̃WXg GgSȐݒŃZbgAbv邽߂ handsafe.reg t@Cpӂ܂BSȐݒŎsɂ́Ahandsafe.reg sĂB

nh̃WXg Gg𐧌̂ȂݒŃZbgAbv邽߂ handunsf.reg t@Cpӂ܂B̂Ȃ[hŎsɂ́Ahandunsf.reg sĂB

RDS ̃JX^}CYnhɂĂ̏ڍׂɂẮAhttp://www.microsoft.com/data/techmat.htm (̃TCgɂ͉pŏ񂪋LڂĂ܂) ́uUsing the Customization Handler Feature in RDS 2.0vQƂĂB


4.5 Find \bh́AR[ȟݍs̈ʒuw肳ꂽɁAw肳ꂽo𖞂 Recordset ܂BFind ĂяoOɌ݂̍s̈ʒuݒ肵ȏꍇAG[܂B


4.6 Visual Basic  ADO  FetchProgress  FetchComplete Cxggpɂ́AVisual Basic Version 6.0 ȍ~KvłB


4.7 f[^ VFCv CALC Ɏgp鎟̑́A"Sł" Ɣf܂B

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 ł́AXML tH[}bg pIKw Recordset IuWFNg̓T|[gĂ܂B


4.9  ǂݎ݂̂ Recordset ɂf[^ XML t@CɕҏWۑčXV邱Ƃ͂ł܂BXML f[^ύXĂƁAXML t@C Recordset ēxJƂɃG[܂B


4.10 SQL Server 6.5 Service Pack 4  adUseClient ܂̓[ggpہANGɂ DISTINCT L[[h̎gp͍XV\ȌʃZbgł͖܂B SQL Server ̖łÃT[rX pbNɂ\łB


4.11 wActiveX f[^ IuWFNg vO}[Y t@Xx̃gsbNAuType vpeBv DataTypeEnum l̈ꗗɂ͊ԈႢ܂B

̒ĺAꗗɂ܂񂪎gpł܂B

adChapter     q̍sZbg̍sʂ邽߂Ɏgp 4 oCg `v^l (DBTYPE_HCHAPTER)B

adDBFileTime  t@C̎̒l (DBTYPE_DBFILETIME)B

adFileTime    1601 N 1  1  100 imbPʂ̌oߎԂ\ 64 rbgl (DBTYPE_FILETIME)B

adPropVariant I[g[V PROPVARIANT (DBTYPE_PROP_VARIANT)B

adVarNumeric  l^̒l (Parameter IuWFNĝ)B


4.12 Connection ̃gsbNAuExecute \bhv Options p[^̗LȒl̈ꗗɂ͊ԈႢ܂BExecuteOptionEnum ldĂÂ͎悤ɂȂ܂B

adCmdTable    ADO e[uƂ CommandText ]ACommandText ɖOtꂽe[u炷ׂĂ̍sԂ SQL NG𐶐邱Ƃw肵܂B

 CommandTypeEnum ĺAꗗɂ܂񂪎gpł܂B

adCmdFile     voC_t@CƂ CommandText ]邱Ƃw肵܂B

 ExecuteOptionEnum ĺAꗗɂ܂񂪎gpł܂B

adAsyncFetchNonBlocking   tFb`ɃC XbhubNȂƂw肵܂BvꂽstFb`ȂꍇA݂̍s͎IɃt@C̏I[Ɉړ܂B

adExecuteNoRecords        CommandText AsԂȂ (f[^}邾̃R}hȂ) R}h܂̓XgAh vV[Wł邱Ƃw肵܂BׂĂ̍s擾ꂽꍇAs͔jĕԂ܂B̒ĺA adCmdText ܂ adCmdStoredProc Ƒgݍ킹Ďgp܂B

4.13 Connection IuWFNg̃gsbNAuOpenSchema \bhv QueryType l̈ꗗɂ͊ԈႢ܂B̒ĺAꗗɂ܂񂪎gpł܂B

QueryType l		Criteria l
-----------------------------------------------
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
			c[Zq (LQ)

L̈ꗗ̂AadSchemaCubes  adSchemaMembers ܂ł 7 ̒ĺAf[^ voC_Ŏgp邱ƂɒӂĂBadSchemaMembers ̃c[Zq̒`܂ޏڍׂɂẮAwOLE DB for OLAP vO}[Y t@XxQƂĂB


4.14 wActiveX f[^ IuWFNg vO}[Y t@Xx̃gsbNAuCancelBatchv\bh AffectEnum l̈ꗗɂ͊ԈႢ܂B̒ĺAꗗɂ܂񂪎gpł܂B

adAffectAllChapters     ׂẴ`v^ۗ̕̕ύXLZ܂B


4.15 gsbNAuMode vpeBv ConnectModeEnum l̒萔 adModeShareDenyNone ̐ɂ͊ԈႢ܂B͎̂悤ɂȂ܂B

adModeShareDenyNone	̃[U[́A̎ނɂ炸ڑJƂł܂BǂݎƏ݂̂ǂłĂÃ[U[ۂ邱Ƃ͂ł܂B

4.16 ܂ł̃o[Wł́ARecordset IuWFNgɃCfbNXݒ肳ĂȂꍇ Index vpeB̓G[ԂĂ܂BAMDAC 2.1 Service Pack 1 Ɋ܂܂Ă ADO 2.1 ł͋̕񂪕ԂA͐܂B
