1. 128219405294622177174.zip Driver
2. adoreadm.txt File Contents

adoreadm.txt Driver File Contents (128219405294622177174.zip)

----------------------------------------------------------
Microsoft(R) ActiveX(R) Data Objects version 2.1 Ū§ÚÀÉ®×
----------------------------------------------------------

(c) 1998 Microsoft Corporation. All rights reserved.

¦¹¤å¥ó´£¨Ñ Microsoft ADO ¤â¥Uªº³Ì·s©Î¨ä¥¦¸ê°T¡C

-----
¤º®e
-----

1. ²£«~»¡©ú
   
2. ·s¥\¯à
2.1 ·j´M»P¯Á¤Þ
2.2 ¸ê®Æ¦C§ó·s»P¦P¨B³B²z
2.3 Microsoft OLE DB Persistence Provider
2.4 Microsoft Data Shaping Service for OLE DB
2.5 Microsoft OLE DB Remoting Provider

3. §Þ³Nª`·N¨Æ¶µ
3.1 ¦w¥þ©Ê¼W±j
3.2 ­­¨î©Ê§@·~¤è¦¡ Behavior
3.3 ¦Û­q¦w¥þ©Ê³]©w­È

4. ¤wª¾°ÝÃD¡B­­¨î¡B¸Ñ¨M¤èªk¥H¤Î³Ì·s¤â¥Uª`·N¨Æ¶µ

------------
1. ²£«~»¡©ú
------------

ActiveX Data Objects (ADO) ¬O¥Î©ó¦s¨ú¸ê®Æªº¦Û°Ê¤Æ¤¶­±¡CADO ·|¨Ï¥Î
OLE DB ¤¶­±¨Ó¦s¨ú¼sªxªº¸ê®Æ¨Ó·½¡A¥]¬A¦ý¤£­­©ó³z¹L ODBC ´£¨Ñªº¸ê®Æ¡C

¦]¬° ADO ªº¾ãÅé³]­p¬O§Ú­Ì¬ãµo³o¨Ç¤¶­±¸gÅ窺¦¨ªG¡A©Ò¥H RDO »P DAO 
¨Ï¥ÎªÌÀ³¸Ó«Ü§Ö¦a´N·|¹ï ADO ªºµ{¦¡³]­p·P¨ìº¡·N¡C

