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