- Microsoft Knowledge Base Bank - ADO
 
Aqui temos links para vários artigos(listei os que achei mais úteis) da Knowledge  Base da Microsoft sobre ADO e RDS.

Muitas vezes basta uma consulta e já  ganhamos o dia , principalmente quando temos uma dúvida ou problema solucionado. Vale a pena ficar de olho na Knowledge Base. 

Documentos
      Q242049 - Versions: ADO20 ADO21 VB6 Level: Beginner
     
DOC: Constant Values Incorrect for CursorLocationEnum
      Q198662 - Versions: VB6 Level: Intermediate
     
DOC: Undocumented SynonymType Property Value for Oracle Synonyms
      Q196956 - Versions: VB6 Level: Beginner
     
DOC: Visual Basic Does Not Allow You to Build OLE DB Providers
      Q234816 - Versions: Win98 ADOMD Level: Intermediate
     
Microsoft Windows 98 Second Edition Adomdrd.txt File Contents
      Q234817 - Versions: Win98 ADO21 RDS Level: Intermediate
     
Windows 98 Second Edition README for ActiveX Data Objects
Como fazer:
      Q258038 - Versions: VB6 ADO25 SS65 SS7 Level: Intermediate
     
HOWTO: Access and Modify SQL Server BLOB Data by Using the ADO Stream Object
      Q200190 - Versions: VBS VB6 IIS4 IIS5 Level: Beginner
     
HOWTO: Call a Parameterized Query to an Access Database with ADO
      Q230501 - Versions: VB6 ADO21 Level: Intermediate
     
HOWTO: Compacting Microsoft Access Database via ADO
      Q183621 - Versions: VB5 VB6 Level: Intermediate
     
HOWTO: Configure SQL Server Security via RDO and ADO
      Q190727 - Versions: VB6 Level: Intermediate
     
HOWTO: Control Your Updates in ADO Via "Update Criteria"
      Q259379 - Versions: VB6 ADO20 ADO21 ADO25 Level: Intermediate
     
HOWTO: Develop with ADO Version 2.5 and Install on ADO Version 2.0
      Q237844 - Versions: VB6 Level: Intermediate
     
HOWTO: Enable ODBC Connection Pooling in a Visual Basic ADO Application
      Q184397 - Versions: VB6 Level: Beginner
     
HOWTO: Getting ADO Disconnected Recordsets in VBA/C++/Java
      Q240317 - Versions: ADO21 VB6 Level: Intermediate
     
HOWTO: Implement Multiuser Custom Counters in Jet 4.0 and ADO 2.1
      Q187289 - Versions: VB5 VB6 Level: Intermediate
     
HOWTO: Implement Nested Transactions with Oracle
      Q228843 - Versions: VB6 Level: Beginner
     
HOWTO: Implement Session Pooling from Visual Basic ADO Program
      Q216149 - Versions: WinNT Level: Intermediate
     
HOWTO: Install ODBC or MDAC on Terminal Server
      Q200886 - Versions: VB6 Level: Intermediate
     
HOWTO: Invoke a Login Prompt when Opening an ADO Connection
      Q241202 - Versions: VB6 Level: Intermediate
     
HOWTO: Make a Manufactured Hierarchical Recordset From Another
      Q228451 - Versions: VB5 VB6 Level: Beginner
     
HOWTO: Navigate ADO Recordset w/o Saving Changes to Current Rec
      Q174223 - Versions: VB6 SS7 Level: Intermediate
     
HOWTO: Refresh ADO Parameters Collection for a Stored Procedure
      Q180368 - Versions: VB5 VB6 Level: Intermediate
     
HOWTO: Retrieve and Update a SQL Server Text Field Using ADO
      Q176086 - Versions: VB5 VB6 Level: Beginner
     
HOWTO: Retrieve Recordsets from Oracle Stored Procs Using ADO
      Q194792 - Versions: VB6 Level: Intermediate
     
HOWTO: Retrieve Values in SQL Server Stored Procedures w/ ADO
      Q221931 - Versions: IIS4 IIS5 VB6 VBS Level: Intermediate
     
HOWTO: Return Record's Autonumber Value Inserted into Access DB
      Q234218 - Versions: VB6 MTS Level: Intermediate
     
HOWTO: Reusing ADO Connections Within MTS Transactions
      Q238949 - Versions: SS65 SS7 VB6 Level: Intermediate
     
HOWTO: Set the SQL Server Network Library in an ADO Connection String
      Q200300 - Versions: VB6 Level: Intermediate
     
HOWTO: Synchronize Writes and Reads with the Jet OLE DB Provider and ADO
      Q192716 - Versions: VB5 VB6 Level: Intermediate
     
HOWTO: Update More Than 40 fields in an Access (Jet) Database
      Q251021 - Versions: VB6 ADO21 ADO25 Level: Intermediate
     
HOWTO: Update Stored Procedures with Joined Tables Using ADO
      Q249718 - Versions: VB6 ADO25 Level: Intermediate
     
HOWTO: Use ADO to Determine the Tables Contained in a DBC
      Q240222 - Versions: ADO21 VB6 Level: Intermediate
     
HOWTO: Use ADO to Refresh/Create Linked Table for Password Secured Jet 4.0 Database
      Q194005 - Versions: IIS4 IIS5 ADO25 Level: Intermediate
     
HOWTO: Use ADO to Return a Summary Row
      Q189680 - Versions: VB6 ADO20 Level: Beginner
     
HOWTO: Use Data Link Files with ADO 2.0
      Q218600 - Versions: VB6 Level: Intermediate
     
HOWTO: Use Data Links to Create a Connection String at Run-Time
      Q262311 - Versions: VB6 Level: Intermediate
     