Microsoft Remote Data Service (RDS) ¬O ADO ªº¤¸¥ó¡A´£¨Ñ§Ö®Ä¦³®Ä²v
ªº¸ê®Æ³s±µ©Ê¥H¤Î¸ê®Æµo¦æ¬[ºc¡A¨Ñ Microsoft Explorer ªºÀ³¥Îµ{¦¡¨Ï
¥Î¡C¥¦¬O¥H¥D±q¬[ºc¡B¤À´²¦¡§Þ³N¬°°ò¦¡A¥i¥HÀ³¥Î©ó HTTP¡BHTTPS (HTTP
over Secure Sockets Layer)¡A¥H¤Î DCOM À³¥Îµ{¦¡³q°T¨ó©w¡CRDS ¨Ï¥Î
¥i¥H¤À¿ë¸ê®Æªº ActiveX ±±¨î¶µ¡A´£¨Ñ Microsoft Visual Basic (R) §Î
¦¡ªº¸ê®Æ¦s¨úµ{¦¡³]­p¡A¨Ñ»Ý­n¤À´²¦¡¡B¤j¶q³B²z¸ê®Æ¤§À³¥Îµ{¦¡ªº Web
¬ãµo¤H­û¡AÀ³¥Î©ó¥ø·~¤º³¡ºô¸ô (intranet) ©M Internet¡C

----------
2. ·s¥\¯à
----------

ADO 2.1 ´£¨Ñ¬ãµo¤H­û¦h­Ó·s¥\¯à¡C

2.1 ·j´M©M¯Á¤Þ
·j´M¤èªk»P¯Á¤ÞÄÝ©Ê·|·s¼W recordset ¤¤¸ê®Æ¦Cªº§Ö³t¡B¯Á¤Þ¤Æ
¦ì¸m¡C

2.2 ¸ê®Æ¦C§ó·s©M¦P¨B³B²z
·sªº "row fix-up" ¼Ò¦¡¥i¥HÅý¨Ï¥ÎªÌ¦Û­q±±¨î¥Ñ JOIN §@·~«Ø¥ßªº 
recoreset ªº¸ê®Æ¦C§ó·s©M¦P¨B³B²z¡C7 ­Ó·sªº°ÊºAÄÝ©Ê¥i±±¨î 5 
­Ó²{¦³¤èªkªº§@·~¤è¦¡¡C

2.3 Microsoft OLE DB Persistence Provider
Microsoft OLE DB Persistence Provider µ²¦X Recordset ª«¥óªº
Save ©M Open ¤èªk¤§«á¡A¥iÀx¦s recordset ©M¦^´_¦¨ÀɮסC¦b¦¹
ª©¥»¤¤¡Arecordset ¥i¥HÀx¦s¦¨ Extensible Markup Language (XML) ®æ¦¡¡A
³o¬O¤@ºØ©w¸q¨Ï¥ÎªÌ¯S©w¼Ð°Oªº¼Ð·Ç¤èªk¡A¥i¥HÅý¸ê®Æ¶Ç°e¨ì Internet¡C

2.4 Microsoft Data Shaping Service for OLE DB
Microsoft Data Shaping Service for OLE DB ¤ä´©¸ê®Æ Data Shaping¡A
²{¦b¥i¥H¡G

2.4.1 ­«·s§Î¦¨ (Re-shape) ¥ý«e¤w§Î¦¨ªº recordset¡C­n¤ä´©¦¹¥\¯à¡A
recordsets ²{¦b©ó³s½uªº´Á¶¡·|¦s¦b Name ³o­ÓÄÝ©Ê¡C

2.4.2 ²Ö­p¦b¥ô¦ó¼h¯Å§Î¦¨¤§ recordset ªº¸ê®ÆÄæ¡A¤£¶È¥u¬O¤W¼h©ÒÄݪº¤U¼h
¦Ó¤w¡C¦¹¥\¯à·|¨Ï¥Î§¹¾ãªº³¹¸`¦WºÙ¡A²£¥Í§Æ±æ¤§¼h¦¸©M¸ê®Æ¦æªº¸ô®|¡C

2.4.3 °Ñ¼Æ¤Æªº COMPUTE «ü¥O¥i¥H¦b PARAMETER ¤l¥y©M°Ñ¼Æ¤Þ¼Æ¤§¶¡¡A
¦³¥ô·N¼Æ¥Øªº¤z¹w©Ê COMPUTE ¤l¥y¡C

2.5 Microsoft OLE DB Remoting Provider
Microsoft OLE DB Remoting Provider Åܦ¨¼Ð·ÇªºªA°È´£¨ÑªÌ¡A¥¦·|­n¨D¼W
·sªº°ÊºAÄÝ©Ê¡A¥H«K¨ú±o±j¤Æªº®Ä¯à¡BÅý¨Ï¥ÎªÌ§ó¤è«K±±¨î¡B¥i¥H©M ADO 2.0
¦^·¹¬Û®e¡C


----------------
3. §Þ³Nª`·N¨Æ¶µ
----------------

3.1 ¦w¥þ¼W±j

¦¹ª©¥»¥]¬A ADO ©M RDS ª«¥óªº¼W±j¦w¥þ©Ê¡A©Ò¥H·í Internte Explorer
¦b "¦w¥þ" ¼Ò¦¡°õ¦æ®É¡A³¡¥÷ªº§@·~·|³Q¨ü­­¡C

3.1.1. °Ï°ì
±z¥i¥H¦b Internet Explorer 4.0 ªº¤£¦P "°Ï°ì" ³]©w¤£¦Pªº¦w¥þ©Ê¡A
¥H«K¦Û­q³o¨Ç°Ï°ì¤ºªº ADO/RDS ª«¥óªº§@·~¤è¦¡¡C¤U¦C¬O¦b Internet
Explorer 4.0 ©w¸qªº 4 ­Ó°Ï°ì¡G
*  Internet °Ï°ì
*  ªñºÝ intranet °Ï°ì
*  ¨ü­­¨î¯¸¥x°Ï°ì
*  ¨ü«H¥ô¯¸¥x°Ï°ì

3.1.2. ¦w¥þ©Ê¼h¦¸
±z¥i¥H¦b¨C¤@­Ó°Ï°ì¤¤³]©w­n¨Ï¥Îªº¦w¥þ©Ê¼h¦¸¡C¤U¦C¬O¦b¨C­Ó°Ï°ì±Ò°Êªº
¦w¥þ©Ê¼h¦¸¡G
*  °ª
*  ¤¤
*  §C
*  ¦Û­q

©M¥ô¦ó¨ä¥¦ ActiveX ±±¨î¶µ¤@¼Ë¡A¬°¤FÅý ADO/RDS ª«¥ó¥i¥H§¹¥þ¦b Internet
Explorer 4.0 §@¥Î¡A¦w¥þ©Ê¼h¦¸¥²¶·³]©w¦¨ "¤¤" ©Î "°ª"¡C"¦Û­q" ¬O¥Î¨Ó
³]©w ADO/RDS ª«¥ó¨Ó¦b¦w¥þ©Î«D¦w¥þ¼Ò¦¡¤U§@·~¡C

3.2 ­­¨î©Ê§@·~¤è¦¡

´N¹w³]­È¦Ó©w¡AInternet Explorer ªº ADO/RDS ¥ô¦ó«D¦w¥þ§@·~¡A·|¾É­P¨Ï¥Î
ªÌ¦b¦s¨ú "ªñºÝ¨ü«H¥ôªº°Ï°ì" ªººô­¶®É¡A´£¥Ü¨Ï¥ÎªÌ¡C´N¹w³]­È¦Ó©w¡A±q 
"­­¨î©Ê¯¸¥x°Ï°ì" ¸ü¤J¤§ºô­¶¡A´N·|°±¤î ADO/RDS ª«¥ó¤Wªº«D¦w¥þ§@·~¡C
¤U¦C±Ô­z ADO/RDS ¦b³o¨Ç¼Ò¦¡¤U°õ¦æ®Éªº§@·~¤è¦¡¡G

3.2.1 ¦w¥þª«¥ó
¤U¦Cª«¥ó³Qµø¦P "¦w¥þ"¡C³oªí¥Ü¦b 3.2.3 ¸Ô­zªº«D¦w¥þ§@·~¡A
¤£·|¤¹³\¦b¦w¥þÀô¹Ò¤U°õ¦æ (¨Ò¦p¡AInternet Explorer ªº¹w³]­È¡F°£«D "¦Û­q" 
³o­Ó¿ï¶µ³Q¥Î©ó¦b«D¦w¥þ¼Ò¦¡)¡A¦ý¬O¥i¥H¦b«D¦w¥þÀô¹Ò (¨Ò¦p¡AVisual Basic)
¤U°õ¦æ¡C
a. RDS.DataControl object
b. RDS.DataSpace object
c. ADO Recordset object

