• ▼MSDN Library - April 2000
    • ▶Welcome to the MSDN Library
    • ▶Visual Studio 6.0 Documentation
    • ▶Office Developer Documentation
    • ▶Windows CE Documentation
    • ▶Platform SDK
    • ▶SDK Documentation
    • ▶DDK Documentation
    • ▶Windows Resource Kits
    • ▼Knowledge Base
      • About the Microsoft Knowledge Base
      • ▶ACME Setup Program
      • ▶BackOffice
      • ▼Data Access
        • ▼ActiveX Data Object
          • Adbdmod.exe Demonstrates Using ADO 2.0 VC++ Binding
          • Ado2atl.exe Returns ADO Interfaces from COM
          • Adoacc.exe Demonstrates Using ADO with MS Access 97
          • AdoChunk.exe Using GetChunk and AppendChunk in Visual C++
          • Adovcbm.exe ADO 1.5 with #import and Getrows/Bookmarks
          • Adovcbtd.exe #import Using UpdateBatch and CancelBatch
          • BUG: ADO Bound OLE Control Does Not Display Bitmap
          • BUG: ADO Parameters Refresh May Cause Failure
          • BUG: ADO Recordset GetString() Function Throws Access Violation
          • BUG: MS Access ODBC Driver, Jet OLE DB 3.51 Do Not Expose adFldIsNullable to ADO
          • BUG: ADODB Jet 4.0 Recordset.Seek Causes Application Error
          • BUG: After Installing IE 4.0, ADO May Raise Error 0x800a0bb9
          • BUG: Connection Failure with ADO 2.1 and the Jet 3.51 Provider
          • BUG: Creating Fabricated Hierarchical Recordset Fails w/MDAC
          • BUG: Custom Property from Provider of Type adIDispatch Fails
          • BUG: Datagrid Is Not Painted Correctly After Adding Split
          • BUG: Error Setting Sort to Char Field Greater than 255
          • BUG: IIS 4.0 Fails When Using a UNC to Microsoft Access
          • BUG: LDB File Grows using ADO to Access 97 MDB Hosted on Novell
          • BUG: Navigating ADO Recordset Clone Generates Error -2147217885
          • BUG: NextRecordset Fails on Remoted or Disconnected Records
          • BUG: Properties Collection Not Populated for Child Recordsets
          • BUG: RecordsetChangeComplete Does Not Fire on Recordset.Open
          • BUG: Spelling Error in ADO Type Library - Schema Constraint
          • BUG: Storing an ADO Recordset in GIT May Cause Access Violation
          • BUG: WillChangeRecordset Event Not Executed
          • BUG: Crash Updating Linked Table with ADO2.1/Jet 4 OLEDB Provider
          • Capturing ADO Events with Visual C++
          • CreateRS.exe Uses the CreateRecordset Function in VC++
          • DOC: Constant Values Incorrect for CursorLocationEnum
          • DOC: RDS.DataControl URL Property Documentation Error
          • DOC: Sheridan.cab Incorrectly Referenced in RDS Tutorial Sample
          • FAQ: ActiveX Data Objects (ADO) Frequently Asked Questions
          • FILE: Adomts.exe Shows Using ADO an MTS Component via DCOM
          • FILE: Rdsensub.exe with RDS Conflict Resolution Sample
          • FIX: Getting SELECT DISTINCT To Work Under ADO with SQL Server
          • FIX: 'Not Enough Storage is Available...' Error with ADO
          • FIX: ADO 1.5 Incorrectly Converts Dates with the Year
          • FIX: ADO 2.0 Generates Error 0115 When Used with IIS 3.0
          • FIX: ADO Client Cursors Report LockType = adLockPessimistic
          • FIX: ADO Filter Fails if Filter String Contains '*strval'
          • FIX: ADO Recordset Opened from File May Not Update Database
          • FIX: AV in MSADCE When Executing a SHAPE Query Using a .udl File
          • FIX: CreateRecordset Method of Datafactory Fails w/ Text Field
          • FIX: GetRows Method of ADO Object Returns Incorrect Value
          • FIX: Handle Leak when Passing ADO Objects Between Processes
          • FIX: Marshaling ADO Recordset Out-of-Process causes Memory Leak
          • FIX: MDAC 2.1 SP1 Problem Executing Access Query with Wildcard
          • FIX: MTS Impersonation Returns Incorrect Caller When Using RDS
          • FIX: OpenSchema Method Generates Error 3251
          • FIX: Oracle Numeric Fields Must be Converted for Logical Tests
          • FIX: Property Change Through Collection Is Not Effective
          • FIX: RDS Query Times Out After Five Minutes
          • FIX: Recordset Displays Previous Page's Data When Filtering
          • FIX:Blank Space in ConnectString Won't Allow Pessimistic Locking
          • How to Use ADO with Visual Basic
          • HOWTO: Access a Secured Jet Database w/ the MSDataShape Provider
          • HOWTO: ADO Refreshes/Creates Linked Table for Jet 4.0 Database
          • HOWTO: Bind Complex-Bound Controls at Run Time with Visual Basic
          • HOWTO: Call a Parameterized Query to an Access Database with ADO
          • HOWTO: Call Parameterized Child Command Through MSDataShape Prov
          • HOWTO: Compacting Microsoft Access Database via ADO
          • HOWTO: Create a 3-Tier App Using VB, MTS, and SQL Server
          • HOWTO: Create a Recordset from a Variant Array with RDS
          • HOWTO: Create a VB Component that Returns a Recordset in RDS
          • HOWTO: Create Hierarchical Recordsets Programmatically
          • HOWTO: Determine How ADO Will Bind Parameters
          • HOWTO: Distributing RDS Client with Visual Basic Setup Wizard
          • HOWTO: Extract Child Recordsets from Shaped Recordset
          • HOWTO: Find a Record Using Complex Criteria with ADO
          • HOWTO: Get Fractions of a Second from ADO adDBTimeStamp Field
          • HOWTO: Getting ADO Disconnected Recordsets in VBA/C++/Java
          • HOWTO: Implement Nested Transactions with ADO and SQL Server
          • HOWTO: Intercept UpdateBatch and Call a Stored Procedure
          • HOWTO: Invoke a Login Prompt when Opening an ADO Connection
          • HOWTO: Invoke a Parameterized ADO Query Using VBA/C++/Java
          • HOWTO: Invoke a Stored Procedure w/ADO Query Using VBA/C++/Java
          • HOWTO: Lifetime of a COM Component Under IIS, ASP, and RDS
          • HOWTO: Log RDS Run-Time Errors
          • HOWTO: Manufacture an ADO Recordset Based on Another Recordset
          • HOWTO: ODBC and OLEDB Connection Prompt Control in ADO
          • HOWTO: Open ADO Connection and Recordset Objects
          • HOWTO: Open ADO Recordsets Asynchronously Using WithEvents
          • HOWTO: Page Through a Recordset from ASP
          • HOWTO: Pass a Timestamp to/from a SQL Stored Procedure w/ ADO
          • HOWTO: Perform a Case-Sensitive JOIN via Microsoft Jet
          • HOWTO: Position DataList Control Directly Under Cell in DataGrid
          • HOWTO: Process Multiple Recordsets and Messages in ADO
          • HOWTO: Query and Update Excel Data Using ADO From ASP
          • HOWTO: Re-Shape a Hierarchical Recordset
          • HOWTO: Refresh ADO Parameters for a Stored Procedure
          • HOWTO: Retrieve and Update a SQL Server Text Field Using ADO
          • HOWTO: Retrieve Recordsets from Oracle Stored Procs Using ADO
          • HOWTO: Sample Functions Demonstrating GetChunk and AppendChunk
          • HOWTO: Supply User Authentication when Opening Jet Linked Tables
          • HOWTO: Trap for ADO Connection Errors Using WithEvents
          • HOWTO: Uniquely Identify the Same Name Fields from N Tables
          • HOWTO: Use a Fields Array in Fields Option of GetRows Method
          • HOWTO: Use ADO and ODBC Text Driver to Open Delimited Text Files
          • HOWTO: Use ADO GetChunk/AppendChunk with Oracle for BLOB Data
          • HOWTO: Use ADO GetChunk/AppendChunk with Oracle for TEXT Data
          • HOWTO: Use ADO to Query Access Table with a Space in Its Name
          • HOWTO: Use ADO to Retrieve Table Index Information
          • HOWTO: Use ADOMD to Return Out of Process Cellset
          • HOWTO: Use Data Link Files with ADO 2.0
          • HOWTO: Use RDS 1.5 Server with Internet Explorer 3.02
          • HOWTO: Use RDS From an IIS 4.0 Virtual Server
          • HOWTO: Use RDS From Inside a Visual Basic Program
          • HOWTO: Use RDS Within a Visual Basic ActiveX Document
          • HOWTO: Use the ADO OpenSchema Method in Visual Basic
          • HOWTO: Use the ADO SHAPE Command
          • HOWTO: Use the RDS DataFactory via Standard ADO Open Method
          • HOWTO: Use UDT to Return State Info for Out of Process Record
          • HOWTO: Using the ADO OpenSchema Method from Visual C++
          • HOWTO: Work w/ Microsoft Access QueryDef Parameter Using VB
          • HOWTO: Write and Validate a Custom Business Object with RDS
          • ImportText.exe Importing Text into Access
          • INFO ADO Hierarchical Recordsets via SHAPE APPEND w/C++/VBA/Java
          • INFO: AbsolutePosition Property with JET Databases in ADO
          • INFO: ADO 2.0 and ADO 2.1 Binary Compatibility
          • INFO: ADO 2.1 Ships with an ADO 2.0 Type Library
          • INFO: ADO Spawns Additional Connections to SQL Server
          • INFO: ADO's Find and Filter Support Usage of Wildcards
          • INFO: ADOX Readme File Included with ADO 2.1 Components
          • INFO: Certain Recordsets Cannot Directly Post to Database
          • INFO: Changes in ADO 1.5 That Affect Visual C++/J++ Programmers
          • INFO: Connection Pool Management by ADO Objects Called From ASP
          • INFO: Disconnected Recordsets with ADO or RDS
          • INFO: Err 0x80070005 if RDS Bus Obj not Added to ADCLAUNCH Key
          • INFO: Errors Raised by Remote Data Service
          • INFO: Extracting Error Information from ADO in VB
          • INFO: Extracting Error Information from ADO in VC++ with #import
          • INFO: Identity (AutoIncrement) Columns in ADO or RDS
          • INFO: Identity and Auto-Increment Fields in ADO 2.1 and Beyond
          • INFO: Maintaining Binary Compatibility in Components with ADOR
          • INFO: Optional Feature Not Implemented Error Message
          • INFO: Passing ADO Objects Between Visual Basic and Visual C++
          • INFO: Passing ADO Recordsets in Visual Basic Procedures
          • INFO: RDS Registry/Security Settings For Custom Business Objects
          • INFO: Remote Data Services (RDS) Objects Do Not Maintain State
          • INFO: Replacing #import's Exception Raising Mechanism for ADO
          • INFO: SQL Server Might Spawn Additional Connections with ADO
          • INFO: Techniques for Returning a Recordset via RDS
          • INFO: Underlying OLE and OLEDB Provider Errors Exposed via ADO
          • INFO: Using ActiveX Data Objects (ADO) via #import in VC++
          • INFO: Using ActiveX Data Objects (ADO) via MFC OLE in VC++
          • INFO: Using ActiveX Data Objects (ADO) via Microsoft Access 97
          • INFO: Using ActiveX Data Objects (ADO) via OLE SDK in VC++
          • INFO: Using ActiveX Data Objects (ADO) via Visual Basic
          • INFO: When Tablename Is Available Using ADO, RDO, DAO
          • INFO: Working with RDS Handlers
          • PRB: '800a0bb9' Error Msg when Applying Filter to ADO Recordset
          • PRB: 'Class not registered' Error Opening an XML Recordset
          • PRB: 'Command Time Out' Property Does Not Work
          • PRB: 'No Such Interface Supported' Error Calling ADOX Method
          • PRB: 'Syntax Error in FROM clause' Opening a Jet Table
          • PRB: 'Syntax Error Near 'Tablename'' Error on Recordset Update
          • PRB: 'Too Many Columns Defined in the Rowset' Error Message
          • PRB: 80020009 Error When Retrieving Data from SQL
          • PRB: 80040e25 Error Calling a Stored Procedure
          • PRB: ADO adMarshalModified Causes Problem with Late Binding
          • PRB: ADO Data Control Events May Generate a Compilation Error
          • PRB: ADO Does Not Return Records After an Update
          • PRB: ADO Error -2147217896 when Calling MoveFirst()
          • PRB: ADO Not Returning @@IDENTITY Value After AddNew
          • PRB: ADO Parameter Refresh Err with MS Access 97 Querydef
          • PRB: ADO Recordset Clone Events Positioned to Incorrect Record
          • PRB: ADO Recordset Opened with adAsyncFetch May Seem Synchronous
          • PRB: ADO Recordset Sort Property Errors
          • PRB: ADO Run-Time Error with Update/Delete and SET NOCOUNT ON
          • PRB: ADO's Field ATTRIBUTE Property and adFldRowID
          • PRB: ADO: Recordcount May Return -1
          • PRB: Appending Fields to a Recordset Generates an Error
          • PRB: AutoNumber Field Is Not Incremented When Using ADO
          • PRB: Bookmarks Are Not Persisted or Marshalled
          • PRB: Cannot Add Rows to a Replica Database With ADO
          • PRB: Cannot Create ADO Recordset Hierarchies Manually
          • PRB: Cannot Filter ADO Recordsets for Nulls
          • PRB: Cannot Invoke T-SQL Debugger to Appear Using ADO
          • PRB: Cannot Set Empty to Date Field
          • PRB: Catastrophic Error Occurs Referencing ADO Recordset
          • PRB: Chaptered Recordset from Parameterized Query Not Saved
          • PRB: Child Recordset Submits Change w/o Active Connection
          • PRB: Compiler Errors After Upgrading to Remote Data Service 2.0
          • PRB: Conflict with EOF When Using #import with ADO
          • PRB: ConnectionWrite(GetOverLappedResult) on Update/Insert SQL
          • PRB: Data Bindings Lost When ADO Recordset Is Closed
          • PRB: DataGrid Not Populated Using Jet.OLEDB.4.0 Provider and ADO
          • PRB: DataLink Type Library Moved From Msdasc.dll To Oledb32.dll
          • PRB: Decimal Values Passed to a Stored Procedure Get Truncated
          • PRB: Err 3001 Comparing Fields as Criteria to Filter Recordset
          • PRB: Error 0x80040e56 When Sorting with RDS 1.5 Data Control
          • PRB: Error 3251 Generated by Calling ADOX Methods
          • PRB: Error 3265 When Accessing Properties Collection
          • PRB: Error 3712 with the ExecuteComplete Event
          • PRB: Error Creating More Than One Recordset in a Transaction
          • PRB: Error Message 3421 Passing a Blob Argument to a Stored Proc
          • PRB: Error Message Referencing #Temp Table with ADO-SQLOLEDB
          • PRB: Error Updating adUseClient Cursor Based on MDB Query
          • PRB: Errors with IDataspace and IBindMgr Interfaces in RDS 1.5
          • PRB: Implicit Conversion Error Calling Second Stored Procedure
          • PRB: Index Server: 'ADO could not find the specified provider'
          • PRB: Info Message Not Appended to ADO Errors Collection
          • PRB: Info Message Not Appended to ADO Errors Collection
          • PRB: Inserting Date/Time Value into SQL Server with ADO Loses MS
          • PRB: Invalid Certificates Cause RDS Problems
          • PRB: MaxRecords Property Not Used in Access Queries with ADO
          • PRB: Migrating SQL Statements with Quotes From DAO to ADO
          • PRB: Missing Parameter Error Running Stored Procedure from ADO
          • PRB: Most ADO Recordset Properties Are Not Marshalled
          • PRB: Multiple Statements in SPs Cause Forward-Only/Read-Only Rs.
          • PRB: NextRecordset Fails When Called On a Disconnected Recordset
          • PRB: NextRecordset Never Returns Null or Nothing
          • PRB: No Records from SELECT w/FOR UPDATE Against Oracle Server
          • PRB: ODBC Syntax Required for Retrieving Parameter Information
          • PRB: Oracle Servers Convert Empty Strings to NULL
          • PRB: Output Parameters Wrong after ADO Command.Execute Call
          • PRB: PRB: TDS Error with Substring and Multiple ADO Recordsets
          • PRB: Problems Reusing ADO Command Object on Multiple Recordsets
          • PRB: QueryTimeout Event Not Available
          • PRB: RDS Client Receives 'Unexpected Error (0x8003001e)'
          • PRB: RDS Does Not Work with OLE DB Simple Provider
          • PRB: RDS Handler Error Messages Due to Security Settings
          • PRB: RDS May Return E_FAIL Status when Querying Index Server
          • PRB: RDS: Can't Access COM Object Properties via HTTP Protocol
          • PRB: RollbackTrans Does Not Undo Changes To ADO Recordset
          • PRB: Run-time Error with Command Object and adCmdTableDirect
          • PRB: Shaped Recordset Returns Incorrect Number of Records
          • PRB: SQL Server ODBC Driver with ADO Spawns Second Connection
          • PRB: SQL Stored Out Parameters Returns Incorrect Values
          • PRB: Transactions and ADO Parameters Cause Connections to Hang
          • PRB: Unable to Delete from Table Having Cascade Delete Trigger
          • PRB: Uninitialized String Variables, Empty String Values
          • PRB: Update of Same Record 2x w/Disconnect ADO Recordset Fails
          • PRB: Upgrading to RDS 2.x from RDS 1.x May Break Applications
          • PRB: Use IDispatch for Objects Created by a DataSpace Object
          • PRB: Use Open Method to Change CursorType and LockType
          • PRB: Views Created Using ADOX Are Not Visible in Access 2000
          • PRB: WillChangeRecord Event Does Not Fire on Update
          • Rdsvb.exe Demonstrates How to Use RDS with Visual Basic
          • SAMPLE: AdoDataGrid.exe Demonstrates Using ADO with DataGrid
          • Sample: ADOVC1 Simple ADO/VC++ Application
          • SAMPLE: ATL2ADO.exe Returns Disconnected ADO Recordset
          • SAMPLE: Cellset.exe: Using ADO MD CellSet's Item/GetItem Method
          • SAMPLE: SmAlert.exe Extends PerfMons Alert Mechanism
          • SAMPLE: Vcspnp.exe Demonstrates Passing SQL NULL Parameters
          • SAMPLE: WFCADOevent.exe Demonstrates ADO Events with Visual J++
          • Saving an ADO Recordset to an IStream
          • SRVRS.exe Uses VC++ to Get
        • ▶Microsoft Data Access Components
        • ▶Open Database Connectivity (ODBC)
      • ▶Exchange
      • ▶Fortran Compiler
      • ▶FoxPro
      • ▶Hardware
      • ▶Internet Explorer
      • ▶Internet Development
      • ▶Macro Assembler
      • ▶Messaging
      • ▶Microsoft Developer Network
      • ▶Microsoft Mastering Series
      • ▶Microsoft Systems Journal
      • ▶NetShow
      • ▶Office
      • ▶OLE
      • ▶Visual Basic
      • ▶Visual Database Tools
      • ▶Visual C++
      • ▶Visual InterDev
      • ▶Visual J++ and Java Language
      • ▶Visual SourceSafe
      • ▶Visual Studio
      • ▶Windows
      • ▶Windows Development
      • ▶Miscellaneous
    • ▶Technical Articles
    • ▶Backgrounders
    • ▶Specifications
    • ▶Books
    • ▶Partial Books
    • ▶Periodicals
    • ▶Samples