• ▼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
        • ▶Microsoft Data Access Components
        • ▼Open Database Connectivity (ODBC)
          • ACC2000: Jet 4.0 Expression Can Execute Unsafe VBA Functions
          • BUG: Setup /AUTO Fails to Install 32-bit ODBC on Windows NT
          • BUG: 'Error in Assignment' Accessing BLOB Data in FoxPro DB
          • BUG: 'Invalid number' When Inserting Decimals into UNIX Oracle
          • BUG: 'One-time Only' Tracing Option Does Not Stop Automatically
          • BUG: 'Out of String Space' Error Returned by the Access Driver
          • BUG: 16-bit ODBC Driver Setup Fails Due to Missing ODBC32.DLL
          • BUG: 2nd Insert Statement Fails On a Recreated Table in Excel
          • BUG: AbsolutePosition Property Returns Different Results
          • BUG: Access Driver DBQ=, DefaultDir= Incorrect with Large mdb
          • BUG: Access Driver Ignores Pagetimeout in Datasources
          • BUG: Access Driver Returns Incorrect pcbValue
          • BUG: Access ODBC: SQLGetInfo(SQL_NON_NULLABLE_COLUMNS)
          • BUG: Adding a DSN With Microsoft Text Driver May Fail
          • BUG: Btrieve: Drop Table Does Not Remove Entry in SQLTables
          • BUG: Calling IDBInfo::GetKeywords() Causes AV w/ OLE DB Provider
          • BUG: Can Not Do Literal Update of Memo Fields Beyond 255 Chars
          • BUG: Cannot Have a Pathname
          • BUG: Cannot Insert BLOB Data Sized Between 64K and 128K
          • BUG: Cannot Update More Than 64K of Long Data
          • BUG: Connection Fails with SQLSetConnectOption-SQLConnect
          • BUG: CREATE TABLE and CREATE INDEX Cause Error 42000
          • BUG: Cursor Library Fails to Close Buffer
          • BUG: Dbase or FoxPro: Fox Memo Select Stopped by Dbase
          • BUG: dBASE: SQL_ERROR w/ SQLExecute/SQLFreeStmt(SQL_CLOSE)
          • BUG: Deleted Rows Show w/ 'Show Deleted Rows' Option Cleared
          • BUG: Err 4408 Generates Communication Link Failure, Connection
          • BUG: Err Msg: Control Caused Stack Fault in Module XBS200.DLL
          • BUG: Error When Using Table Aliases with Oracle ODBC Driver
          • BUG: Escape Seq in Params to Stored Procs Are Incorrectly Parsed
          • BUG: Extra Block of 256 Bytes Used by Access ODBC Driver
          • BUG: FoxPro Driver Always Shows Deleted Rows
          • BUG: IDBSchemaRowset Reports DBTYPE_NUMERIC for MONEY Datatype
          • BUG: Incorrect Declarations in vbdemo Program
          • BUG: Incorrect Error Message: [ODBC Driver pack 2.0]...
          • BUG: Incorrect Errors Occur w/ SELECT Queries Using Oracle 8.0.5
          • BUG: Inserting/Updating Dates Before '01-01-1900' Into SQL
          • BUG: Invalid Connection String Error with Certain Passwords
          • BUG: Locking While Running Two Transactions on Two Sessions
          • BUG: MDAC 2.1 GA - ODBC Jet / ISAM Driver Cannot Open Excel 4.0
          • BUG: MDAC: SQL Server Driver May Return Error 'Login Failed'
          • BUG: Memory Leak with Desktop Database Drivers with USE
          • BUG: MSDN CD#4: MSJETINT.DLL Missed in ODBC16.INF
          • BUG: Multiple threads Cause Connection Busy Error in the Driver
          • BUG: Negative 0 (zero) Causes ODBC SQL Server Driver Error
          • BUG: No Error Message When Changing Qualifier on 2nd hstmt
          • BUG: ODS Driver May Give an Error on Outer Join Escape Clause
          • BUG: Open/Close CRecordset Repeatedly Results in AV
          • BUG: Oracle Driver Errors on Delimited Column Names
          • BUG: Oracle Driver Fails to Find Delimited Identifiers
          • BUG: Out of Range Error When Binding a SQL_C_BINARY Datatype
          • BUG: Outer Join with Another Table in FROM May Cause SQL_ERROR
          • BUG: Package Call Fails if Parameters Are Not Present
          • BUG: Parameter Mismatch with Subqueries When Using Access ODBC
          • BUG: pcbValue Shows 1022 Even if Size of Available Data
          • BUG: Precision for a Projected Column Always Reported as 255
          • BUG: Problems w/ ODBC 32-bit Thunking Installer DLL in Win32s
          • BUG: Retrieved Data May Display as Nonalphanumeric Using ODBC
          • BUG: S1000 Error When Sharing Connection in Multiple Threads
          • BUG: Setup of Data Source in Use Causes Sharing Violation Err.
          • BUG: Single-Line Comments May Give 'Wrong Number of Parameters'
          • BUG: Some API's May Return SQL_ERROR: SQLSTATE S0001
          • BUG: SQL Server ODBC Driver AVs When Inserting from a Remote SP
          • BUG: SQL Server ODBC Driver Removes Entry From WIN.INI
          • BUG: SQL Server SQLSetParam Fails on the 252nd Parameter
          • BUG: SQL Server: Certain Outer Joins Can Cause SQL_ERROR
          • BUG: SQL_PRESERVE_CURSORS Fails on Reuse of a Connection Handle
          • BUG: SQLColumns Return Incorrect BUFFER_LENGTH/CHAR_OCTET_LENGTH
          • BUG: SQLColumns Returning NULLABLE May Not Be Accurate
          • BUG: SQLFreeStmt After SQLExecute/SQLExecDirect May Cause GPF
          • BUG: SQLGetData Returns SQL_SUCCESS on a Binary Column
          • BUG: SQLGetInfo Gives Incorrect Result for SQL_DRIVER_HSTMT
          • BUG: SQLNumResultCols May Fail After Prepared SQL Statement
          • BUG: SQLNumResultCols on a Prepared SELECT with ORDER in Name
          • BUG: SQLNumResultCols Returns Zero for the pcCol Argument
          • BUG: SQLParamData Returns Incorrect Values Under Win32s
          • BUG: SQLSRVR.DLL GP Fault on Vines When SQL Server Not Running
          • BUG: SQLState S1000 with SQL_AUTOCOMMIT_OFF/SQLTransact
          • BUG: SQLState S1011 on SQL_AUTOCOMMIT_OFF with Active Results
          • BUG: SQLStatistics Always Reports Indexes as Ascending
          • BUG: SQLStatistics Does Not Return Unique Index Information
          • BUG: SQLTables w/ Table Type of 'VIEW' Return 'SYS' and 'SYSTEM'
          • BUG: Summary List of ODBC 1.0 Bugs
          • BUG: Synonyms Do Not Work with Oracle Stored Procedures
          • BUG: Syntax Error When Using Qualified Table Name with Quotes
          • BUG: Temp SP Generated by SQLPrepare Is Not Dropped
          • BUG: Time Value Converted to Datetime Using Access ODBC Driver
          • BUG: Update Causes Degree of Derived Table Error
          • BUG: Use of Apostrophes in DSN Setup Not Allowed
          • BUG: Use of Certain Scalar Functions May Cause SQLFetch Errors
          • BUG: Use of Vertical Bar (|) Generates Syntax Error
          • BUG: Value of cbDSN in SQLConnect is Not Mapped Correctly
          • BUG: Wrong Rowset Size Returned by ODBC Driver Manager
          • BUG:SQL DSN Revert from Standard Security to Integrated Security
          • Contents of ODBC Readme25.txt File (Part 1 of 2)
          • Contents of ODBC Readme25.txt File (Part 2 of 2)
          • Contents of Visual FoxPro 1.0 ODBC Vfpodbc.txt File
          • DOC: Usage of BufferLength in SQLGetDiagRecW
          • FIX: 'Invalid Argument Value' Error with SQLSetConnectOption
          • FIX: 'Syntax Error' with SQL Literal String Over 16,379 Bytes
          • FIX: 16-Bit Driver Keyset Cursor Operations with Query Timeout
          • FIX: 16-bit Driver Times Out on Async Calls to SQLTables
          • FIX: Access Violation with SQLConfigDatasource
          • FIX: Cannot Make Server-Server RPCs in Non-trusted Mode
          • FIX: Creating a New File DSN Causes a Refresh Problem on Deskto
          • FIX: Cursor Library Memory Leak in Multithreaded Environment
          • FIX: Cursor Library Returns Duplicate Row in Asynchronous Mode
          • FIX: Degree of Derived Table Err Using Table Name in Select List
          • FIX: Degree of Derived Table Error When Updating Oracle Data
          • FIX: Driver Not Capable Error: SQL_COPT_SS_CONNECTION_DEAD
          • FIX: Error 231 After Opening a Server Side Cursor
          • FIX: Error Clicking Back Button After Testing New DSN in ODBC CP
          • FIX: Error on Disconnecting from ODBC Desktop Drivers
          • FIX: Extended Character Data Overwritten Upon Reselection
          • FIX: Failure to Load Odbccr32.dll on Alpha Machine
          • FIX: GP Fault in SIMBA.DLL w/ Second SQLExecute() of DEL Stmt
          • FIX: Handle Leak in ODBC Driver/OLE DB Provider
          • FIX: IIS Performance Degrades with a Bad Connection
          • FIX: In-line Comments Parsed by Microsoft Oracle Driver
          • FIX: Inserts May Fail and Updates May Not Be Seen
          • FIX: Invalid Cursor State Error with the MS Oracle ODBC Driver
          • FIX: Jet Drivers Do Not Support Bit-wise Operators
          • FIX: Keywords in WHERE Clause Cause Oracle ODBC Driver Errors
          • FIX: MDAC 2.0 SQL Server ODBC Driver Hangs On SQLDescribeCol()
          • FIX: Memory Leak in Microsoft Access ODBC Driver in MDAC 2.0
          • FIX: Memory Leak with ODBC Driver Manager During Connect
          • FIX: Memory Leak with ODBC Driver Manager During Connection
          • FIX: MS Access ODBC Driver Does Not Recognize DSN MaxBufferSize
          • FIX: ODBC 6.0 Driver Sometimes Cannot Get Results w/ dbmsspx3
          • FIX: ODBC Driver May Return 'TDS Buffer Link Too Large' Error
          • FIX: Odbccp32.lib Requires Msvcrt.lib to Compiler
          • FIX: Oracle ODBC Driver Creates Temporary Files on Root Drive
          • FIX: Sp_droplogin Error 14248 if ANSI_NULL_DFLT_ON
          • FIX: SQL_CUR_USE_IF_NEEDED Does Not Work with 2.0 Drivers
          • FIX: SQLAllocConnect in Console App. Causes Access Violation
          • FIX: SQLDescribeCol
          • FIX: SQLDescribeCol Returns Error on Prepared Outer Join
          • FIX: SQLGetData Returns Extra Character For StrLen_or_IndPtr
          • FIX: SQLNumResultCols Fails with Incorrect Syntax Near 'SET'
          • FIX: SQLNumResultCols Results in Attentions Generation on Server
          • FIX: SQLPutData Truncates LONG RAW Data Using Oracle ODBC Driver
          • FIX: TDS Errors in a Multithreaded ODBC Application
          • How to Get the ODBC Version 2.5 Components
          • How To Obtain ODBC 3.0 Service Pack1
          • HOWTO: Acquire and Install the Microsoft Oracle ODBC Driver
          • HOWTO: Perform Bulk Inserts Using SQLSetPos
          • HOWTO: Retrieve RAW/LONG RAW Data from Oracle for ASP Page
          • HOWTO: Retrieving Numeric Data with SQL_NUMERIC_STRUCT
          • HOWTO: Use CDao for Connections to a Secure Attached Table
          • INF: Access ODBC Driver Is Double-Byte Enabled
          • INF: Appendix A, ODBC Error Codes
          • INF: Binding SQL Results Using ODBC API From Visual Basic
          • INF: Change in Behavior of SQLSetPOS on Empty Result Set
          • INF: Checking for an ODBC Driver's Transaction Support
          • INF: Connecting to Sybase SQL Server from ODBC Application
          • INF: Connection Pooling Requires Same Henv and Driver
          • INF: Cursor Behavior in Autocommit Mode
          • INF: Desktop Driver SQLCOnfigDataSource Exclusive Keyword
          • INF: Desktop Drivers Not Meant For Access or DAO
          • INF: Driver Manager and Cursor Library Compatibility
          • INF: Driver Manager Trace Facility Logs User Names and Password
          • INF: Error Flushing by Driver Manager
          • INF: Error Handling in Visual Basic Data Access Layer
          • INF: Excel ODBC Driver and Text ODBC Driver Notes
          • INF: Explanation of the Two Available MS Access Drivers
          • INF: Frequently Asked Questions About ODBC Connection Pooling
          • INF: How the dBASE Driver Performs Locking
          • INF: How to Differentiate Multiple SQLAllocEnv() Calls
          • INF: How to Enable Connection Pooling in an ODBC Application
          • INF: How to Enable Connection Pooling in an OLE DB Application
          • INF: How to Upgrade ODBC SDK version 2.10a to 2.10b
          • INF: How to Use OLE DB Sample Text Provider in ADO
          • INF: How to Use SQL_C_NUMERIC Data Type with Numeric Data
          • INF: How to Use SQLDataSources()
          • INF: How to Use SQLInstallDriver API with a 32-Bit Installer
          • INF: How to Use SQLSetPos in Updatable Joins w/ SQL Server
          • INF: How to Use the SQL_DRIVER_HSTMT Option in SQLGetInfo()
          • INF: Implementation of Searched Updates in the Access Driver
          • INF: Index Types and NULL Values
          • INF: Jet 3.0 Dynamic Memory Usage and Access ODBC Driver
          • INF: Meaning of an Active ODBC Statement Handle
          • INF: Microsoft ODBC Desktop Database Drivers 1.0 README.TXT
          • INF: Network Setup of ODBC Drivers
          • INF: No Further Development of 16-bit ODBC Components
          • INF: No ODBC 32-bit Btrieve Driver Available from Microsoft
          • INF: ODBC 3.0 Driver Manager and Driver Installation
          • INF: ODBC Access Driver Does Not Support Create or Drop View
          • INF: ODBC Database Drivers 2.0 Supported Platforms
          • INF: ODBC Desktop Driver Pack 2.0 Does Not Install ODBCADM
          • INF: ODBC Desktop Drivers and OLE in a Multithreaded App
          • INF: ODBC Driver Pack 2.0 Fulfillment Kit Q?
          • INF: ODBC Stored Procedures odbc#userid######## on SQL Server
          • INF: ODBC Transaction Isolation Levels
          • INF: Performance Considerations with the ODBC Access 2.0 Drive
          • INF: Retaining Transactions with Transaction Object
          • INF: Running ODBC Applications as Windows NT Services
          • INF: Sample ODBC.INF for ODBC Drivers Shipped in Access 7.0
          • INF: Semantics of SELECT DISTINCT with ORDER BY
          • INF: Setting Data Sources for SQL Server Driver on Novell NIK
          • INF: Sharing ODBC Handles Among Several Applications
          • INF: SQL Server Drivers' Use of ODBC.INI and WIN.INI Files
          • INF: SQLColAttributes Clarification in ODBC 2.10b SDK RELNOTE2
          • INF: SQLColAttributes(SQL_COLUMN_LABEL) and Field Description
          • INF: SQLDescribeCol Limitation on Meta Data
          • INF: SQLState 22002 Error When Fetching Results
          • INF: Testing ODBC Connectivity to Oracle 7.x
          • INF: Text Driver Needs Directory Before Define Format Enabled
          • INF: Unable to Load ODBCCP32.DLL in Custom ODBC Setup Programs
          • INF: Use of SQLBindParameter with VB and an ODBC driver
          • INF: Use of SQLPutData() in Visual Basic
          • INF: Using the Visigenic Oracle Driver on WinNT
          • INF: When and How an ODBC Driver DLL Gets Unloaded
          • INF: Win16 ODBC Applications in a Win32 Environment
          • INFO: Accessing CREATE_DB, REPAIR_DB, and COMPACT_DB
          • INFO: Determining What Oracle Components Are Installed
          • INFO: Location of Oracle's Public FTP Site
          • INFO: Microsoft Data Access Components (MDAC) Release History
          • INFO: Nested Transactions Not Available in ODBC/OLE DB/ADO
          • INFO: No Padding of Parameters Done by SQL Driver Prior Ver 3.7x
          • INFO: OLE DB Provider for ODBC Now an ODBC 3.5 and Higher Core C
          • INFO: Support Limits of MS Oracle ODBC Driver/OLEDB Provider
          • INFO: Third-Party Vendors for ODBC Drivers
          • INFO: Understanding Microsoft's Oracle ODBC Driver Versions
          • INFO: Using SchemaName and the SchemaSeparator in ODBC
          • INFO: Using SQLConfigDatasource with MS Oracle ODBC Driver
          • Jet 3.5 Text ISAM Allows User to Append Lines to System File
          • Jet 4.0 Text IISAM Allows User to Append Lines to System Files
          • Jet Expression Can Execute Unsafe VBA Functions
          • Logon Dialog for Visigenic Oracle Driver Displays Incorrectly
          • Microsoft ODBC Driver for Oracle Truncates Error Messages
          • Microsoft ODBC Drivers Ver. 3.0 for 32-Bit Programs
          • OLE DB Redistributable Components
          • Open Database Connectivity (ODBC) 3.0 Service Pack 1 Fixlist
          • ORA-00000 Error Message with ASP, MTS, and Connection Pooling
          • Oracle ODBC Driver Appends Trailing Zero to Numeric Columns
          • ORACLE.TXT for Visual Basic Version 3.0 Users
          • PRB: 'Can't Load Mspdox35.dll' Error Installing DDP 3.0
          • PRB: 'Numeric Value Out of Range' Error Calling GetFieldValue
          • PRB: 'ODBC Resource DLL Is a Different Version Than ...' Error
          • PRB: 'Optional feature not implemented' or '#name' in SQL Srv 7
          • PRB: _IID_ISequentialStream Link Error w/OLE DB
          • PRB: 16-Bit Apps May Use 32-Bit DSNs if Duplicate DSNs Exist
          • PRB: 32-Bit Cursor Library Creates Temp Files in Current Dir
          • PRB: 32K Limit on Direct Parameters for 16-bit Drivers
          • PRB: Accessing Temporary SQL Server Table Result: DB_E_NOTABLE
          • PRB: Alpha MS Oracle ODBC Driver Does Not Work with Oracle8
          • PRB: ATL Consumer Receives DB_S_ERRORSOCCURRED on Move
          • PRB: Cannot Load MFCCLSWZ.DLL with ODBC SDK Version 2.1
          • PRB: Checking Version of Driver Manager from an Application
          • PRB: DELETE Without FROM Clause Causes Errors in Oracle Driver
          • PRB: Error: 'Failed to Get Expression Service'
          • PRB: File DSN and DSN-Less Connections May Fail w/Localized ODBC
          • PRB: Floats May Be Rounded Up Using ODBC SQL Server Driver
          • PRB: Jet/VBA May Fail w/ Datetime Data
          • PRB: Memory Leaks in SQL Srv Driver During Connect/Disconnect
          • PRB: Memory Leaks with Desktop Database Drivers
          • PRB: Missing Oracle File SQLNET.ora May Cause Access Violation
          • PRB: No Information Returned for SQLSTATE IM006 from Driver
          • PRB: Not a Valid Month Error when Inserting to Oracle Date Field
          • PRB: Numbered Positioned Updates Against Oracle8i DB Server Fail
          • PRB: Numeric Value Out of Range Error with MS Oracle ODBC Driver
          • PRB: ODBC Call Failed or Error 3146
          • PRB: ODBC Driver Manager Error: 'Program Type out of Range'
          • PRB: ODBC SQL Server Driver and Access Violation on SQL Server
          • PRB: OEM to ANSI Translation Fails While Creating New DSN
          • PRB: Oracle TNS: Authentication Service Initialization Error
          • PRB: Project Containing UserConnection
          • PRB: Query Too Complex Error After Execution of SQL Query
          • PRB: Server-side Cursors Are Forced w/More Than One Command Obj.
          • PRB: Sort Order Has Changed with Microsoft Jet Version 4.0
          • PRB: SP Calls May Result in Attentions Being Seen on SQL Server
          • PRB: SQL Server Driver GP-Faults with More Than 50 Datatypes
          • PRB: SQLCancel Instead of SQLFreeStmt Causes a Memory Leak
          • PRB: SQLConfigDatasource Allows PageTimeout Value of 0
          • PRB: SQLGetData w/ SQL_C_BINARY Causes GPF in 16-bit ODBC Test
          • PRB: SQLSetDescField Appears to Call Itself
          • PRB: STINYINT Data Type Not Supported in Access Driver
          • PRB: Stored Procedure Fails if Rights Are Revoked and Regranted
          • PRB: Stored Procedures Slower with MS Oracle ODBC Driver 2.0
          • PRB: Ten or More Parameters in an Oracle Procedure Call Fails
          • PRB: Unexpected Errors Using OLE DB Provider for SQL Server
          • PRB: Using Lower Case Table Names Exporting Access 2000 Table
          • PRB: VBScript 'Type Mismatch' Error When Field Type Is adNumeric
          • PRB: Visigenic Oracle Driver Case-Sensitive w/ Catalog API
          • PRB: Visual Basic DisableAsync Fails w/ MASJT200.DLL
          • Reverting to the Access 97 ODBC Driver After Installing MDAC
          • Unsup.exe Finds Commands Not Supported by ODBC Drivers
          • Vfpodbcx.exe Visual FoxPro ODBC Driver Version 1.0
          • Xslatezp.exe Data Translation using JET as a Medium
      • ▶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