3.2.2 «D¦w¥þª«¥ó
¤U¦Cª«¥ó³Qµø¦P "«D¦w¥þ"¡C¥¦­Ì¦b¦w¥þÀô¹Ò¤U§@·~®É¡AµLªkª½±µ©Î¶¡±µ«Ø¥ß
¥H¤Î´£¨Ñµ¹¨Ï¥ÎªÌ¡C
a. RDSServer.DataFactory ª«¥ó
b. ADO Connection ª«¥ó
c. ADO Command ª«¥ó

3.2.3 ¦w¥þª«¥ó¤Wªº«D¦w¥þ§@·~
¤U¦C¦b "¦w¥þ" ª«¥ó -- RDS.DataControl¡BRDS.DataSpace¡BADO Recordset
¤W³Qµø¦P«D¦w¥þ§@·~¡C³o¨Ç§@·~¤£³Q¤©³\¦b¦w¥þÀô¹Ò°õ¦æ¡A¦ý¬O¥i¥H¦b«D¦w¥þ
Àô¹Ò°õ¦æ¡C

a. RDS.DataControl
i) ©Ò¦³¦b RDS.DataControl ª«¥ó¤WªºÂù¼h¥H¤Î DCOM ³õ´º¡C³oªí¥Ü±zµLªk
³s±µ¨ì¥»¾÷¾÷¾¹ªº¸ê®Æ®w¡A¦Ó¥B¦pªG¦øªA¾¹¨Ï¥Î DCOM ³q°T¨ó©w¡A¤]µLªk³s±µ
ùØ­±ªº¸ê®Æ®w¡C
ii) ³z¹L HTTP ªº¤T¼h§@·~·|³Q­­¨î¨ìºô­¶¤U¸ü¨Ó·½ªº¦øªA¾¹¡C³oªí¥Ü 
RDS.DataControlAll ª«¥ó¤Wªº Server ÄÝ©Ê¥²¶·µ¥©óºô­¶¤U¸ü¨Ó·½ªº¥D¹q¸£
¦WºÙ (http://server)¡C

b. RDS.DataSpace
i) ©Ò¦³ RDS.DataSpace ª«¥ó¤WªºÂù¼h©M DCOM ³õ´º¡C³oªí¥Ü±zµLªk¨Ï¥Î
RDS.DataSpace ª«¥ó¨Ó©I¥s¥»¾÷¾÷¾¹ªº business ª«¥ó¡A©ÎªÌ³z¹L DCOM ³q
°T¨ó©w©I¥s bussiness ª«¥ó¡C
ii) ©Ò¦³³z¹L HTTP ªº¤T¼h³õ´º·|³Q­­¨î¨ìºô­¶¤U¸ü¨Ó·½ªº¦øªA¾¹¡C³oªí¥Ü
DataSpace ª«¥ó¤W¡ACreateObject ¤èªkªº²Ä¤G­Ó°Ñ¼Æ¡A¥²¶·«ü¦Vºô­¶¤U¸ü¨Ó
·½ªº¦P¤@­Ó¦øªA¾¹¡C

c. ADO Recordset
i) ¦b´£¨ÑªÌ¤£¬O MS Remote ªº¦a¤è«Ø¥ß³s½u¡C¦]¦¹³s½u¦r¦êªº¶}ÀY¥²¶·¬O
"Provider=MS Remote"¡C³s½u¦r¦êªº "Remote Server" ¼Ð°O¤]¥²¶·»Pºô­¶¤U
¸ü¨Ó·½¤§¦øªA¾¹ªº¦WºÙ¬Û¦P¡C¥»¾÷Âù¼h©M DCOM ³s½u¤£³Q¤¹³\¡C
ii) Local Persistence §@·~´N¹³¬O±N recordset Àx¦s¨ìÀɮרt²Î (filesystem)¡A
µM«á±q¥»¾÷¾÷¾¹ªºÀɮ׶}±Ò recordset¡C

