• ▼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