HOWTO: Use the ADO FetchProgress and FetchComplete Events
      Q240838 - Versions: ADO20 ADO21 VB6 Level: Intermediate
     
HOWTO: Use the MSRemote Provider Through Client Script
      Q186265 - Versions: VB5 VB6 Level: Intermediate
     
HOWTO: Use the SQL Server DATEPART Function to Get Milliseconds
      Q201888 - Versions: VB6 Level: Intermediate
     
HOWTO:0: How to Create a Jet CHECK Constraint
Exemplos
      Q197916 - Versions: VB6 Level: Intermediate
     
SAMPLE: AdoGUIDz.exe How to Use GUIDs w/ Access,SQL 6.5 & SQL 7
      Q200122 - Versions: VB6 ADO20 Level: Intermediate
     
SAMPLE: ATL2ADO.exe Returns Disconnected ADO Recordset
      Q252317 - Versions: VB6 SS7 Level: Intermediate
     
SAMPLE: Rowlock.exe Demonstrates Row-Level Locking Using ADO & SQL Server
Correções
      Q221184 - Versions: VB6 ADO21 Level: Beginner
     
FIX: Access Bit Fields and MDAC 2.1
      Q264687 - Versions: VB6 SS7 Level: Intermediate
     
FIX: ADO Applications Report a Syntax Error When Column Names Contain Spaces
      Q230276 - Versions: VB6 ADO20 ADO21 Level: Intermediate
     
FIX: ADO Recordset GetString() Function Throws an Access Violation in Oleaut32.dll
      Q216875 - Versions: ADO20 ADO21 Level: Beginner
     
FIX: ADO Recordset Sort Property Errors
      Q244962 - Versions: ADO21 ADO25 SS7 Level: Intermediate
     
FIX: Calling a Stored Procedure with Text/Image Parameters using ADO May Cause an Access Violation
      Q175264 - Versions: ADO2 ADO25 Level: Advanced
     
FIX: CommandTimout Property Problem with Connection Object
      Q240341 - Versions: ADO21 VB6 Level: Intermediate
     
FIX: Creating Fabricated Hierarchical Recordset Fails Using MDAC 2.1SP2
      Q230101 - Versions: VB6 Level: Beginner
     
FIX: Data Queries Sporadically Return Empty Recordsets
      Q223180 - Versions: VB6 Level: Intermediate
     
FIX: DB_E_ERRORSOCCURRED from Jet Provider During OpenDataSource
      Q249350 - Versions: VB6 ADO21 ADO25 Level: Intermediate
     
FIX: Error Messages "Change Canceled During Notification..." (MDAC 2.1) or "Operation Was Canceled" (MDAC 2.5)
      Q230487 - Versions: VB6 ADO21 Level: Intermediate
     
FIX: Marshaling ADO Recordset Out-of-Process Causes Small Memory Leak
      Q245343 - Versions: VB5 VB6 Level: Intermediate
     
FIX: MDAC 2.1 SP1 Problem Executing Access Query with Wildcard
      Q236574 - Versions: VB6 ADO21 Level: Intermediate
     
FIX: Memory Leak When Field in Recordset Has More Than 16K of Data
      Q236624 - Versions: VB6 ADO20 ADO21 Level: Intermediate
     
FIX: Navigating Through an ADO Recordset Clone May Generate Error -2147217885
      Q223068 - Versions: VB5 VB6 Level: Beginner
     
FIX: RDO InfoMessage Event Behavior Different in VB6 and VB5
      Q188558 - Versions: SS65 ADO20 ADO21 Level: Intermediate
     
FIX: Stored Procedure Invocation Returns "Protocol Error in TDS"
      Q237492 - Versions: VB6 Level: Beginner
     
FIX: Trailing Zeros Truncated with ADO OLEDB Provider for ODBC
      Q228935 - Versions: VB6 Level: Intermediate
     
FIX: Uninitialized String Variables, Empty String Values, Jet Provider, and Errors Occurred
 

Microsoft Knowledge Base  - RDS

RDS - Remote Data Services
COMO FAZER:
      Q250536 - Versions: VB6 Win2K Level: Intermediate
     
HOWTO: Configure RDS for Windows 2000
      Q166277 - Versions: VB5 VB6 Level: Intermediate
     
HOWTO: Create a VB Component that Returns a Recordset in RDS
      Q231346 - Versions: VB5 VB6 Level: Intermediate
     
HOWTO: Log RDS Run-Time Errors
      Q266886 - Versions: VB6 Level: Intermediate
     
HOWTO: Use a Remote Data Service (RDS) Handler with an RDS Data Control
      Q259533 - Versions: VB5 VB6 IIS4 IIS5 Level: Intermediate
     
HOWTO: Use an ASP Page as a Data Source for an RDS Data Control
      Q165297 - Versions: VB5 VB6 Level: Intermediate
     
HOWTO: Use RDS From Inside a Visual Basic Program
      Q247865 - Versions: MTS VB5 VB6 Level: Intermediate
     
HOWTO: Use RDS to Access MTS Components Over the Internet
      Q184630 - Versions: VB6 Level: Intermediate
     
HOWTO: Use RDS Within a Visual Basic ActiveX Document

Com a palavra The Mother´s Invention...

Veja os Destaques e novidades do SUPER DVD Visual Basic (sempre atualizado) : clique e confira !

Quer migrar para o VB .NET ?

Quer aprender C# ??

Quer aprender os conceitos da Programação Orientada a objetos ?

 

 

             Gostou ?   Compartilhe no Facebook   Compartilhe no Twitter
 

Referências:


José Carlos Macoratti