3.3 ¦Û­q¦w¥þ©Ê

ADO/RDS §@·~¤è¦¡¬O¥Ñ "°_©l¦ý ActiveX ±±¨î¶µ¤£¼Ð¥Ü¬°¦w¥þ" ¿ï¶µªº³]©w
¨Ó±±¨î¡C±z¥i¥HÅܧó¯S©w°Ï°ìªº¦w¥þ©Ê¼h¦¸¡Cintranet °Ï°ìªº "°_©l¦ý ActiveX
±±¨î¶µ¤£¼Ð¥Ü¬°¦w¥þ" ¹w³]­È¦p¤U¡G
¦w¥þ©Ê¼h¦¸ = °ª		­È = "Ãö³¬"
¦w¥þ©Ê¼h¦¸ = ¤¤		­È = "Ãö³¬"
¦w¥þ©Ê¼h¦¸ = §C		­È = "´£¥Ü"

¦pª¾¹D¨ä¥¦¦w¥þ°Ï°ìªº¹w³]­È¡A½Ð°Ñ¾\ Internet Explorer ¤â¥U¡C

Åܧó¦w¥þ©Ê¼h¦¸¤§«á¡A´N·|Åܧó¤¤Â_ªº ADO Recordset ª«¥ó¦bÂsÄý¾¹ªº°õ¦æ
§@·~¤è¦¡¡C¦pªG·Q±Ò°Ê«D¦w¥þ§@·~¡A¦ý¤£·Q¨C¦¸°õ¦æÃþ¦ü§@·~®É´N³Q¹q¸£´£¥Ü¡A
«h¥²¶·©ú½T±N¤W­z¿ï¶µªº­È³]¦¨ "±Ò°Ê"¡C¥t¥~¤]½Ðª`·N¡G
¦pªG¦b ADO Recordset ¤W°õ¦æ«D¦w¥þ§@·~ (¨Ò¦p±N Recordset
Àx¦s¨ì¥»¾÷Àɮרt²ÎªºÀÉ®×)¡A¦ý¬O ADO Recordset ¬O±q RDS DataControl ¨ú±o
ªº¸Ü¡A´N¥²¶·±N¤W­z¿ï¶µªº­È³]¦¨ "±Ò°Ê"¡C"´£¥Ü" ªº³]©w­È¥\¯à©M Recordset 
ª«¥ó (±q RDS.Datacontrol ¨ú±o) ªº "Ãö³¬" ¤@¼Ë¡C

±z¥i¥Hª½±µ±±¨î¤W­z¿ï¶µªº¦Û­q­È¡A§ïÅܹw³]­È¡C±z¥i¥H¨M©w¥þ³¡Ãö³¬«D¦w¥þ
§@·~ (¦p¤W©Ò­z)¡A©ÎªÌ«ü©w¥ô¦ó®É­Ô°õ¦æÃþ¦ü§@·~®É´NÅã¥Üĵ§i¡A©ÎªÌ±Ò°Ê
Ãþ¦ü§@·~¦Ó¤£Åã¥Üĵ§i¡C±z¥i¥H³]©w¤£¦P¦w¥þ°Ï°ìªº¦Û­q­È¡C±z¥²¶·¨Ï¥Î¤U¦C¨BÆJ
¨Ó¦Û­q¯S©w¦w¥þ°Ï°ìªº¦w¥þ­È¡G

ª`·N¡G½Ð°O¦í±Ò°Ê "°_©l¦ý ActiveX ±±¨î¶µ¤£¼Ð¥Ü¬°¦w¥þ" (¤U­±ªº¨BÆJ 5) ®É¡A
´Nªí¥Ü¤¹³\¥ô¦ó ActiveX ±±¨î¶µ (µL½×¦w¥þ©Î«D¦w¥þ)¡A³Q¨Ï¥Î¦b Web ºô­¶ 
(¦p¦¹¥i¯à·|³y¦¨¨Ï¥ÎªÌ¾÷¾¹¼ÉÅS©ó¥Î³~¤£¨}ªº±±¨î¶µ©Î scripting µ{¦¡½X)¡C
«Øij±z¥u¯à¦b "intranet" ©Î "¨ü«H¥ô¯¸¥x" ¦w¥þ°Ï°ì¡A¦Ó¤£¬O¦b "Internte"
°Ï°ì³o¼Ë°µ¡C

1. ¦b Internet Explorer 4.0 ªº [À˵ø] ¥\¯àªí¿ï¾Ü [Internet ¿ï¶µ]¡A
Åã¥Ü [Internet ¿ï¶µ] ¹ï¸Ü¤è¶ô¡C¿ï¾Ü [¦w¥þ©Ê] ¼ÐÅÒ¡C
2. ±q [°Ï°ì] ¤U©Ô²M³æ¿ï¾Ü­n¦Û­qªº°Ï°ì¡C
3. ¬°©Ò¿ïªº°Ï°ì¿ï¾Ü [¦Û­q]¡C³o¼Ë·|±Ò°Ê¹ï¸Ü¤è¶ôªº [³]©w­È] «ö¶s¡C
4. «ö [³]©w­È] Åã¥Ü [¦w¥þ©Ê³]©w­È] ¹ï¸Ü¤è¶ô¡C
5. ¦pªG·Q±Ò°Ê ADO/RDS ª«¥ó¤Wªº«D¦w¥þ§@·~ (¦p 3.2.3 ©Ò­z)¡A¦ý
¤£·QÅã¥Ü¥ô¦óĵ§i¡A½Ð¦b [¦w¥þ©Ê³]©w­È] ¹ï¸Ü¤è¶ô¤¤¬° [°_©l¦ý ActiveX 
±±¨î¶µ¤£¼Ð¥Ü¬°¦w¥þ] ¿ï¶µ¿ï¾Ü [±Ò°Ê]¡C«ö [½T©w]¡C
6. ¦pªG¥ô¦ó®É­Ô¦b ADO/RDS ª«¥ó¤W°õ¦æ«D¦w¥þ§@·~ (¦p 3.2.3 ©Ò­z) ®É
­nÅã¥Üĵ§i¡A½Ð¦b [¦w¥þ©Ê³]©w­È] ¹ï¸Ü¤è¶ô¤¤¬° [°_©l¦ý ActiveX 
±±¨î¶µ¤£¼Ð¥Ü¬°¦w¥þ] ¿ï¶µ¿ï¾Ü [´£¥Ü]¡C«ö [½T©w]¡C
7. ¦pªG·Q§¹¥þÃö³¬ ADO/RDS ª«¥ó¤Wªº«D¦w¥þ§@·~ (¦p 3.2.3 ©Ò­z)¡A
½Ð¦b [¦w¥þ©Ê³]©w­È] ¹ï¸Ü¤è¶ô¤¤¬° [°_©l¦ý ActiveX 
±±¨î¶µ¤£¼Ð¥Ü¬°¦w¥þ] ¿ï¶µ¿ï¾Ü [Ãö³¬]¡C«ö [½T©w]¡C
8. »Ý­n®É½Ð­«½Æ³o¨Ç¨BÆJ¡A¬°¨ä¥¦¦w¥þ°Ï°ì¦Û­q¦w¥þ³]©w­È¡C
9. «ö [½T©w]¡C

²{¦b ADO/RDS ª«¥ó·|¦b«ü©wªº¦Û­q¼Ò¦¡§@·~¡C³o¨Ç³]©w­È·|¼vÅT¤U¦Cªº 
ADO/RDS ª«¥ó§@·~¤è¦¡ (¦p 3.2.3 ©Ò­z) -- ¶}±ÒªñºÝÂù¼h³s½u¡F¦b DCOM
§@·~¡B³s½u¨ìºô­¶¤U¸ü­ì©l¨Ó·½¥H¥~ªº¦øªA¾¹¡BÀx¦s©M¶}±Ò¥»¾÷¾÷¾¹Àɮתº 
recordset¡C

¦pªG±z±N¦Û­q¿ï¶µ³]¦¨ [´£¥Ü]¡A«h¦b ADO/RDS ª«¥ó°õ¦æ«D¦w¥þ§@·~®É¡A
´N·|Åã¥Ü¤U¦Cĵ§i¡G

"µe­±¬O±q¨ä¥¦¦ì§}¤Wªº¸ê®Æ¨Ó·½¦s¨ú¡C±z¤¹³\³o¼Ë°µ?" ¨Ï¥ÎªÌ¥i¥H¦^
µª [¬O] ©Î [§_]¡C¦pªG¦^µª [¬O]¡A§@·~·|§¹¦¨¡A¦pªG¦^µª [§_]¡A§@·~
´N·|¥¢±Ñ¡C

------------------------------------------------
4. ¤wª¾°ÝÃD¡B­­¨î¡B¸Ñ¨M¤èªk¥H¤Î³Ì·s¤â¥Uª`·N¨Æ¶µ
------------------------------------------------

4.1 ¥Ñ©ó¨t²Î¨t²Î¤£¤ä´©¡A©Ò¥H¦b RDS «Ø¸mªº¥Î¤áºÝ¥Ø«e¤£³Q¤ä´©¡C

4.2 «Ø¥ß "µêÀÀ¦øªA¾¹" ®É¡A»Ý­n°õ¦æ¤U¦C¨â­ÓÃB¥~¨BÆJ¡A¤~¯à±N¦øªA¾¹
³]©w¦¨¥i¥H»P RDS ¦@¦P§@·~¡G

A) ³]©w¦øªA¾¹ªº®É­Ô¡A½Ð¿ï¾Ü [¤¹³\°õ¦æÀɦs¨ú]¡C
B) ±N msadcs.dll ²¾¨ì vroot\msadc¡A¨ä¤¤ vroot ¬OµêÀÀ¦øªA¾¹ªº¥D¥Ø¿ý¡C


4.3 ¦b IIS ¦øªA¾¹¨Ï¥Î RDS ªº®É­Ô¡A¨C¤@­Ó³B²z¾¹«Ø¥ßªº°õ¦æºü¼Æ¥Ø¡A¥i¥H³z
¹L±±¨î Web ¦øªA¾¹ªº¨t²Îµn¿ý¨Ó¥[¥H±±¨î¡C¨C¤@­Ó³B²z¾¹ªº°õ¦æºü¼Æ¥Ø·|¼vÅT
¬y¶q¬Û·í¤jª¬ªp©Î¬y¶q§C¦ý¬d¸ß¤j¤p³õ´º«Ü¤j®É¡Aµ¥µ¥ª¬ªp¤Uªº®Ä¯à¡C¨Ï¥ÎªÌÀ³
¸Ó¸g¹L¹êÅç«á¨ú±o³Ì¨Îµ²ªG¡C¯S©w­n½Õ¾ãªº­È¬°¡G

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

¨ä¤¤ ADCThreads ¬O¨Ï¥ÎªÌ·s¼Wªº REG_DWORD¡A¥¦ªº¦³®Ä­È½d³ò¬O 1 ¨ì 50¡A¹w³]­È
¬O 6¡C¦pªG¨t²Îµn¿ý¾÷½X«ü©wªº­È¤j©ó 50¡A«h·|¨Ï¥Î³Ì¤j­È 50¡C¨Ï¥ÎªÌ¤£¶·«Ø¥ß
³o­Ó¨t²Îµn¿ý­È¡F´N¹w³]­È¦Ó©w¡A¨Ã¤£·|±N¥¦¥[¨ì¨t²Îµn¿ý¡C

4.4 ´N¹w³]­È¦Ó©w¡AADO ·|¥Î "¦w¥þ" ªº RDS Server DataFactory ²ÕºA¦w¸Ë¡C
RDS Server §¹¥óªº¦w¥þ¼Ò¦¡ªí¥Ü¤U¦C¬°¯u:

	1. DataFactory »Ý­n³B²z±`¦¡
	   (³o¥Ñ¨t²Îµn¿ý¾÷½X³]©w±±¨îªº)

	2. »Ý­n§Ú­Ìªº¹w³]³B²z±`¦¡ - msdfmap.handler Åã¥Ü¦b¦w¥þ³B²z±`¦¡
           ²M³æ¤¤¡A¼Ð¥Ü¬°¹w³]ªº³B²z±`¦¡¡C

	3. Msdfmap.ini Àɮ׬O¦w¸Ë¦b Windows ¥Ø¿ý¡C±z¥²¶·¦b²Ä¤T¼h¼Ò¦¡¨Ï¥Î 
           RDS ¤§«e¡A¥ý®Ú¾Ú±zªº»Ý­n³]©w¦¹ÀɮסC

±z¥i¥Hµø±¡ªp³]©w­­¨îªº DataFactory ¦w¸Ë¡CDataFactory ¥i¥Hª½±µ¨Ï¥Î¤£»Ý­n
¦Û­q³B²z±`¦¡¡C¨Ï¥ÎªÌ¤´µM¥i¥H­×§ï³s±µ¦r¦ê¨Ó¨Ï¥Î¦Û­q³B²z±`¦¡¡A¤£¹L¨Ã»Ý­n³o
¼Ë°µ¡C

§Ú­Ì¤w¸g´£¨Ñ¨t²Îµn¿ýÀÉ handsafe.reg ¨Ó³]©w¦w¥þ²ÕºAªº³B²z±`¦¡¨t²Îµn¿ý¶µ¥Ø¡C
­n¦b¦w¥þ¼Ò¦¡¤U°õ¦æ¡A½Ð°õ¦æ handsafe.reg¡C 

§Ú­Ì´£¨Ñ¤F¨t²Îµn¿ýÀÉ handunsf.reg ¨Ó³]©w¥¼­­¨î©Ê²ÕºAªº³B²z±`¦¡¨t²Îµn¿ý¶µ¥Ø¡C
­n¦b¥¼­­¨î©Ê¼Ò¦¡¤U°õ¦æ¡A½Ð°õ¦æ handunsf.reg¡C

¦p»ÝÃö©ó¨Ï¥Î RDS ªº¦Û­q³B²z±`¦¡¸Ô²Ó¸ê°T¡A½Ð°Ñ¾\§Þ³N¤å³¹  "Using the 
Customization Handler Feature in RDS 2.0"¡Aºô§}¬O 
http://www.microsoft.com/data/techmat.htm

4.5 Find ¤èªk·|«ö·Ó«ü©wªº¤è¦V¡A±q¥Ø«eªº¸ê®Æ¦C¦ì¤@·j´M²Å¦X«ü©w±ø¥óªº 
Recordset¡C­Y¦b©I¥s Find ¤§«e¥¼³]©w¥ô¦ó¥Ø«eªº¸ê®Æ¦C¦ì¸m¡A´N·|µo¥Í¿ù»~¡C

4.6 ­n¦b Visual Basic ¨Ï¥Î ADO FetchProgress ¥H¤Î FetchComplete Events¡A
¦Ü¤Ö­n¦w¸Ë Visual Basic version 6¡C


4.7
¤U¦C§@·~·|µø¦P¥i¥H "¦w¥þ" ¥Î©ó Data Shaping CALC ¹Bºâ¦¡¡G

Abs¡BAsc¡BAtn¡BCBool¡BCByte¡BCCur¡BCDate¡BCDbl¡BChr¡BChrB¡BChrW¡BChr$¡B
ChrB$¡BCInt¡BCLng¡BCos¡BCSng¡BCStr¡BCvar¡BCVDate¡BCVErr¡BDate¡BDate$¡B
DateAdd¡BDateDiff¡BDatePart¡BDateSerial¡BDateValue¡BDay¡BDDB¡BError¡B
Error$¡BExp¡BFix¡BFormat¡BFormat$¡BFV¡BHex¡BHex$¡BHour¡BIIF¡BInStr¡BInt¡B
IPmt¡BIRR¡BIsDate¡BIsEmpty¡BIsError¡BIsNull¡BIsNumeric¡BIsObject¡BLCase¡B
LCase$¡BLeft¡BLeftB¡BLeft$¡BLeftB$¡BLen¡BLog¡BLTrim¡BLTrim$¡BMid¡BMid$¡B
Minute¡BMIRR¡BMonth¡BNow¡BNPer¡BNPV¡BOct¡BOct$¡BPmt¡BPPmt¡BPV¡BQBColor¡B
Rate¡BRGB¡BRight¡BRightB¡BRight$¡BRightB$¡BRnd¡BRTrim¡BRTrim$¡BSecond¡B
Sgn¡BSin¡BSLN¡BSpace¡BSpace$¡BSqr¡BStr¡BStr$¡BStrComp¡BStrConv¡BString¡B
String$¡BSYD¡BTan¡BTime,Time$¡BTimer¡BTimeSerial¡BTimeValue¡BTrim¡BTrim$¡B
TypeName¡BUCase¡BUCase$¡BVal¡BVarType ¡BWeekday¡BYear

4.8 ADO 2.1 ¤£¤ä´© XML ®æ¦¡ªº«O¯d©ÊÄ~©Ó¦¡ Recordset ª«¥ó¡C 

4.9  ±zµLªk±N¸ê®ÆÀx¦s¨ì XML¡AµM«á½s¿è XML ÀɮסAÂǦ¹§ó·s°ßŪ Recordset
¤ºªº¸ê®Æ¡C·í±z·Q­«·s¶}±Ò XML ªº Recordset¡A¦ý¬O XML ¸ê®Æ¤w¸gÅܧó®É¡A
´N·|µo¥Í¿ù»~¡C

4.10 ¦b SQL Server 6.5 Service Pack 4 ¨Ï¥Î adUseClient ©Î»·ºÝ¥\¯à®É¡A
¦b¬d¸ß¤¤¨Ï¥Î DISTINCT ÃöÁä¦rµLªk¦b¥i§ó·sªºµ²ªG¶°³Q³B²z¡C³o¬O SQL Server
°ÝÃD¡A·|¦b¥H«áªº service pack ¸Ñ¨M¡C


4.11 ¦b ActiveX Data Objects Programmer's Reference ¤@®Ñ¤¤ Type Property 
¥DÃD¤U©Ò¦C¥Xªº DataTypeEnum ­È¦³¤@¨Ç¿ù»~¡C¨ä¤¤¦³¦C¥X¤U¦C enum ­È¡A¦ý¬O
¨ä¹ê¤£¦s¦b¥BµLªk¨Ï¥Î¡G

adArray, adByRef, adVector

¤U¦C­È¨S¦³¦C©ó²M³æ¤¤¡A¦ý¬O¨ä¹ê¦s¦b¥B¥i¥H¨Ï¥Î¡G

adChapter     ¬O 4 ¦ì¤¸²Õªº chapter ­È¡A¥Î©ó¿ëÃѤl¸ê®Æ¦C¶°¤¤ªº¸ê®Æ¦C 
		(DBTYPE_HCHAPTER)¡C

adDBFileTime  ¬OÀɮתº®É¶¡­È (DBTYPE_DBFILETIME)¡C

adFileTime    ¬O 64 ¦ì¤¸²Õªº­È¡A¥Nªí±q 1601 ¦~ 1 ¤ë 1 ¤é°_ªº 
		100-nanosecond ®É¶¡¶¡¹jªº¼Æ¥Ø (DBTYPE_FILETIME)¡C

adPropVariant ¬O Automation PROPVARIANT (DBTYPE_PROP_VARIANT)¡C

adVarNumeric  ¬O¼Æ­È (¶È¾A¥Î©ó°Ñ¼Æª«¥ó)¡C

4.12  Connection »P Command ª«¥ó Execute ¤èªkªº Options °Ñ¼Æ¦³®Ä­È²M³æ¥]§t
¤@¨Ç¿ù»~¡C¤U¦C ExecuteOptionEnum ­È¦C¥X¨â¦¸¬O¤£¥¿½Tªº¡CÀ³¸Ó¥u¦C¥X¤@¦¸¡A¨Ò¦p¡G

adCmdTable    ªí¥Ü ADO ­pºâ CommandText ªº©Ò±oÀ³¬°¸ê®Æªí¦WºÙ¡A¥B²£¥Í SQL 
¬d¸ß¡A¶Ç¦^ CommandText ¤¤©Ò©R¦Wªº©Ò¦³¸ê®Æ¦C¡C

¤U¦C CommandTypeEnum ­È¨S¦³¦C©ó²M³æ¡A¦ý¬O½T¹ê¦s¦b¥B¥i¥H¨Ï¥Î¡G

adCmdFile     ªí¥Ü´£¨ÑªÌ­pºâ CommandText ªº©Ò±o¥²¶·¬°ÀɮצWºÙ¡C

¤U¦C ExecuteOptionEnum ­È¨S¦³¦C©ó²M³æ¡A¦ý¬O½T¹ê¦s¦b¥B¥i¥H¨Ï¥Î¡G

adAsyncFetchNonBlocking   ªí¥Ü·í¶i¦æ¨ú±o®É¡A¥D°õ¦æºü¥Ã»·¤£·|³Q¤¤Â_¡C¦pªG©|¥¼
¨ú±o­n¨Dªº¸ê®Æ¦C¡A«h·|¦Û°Ê±N¥Ø«eªº¸ê®Æ¦C²¾¨ìÀɮתº§ÀºÝ¡C

adExecuteNoRecords        ªí¥Ü CommandText ¬O«ü¥O©Î¬O¤£¶Ç¦^¸ê®Æ¦Cªº¹w¦sµ{§Ç 
(¨Ò¦p¡A¥u´¡¤J¸ê®Æªº«ü¥O)¡C¦pªG±µ¦¬¨ì¥ô¦ó¸ê®Æ¦C¡A±N·|³Q©¿²¤¨Ã¥B¤£·|¦^¶Ç¡C¤@©w
¬O»P adCmdText ©Î adCmdStoredProc ·f°t¨Ï¥Î¡C 

4.13 Connection ª«¥ó OpenSchema ¤èªkªº QueryType Enum ­È²M³æ¥]§t¤@¨Ç¿ù»~¡C
¤U¦C­È¨S¦³¦C©ó²M³æ¤¤¡A¦ý¬O¨ä¹ê¦s¦b¥B¥i¥H¨Ï¥Î¡G

Enum			­­¨îÄæ¦ì

adSchemaDBInfoKeywords	µL

adSchemaDBInfoLiterals	µL

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
			¤TºØ¹Bºâ¤l (½Ð°Ñ¨£¤U¦C»¡©ú)

ª`·N³Ì«á¤C¶µ Enum ­È (adSchemaCubes ¨ì adSchemaMembers) À³¸Ó»P¦hºû«×
¸ê®Æ¨ÑÀ³ªÌ·f°t¨Ï¥Î¡C­Y»Ý¦³Ãö¥]¬A adSchemaMembers ¤TºØ¹Bºâ¤l­­¨î©w¸qªº
¸Ô²Ó¸ê°T¡A½Ð°Ñ¨£ OLE DB for OLAP Programmer's Reference¡C

4.14 ¦C©ó ActiveX Data Objects Programmer's Reference ¤@®Ñ¤¤ CancelBatch 
¤èªk¥DÃDªº AffectEnum ­È¦³¤@¨Ç¿ù»~¡C¤U¦C­È¨S¦³¦C©ó²M³æ¤¤¡A¦ý¬O¨ä¹ê¦s¦b
¥B¥i¥H¨Ï¥Î¡G

adAffectAllChapters     ¨ú®ø¹ï©Ò¦³ chapter ÀÁ¸mªºÅܧó¡C


4.15 ¦b Mode ÄÝ©Ê¥DÃD¤¤ªº adModeShareDenyNone ConnectModeEnum ­È±Ô­z¤£
¥¿½T¡A¥¿½T±Ô­z¬O:

adModeShareDenyNone	¤¹³\¾Ö¦³¥ô¦óÅv­­ªº¤H¶}±Ò³s½u¡C"Ū¨ú" ©Î "¼g¤J" Åv
­­¬Ò¤£·|³Q¨ä¥L¤H©Úµ´¡C

4.16 ¥ý«e­Y¨S¦³¦b Recordset ª«¥ó¤W³]©w¯Á¤Þ¡A[¯Á¤Þ] ¤º®e·|¶Ç¦^¿ù»~°T®§¡C
MDAC 2.1 Service Pack 1 ¤¤ªº ADO 2.1 ·|¦b¦¹±¡ªp¤U¶Ç¦^ªÅ¥Õ¦r¦ê¡A¨Ã¥i¦¨¥\
³B²z§@·~¡C