Microsoft Data Access Components (MDAC) 2.6 articles, fixes and updates - letter P

This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft Data Access Components (MDAC) 2.6 starts with letter P that have been released. The list is daily updated.

• 306916 PRB: VBScript "Type Mismatch" Error When Field Type Is adNumeric Q306916 KB306916 June 10, 2019
• 306586 PRB: Troubleshooting Error 80004005 "Login Failed" in ASP Q306586 KB306586 June 10, 2019
• 253500 PRB: "Client Unable to Establish Connection" Error Message When Connecting from ASP to SQL Server Q253500 KB253500 April 20, 2018
• 195180 PRB: VBScript "Type Mismatch" Error When Field Type Is adNumeric Q195180 KB195180 April 20, 2018
• 175239 PRB: 80020009 Error When Retrieving Data from SQL Q175239 KB175239 April 20, 2018
• 307002 PRB: ASP/ODBC/SQL Server Error 0x80040E4D "Login Failed for User '(Null)'" Q307002 KB307002 April 19, 2018
• 275927 PRB: Run-Time Error Message 3705 Occurs When Trying to Set the ActiveConnection Property of an ADO Recordset to Nothing Q275927 KB275927 April 19, 2018
• 306269 PRB: Error 80004005 "The Microsoft Jet Database Engine cannot open the file '(unknown)'" Q306269 KB306269 April 16, 2018
• 242956 PRB: DB_E_BADBINDINFO Returned from MoveNext/GetData When Using BYREF with Column Type Q242956 KB242956 January 16, 2015
• 256174 PRB: One or More Properties Cannot be Set on Query for OLE DB Provider SQLOLEDB Q256174 KB256174 January 10, 2015
• 817518 Passing ADODB::Field object to ADO Command.CreateParameter method causes a memory leak Q817518 KB817518 February 27, 2014
• 241639 PRB: "Errors Occurred" Error When Calling Stored Procedure with More than a SELECT Statement Q241639 KB241639 December 27, 2013
• 311720 PRB: MDAC Rollback May Fail on Windows 95, Windows 98, and Windows Millennium Edition Q311720 KB311720 October 26, 2013
• 310663 PRB: SQLBrowseConnect Does Not Enumerate SQL Server 7.0 Servers Q310663 KB310663 October 26, 2013
• 295000 PRB: "Could not load the setup or translator library" JET ODBC Error on Windows Millennium Edition Q295000 KB295000 October 23, 2013
• 284942 PRB: ADO Does Not Support Default Values in Stored Procedures Q284942 KB284942 October 23, 2013
• 237388 PRB: Microsoft 32-Bit ODBC Drivers Cannot Be Used from 16-Bit Applications Q237388 KB237388 October 21, 2013
• 259477 PRB: ODBC Unicode Cursor Library Load Fails Q259477 KB259477 January 22, 2013
• 286442 PRB: MDAC 2.6/2.7 Roll Back Installation or Get Error on Install Q286442 KB286442 January 17, 2013
• 236786 PRB: "Numeric Value Out of Range" Error when Calling GetFieldValue and Using SQL UNION Q236786 KB236786 December 17, 2012
• 238401 PRB: Error "Unrecognized Database Format" When You Upgrade to Access 2000 or 2002 Q238401 KB238401 September 17, 2011
• 286382 PRB: Errors When You Open ADO Connection in Transactional Components Q286382 KB286382 December 5, 2007
• 280841 PRB: Error "GetXaSwitch Function Failed" When You Use Transactional MTS/COM+ Components with Oracle Databases Q280841 KB280841 December 5, 2007
• 191094 PRB: MDAC 2.x Requires DCOM95 to Install Under Windows 95 Q191094 KB191094 October 26, 2007
• 322170 PRB: Rollback from MDAC 2.6 Service Pack 2 Refresh Fails Q322170 KB322170 May 17, 2007
• 264012 PRB: Connectivity Issue with MDAC and Oracle8i Q264012 KB264012 May 17, 2007
• 255986 PRB: Improper Installation of MDAC May Return Error Message "Method '~' of Object '~' Failed" at Run Time with ADO Application Q255986 KB255986 May 17, 2007
• 191271 PRB: ERR "ADO Could Not Find The Specified Provider" Q191271 KB191271 May 17, 2007
• 177514 PRB: Installing MDAC/ADO/RDS on Windows NT Requires Admin Privileges Q177514 KB177514 May 17, 2007
• 170769 PRB: "ODBC Resource DLL Is a Different Version Than ..." Error Q170769 KB170769 March 29, 2007
• 289573 PRB: Configuring DSNs with SQL Server Net-Libraries Q289573 KB289573 March 27, 2007
• 837770 PRB: Error occurs when you try to rollback MDAC installation Q837770 KB837770 March 16, 2007
• 280084 PRB: Parameters.Refresh Fails Using Parameter Token in Nested SQL Q280084 KB280084 February 23, 2007
• 268972 PRB: Requery of ADODB.Recordset Returns Unknown Error Message (80040e4b) with Microsoft Remote Provider Q268972 KB268972 February 12, 2007
• 241267 PRB: SQL Server Link to Remote Database Fails with Error 7399 Q241267 KB241267 February 12, 2007
• 306441 PRB: Troubleshooting Error 80004005 "Couldn't Lock File" in ASP Q306441 KB306441 August 11, 2006
• 306345 PRB: ASP Error 80004005 "Data Source Name Not Found" Q306345 KB306345 August 11, 2006
• 275917 PRB: ADSI 2.5 and MDAC 2.6 Compatibility Issues Q275917 KB275917 May 15, 2006
• 174640 PRB: ASP Error "The Query Is Not Updateable" When You Update Table Record Q174640 KB174640 May 2, 2006
• 174638 PRB: ODBC Error When You Pass Date Parameters to SQL Stored Procedure Q174638 KB174638 May 2, 2006
• 164479 PRB: Windows 95 Hangs When You Use ADO with Active Server Pages Q164479 KB164479 May 2, 2006
• 280067 PRB: Retrieving very large XML Documents from SQL Server 2000 by using ReadText method of ADO stream object may be slow Q280067 KB280067 June 30, 2005
• 222664 PRB: Call to SQL Stored Procedure Returns 'Invalid Column Name' Q222664 KB222664 June 23, 2005
• 196968 PRB: SHAPE Provider Pulls Down All Records in Child Table Q196968 KB196968 March 14, 2005
• 193347 PRB: Error When You Use MS Data Shape Provider in Data Environment Q193347 KB193347 March 14, 2005
• 178038 PRB: Implicit Conversion Error Calling Second Stored Procedure Q178038 KB178038 March 14, 2005
• 195470 PRB: ODBC 3.0 Requirements for Numeric Fields Q195470 KB195470 March 2, 2005
• 190410 PRB: Error Assigning Non-Opened Recordset to ADODC Q190410 KB190410 March 2, 2005
• 286381 PRB: ORA-0600 internal error when calling Oracle external stored procedures Q286381 KB286381 December 6, 2004
• 189206 PRB: "Couldn't Find File 'Unknown'" Error When You Set Default Language to JScript Q189206 KB189206 July 20, 2004
• 237536 PRB: 80004005 Unspecified Error When Passing Disconnected Recordset from MTS to ASP Q237536 KB237536 July 16, 2004
• 203573 PRB: ASP/ADO Coding Error Produces ASP 0115 Error Q203573 KB203573 June 29, 2004
• 190605 PRB: Binding Hierarchical Recordset in Data Environment Q190605 KB190605 June 24, 2004
• 320744 PRB: Incorrect NUMERIC and DECIMAL conversions with non-English locales Q320744 KB320744 May 25, 2004
• 245485 PRB: Load From Stream Fails When Specifying MSPersist Provider Q245485 KB245485 February 24, 2004
• 286245 PRB: Error Updating Records Using DB2OLEDB and Server-Side ADO Cursor Q286245 KB286245 February 16, 2004
• 296091 PRB: MFC AppWizard Does Not Show Oracle Synonyms with Microsoft ODBC Driver Q296091 KB296091 January 23, 2004
• 280346 PRB: Updating MDAC Resets ODBC Registry Settings That Were Previously Set Q280346 KB280346 December 18, 2003
• 267455 PRB: Problems Encountered When You Use Oracle Aggregate Functions on Non-Null Columns With Client-Side Cursors Q267455 KB267455 December 8, 2003
• 177135 PRB: Do not Call ODBC Within DLL_PROCESS_DETACH Case Q177135 KB177135 December 8, 2003
• 286370 PRB: OpenQuery Function Fails with Queries That Exceed 8000 Characters Q286370 KB286370 December 5, 2003
• 285321 PRB: MDAC Installation Fails When Registering OCX Q285321 KB285321 December 5, 2003
• 281268 PRB: Performance Issues with SQL Server OLE DB Provider When Working with BLOB Data Types Q281268 KB281268 December 5, 2003
• 277667 PRB: SELECT DISTINCT Fails with Microsoft ODBC for Oracle Q277667 KB277667 December 5, 2003
• 272358 PRB: SQLOLEDB Allows Only One Connection in Scope of Transaction Q272358 KB272358 December 5, 2003
• 262934 PRB: ActiveX Data Objects Update Method Fails When the SELECT Statement Contains a Subquery Q262934 KB262934 December 5, 2003
• 251254 PRB: "Disk or Network Error" or "Unspecified Error" Returned when Using Jet Q251254 KB251254 December 5, 2003
• 247253 PRB: Error Importing an Oracle Table in Access 2000 When Tablename Contains Lower Case Letters in USER_OBJECTS System Catalog Q247253 KB247253 December 5, 2003
• 241147 PRB: SQL Server ODBC Driver Returns Output Parameter as a Result Set in a Plain SQL Statement Q241147 KB241147 December 5, 2003
• 238116 PRB: Accessing a Temporary SQL Server Table Results in a DB_E_NOTABLE Q238116 KB238116 December 5, 2003
• 237992 PRB: Query Testing for NULL in Access Database Does not Return Records with Jet 4.0 Q237992 KB237992 December 5, 2003
• 216973 PRB: "Errors Occurred" upon Accessing Index Server 2.0 via RDS Q216973 KB216973 December 5, 2003
• 202376 PRB: Idle Jet Application Can Prevent Standby Mode Q202376 KB202376 December 5, 2003
• 300184 PRB: Error in ADO Recordset with 255 Fields from Visual FoxPro Table Q300184 KB300184 December 3, 2003
• 299484 PRB: Columns Are Sorted Alphabetically When You Use ADOX to Retrieve Columns of Access Table Q299484 KB299484 December 3, 2003
• 293873 PRB: ADO Recordset AddNew and Update Methods Ignore ANSI PADDING OFF Setting Q293873 KB293873 December 3, 2003
• 293805 PRB: Connection to Jet Database Fails If You Use DCOM and Database on Network Q293805 KB293805 December 3, 2003
• 291999 PRB: DB2 Stored Procedures on OS390 Return Invalid Parameter Information Q291999 KB291999 December 3, 2003
• 253240 PRB: Errors Not Returned When Stored Procedure Statement Fails Q253240 KB253240 December 3, 2003
• 253114 PRB: SQL_DRIVER_NOPROMPT Error When Using DEconnection in VB COM Object Q253114 KB253114 December 3, 2003
• 246360 PRB: Space in ConnectString Does Not Allow Pessimistic Locking Q246360 KB246360 December 3, 2003
• 205439 PRB: Text Files That Use Non-Standard Text Delimiters Do Not Parse Properly with Microsoft Text Driver Q205439 KB205439 December 3, 2003
• 193339 PRB: Unexpected Errors Using OLE DB Provider for SQL Server Q193339 KB193339 December 3, 2003
• 192652 PRB: ADO/RDS Update Error with Third Party ODBC Drivers Q192652 KB192652 December 3, 2003
• 180853 PRB: Stored Procedure Fails if Rights Are Revoked and Regranted Q180853 KB180853 December 3, 2003
• 179237 PRB: Searching Phrases with Numbers in MSIDXS OLE DB Provider Q179237 KB179237 December 3, 2003
• 178391 PRB: Oracle TNS: Authentication Service Initialization Error Q178391 KB178391 December 3, 2003
• 146220 PRB: The ODBC Text File Driver Only Supports INSERT Statement Q146220 KB146220 December 3, 2003
• 294157 PRB: Cannot Retrieve Primary Key Using ADOX Key Object Collection Q294157 KB294157 November 26, 2003
• 230912 PRB: "Not a Valid Month" Error when Inserting into Oracle Date Fields Q230912 KB230912 November 26, 2003
• 299454 PRB: "System Error 5" When You Connect to a DB2 Database from an ASP Page Q299454 KB299454 November 17, 2003
• 294189 PRB: *StringLengthPtr Returns Incorrect Value When SQLGETInfo Called with Insufficient Buffer Size Q294189 KB294189 November 17, 2003
• 289278 PRB: Setting DBPROP_REMOVEDELETED Property to VARIANT_FALSE Fails to Open Fast-Forward Cursor Q289278 KB289278 November 17, 2003
• 288141 PRB: Window Associated with Access Driver May Not Appear When Configuring System or User DSN Q288141 KB288141 November 17, 2003
• 286204 PRB: Slow CGI Performance with Microsoft ODBC for Oracle on Windows NT 4.0 Q286204 KB286204 November 17, 2003
• 165869 PRB: ODBC Version Conflict Messages Launching Visual InterDev Q165869 KB165869 November 17, 2003
• 253673 PRB: Recordset Based on SQL Server View Updates Base Tables Q253673 KB253673 November 7, 2003
• 294218 PRB: Requery Method Changes LockType Property of ADO Recordset to Read-Only Q294218 KB294218 November 5, 2003
• 279651 PRB: ADO Recordset Field Name with Letter "i" Is Case-sensitive with Turkish Settings Q279651 KB279651 November 5, 2003
• 245344 PRB: MoveNext Method Sometimes Skips Rows Or Reaches EOF When Recordset Is Sorted Q245344 KB245344 November 5, 2003
• 235052 PRB: TDS Error with Substring and Multiple ADO Recordsets Q235052 KB235052 November 5, 2003
• 309166 PRB: MDAC Installation Rolls Back at the Very End of the Setup Process Q309166 KB309166 November 4, 2003
• 252405 PRB: ADO EOF Returns True on SQL Server 7.0, Returns Time-out Error on SQL Server 6.5 Q252405 KB252405 November 4, 2003
• 305838 PRB: MDAC Installation on Windows Terminal Server May Fail Q305838 KB305838 November 3, 2003
• 293886 PRB: Prepare Command with Nonexistent Table Returns Success with Jet OLEDB Provider Q293886 KB293886 November 3, 2003
• 286213 PRB: Second Parameterized Command Fails with Server Cursor Q286213 KB286213 November 3, 2003
• 248404 PRB: Run-Time Error Message 430 with ADO Redistributed Application Q248404 KB248404 November 3, 2003
• 235053 PRB: E_FAIL Returned from Prepare() When SQL Statement Contains a Parameter in a Subquery Q235053 KB235053 November 3, 2003
• 294133 PRB: GetNextRows Returns DB_S_ROWLIMITEXCEEDED When DBPROP_MAXOPENROWS Is 0 Q294133 KB294133 October 31, 2003
• 259555 PRB: Error Occurs When You Open an ADO Recordset on an XML Stream Q259555 KB259555 October 31, 2003
• 303342 PRB: MDAC 2.6 SP1 Install Fails After MDAC 2.6 Install on Windows 2000 Q303342 KB303342 October 17, 2003
• 301667 PRB: Asynchronous Fetching Is Not Available with OLE DB Q301667 KB301667 October 17, 2003
• 245388 PRB: Attempting to Open Connection with Non-Existent Provider May Succeed Q245388 KB245388 October 17, 2003
• 248144 PRB: Error: "Not capable" When Opening a Record Object Off a Recordset Q248144 KB248144 September 24, 2003
• 234482 PRB: ADODB Out-of-Process Error with Microsoft OLAP Using Properties in SQL Statement Q234482 KB234482 September 22, 2003
• 245390 PRB: Open Record Fails When Specifying URL as Active Connection Q245390 KB245390 September 17, 2003
• 184237 PRB: Unable to Open Registry Key DriverID Error with Advworks Q184237 KB184237 September 17, 2003
• 259569 PRB: Installing Third-Party Product Breaks Windows 2000 MDAC Registry Settings Q259569 KB259569 September 16, 2003
• 225334 PRB: Jet/VBA May not Work Correctly w/ Datetime Data Containing Higher Precision for Fractional Seconds Q225334 KB225334 August 28, 2003
• 297997 PRB: MSXML Performance Bottleneck in ShareMutex Under Stress Q297997 KB297997 June 4, 2003
• 278454 PRB: Error 80070005 "Unexpected Error" When You Use Remote Data Service Q278454 KB278454 May 29, 2003
• 327557 PRB: ADO Does Not Support Decimal Numbers with Precision That Is Greater Than 28 Q327557 KB327557 May 28, 2003
• 326166 PRB: "Query Cannot Be Updated" Error Message with OLE DB Provider for ODBC Drivers Q326166 KB326166 May 12, 2003
• 306744 PRB: MSDASQL Incorrectly Matches Parameter Names with an Empty String Q306744 KB306744 May 12, 2003
• 306508 PRB: ODBC User DSNs Not Visible on Terminal Server Q306508 KB306508 May 12, 2003
• 304332 PRB: Installing MDAC on Terminal Server Q304332 KB304332 May 12, 2003
• 294850 PRB: ADO Delete Method May Delete More Rows Than Expected Q294850 KB294850 May 12, 2003
• 294424 PRB: Error Opening an ADO Recordset from a File Q294424 KB294424 May 12, 2003
• 294139 PRB: Errors Occur with Forward-Only Server-Side Cursor When You Use ADO Recordset Find Q294139 KB294139 May 12, 2003
• 271645 PRB: CompareBookmarks Method and Bookmarks in ADO Q271645 KB271645 May 12, 2003
• 269842 PRB: ADO Disconnected Recordset Appears to Leak Memory when Editing in Place Q269842 KB269842 May 12, 2003
• 269594 PRB: Error Message "[Microsoft][ODBC driver for Oracle] Syntax error or access violation;37000" Q269594 KB269594 May 12, 2003
• 268797 PRB: Client Cursor Engine May Not Asynchronously Fetch Against a Custom OLE DB Provider Q268797 KB268797 May 12, 2003
• 250999 PRB: RDS Does Not Work Correctly with OLE DB Simple Provider Q250999 KB250999 May 12, 2003
• 245500 PRB: Catastrophic Error Seen with Addition of Datasource Connection to Sybase 11x Q245500 KB245500 May 12, 2003
• 271198 PRB: Unicode Data is not Converted to ANSI with SQLBindParameter and ANSI ODBC Driver Q271198 KB271198 May 10, 2003
• 260145 PRB: Cannot Enumerate OLE DB Providers Q260145 KB260145 May 10, 2003
• 313861 PRB: Recordset Does Not Open with A Stored Procedure that Returns a High Severity Error Q313861 KB313861 May 8, 2003
• 313831 PRB: Charset Property of ADO Stream Object May Require Microsoft Internet Explorer Upgrade Q313831 KB313831 May 8, 2003
• 308980 PRB: Native Error Is Not Sent Back to ADO When You Run a SQL XML Query Q308980 KB308980 May 8, 2003
• 305676 PRB: Memory Leak When MDAC Is Running on Windows NT 4.0 Q305676 KB305676 May 8, 2003
• 298118 PRB: Error When You Combine ADO Refresh Method with CreateParameter Q298118 KB298118 May 8, 2003
• 297502 PRB: Error -2147217887 "No Error Description" When You Send SQL Text Field to Output Stream Q297502 KB297502 May 8, 2003
• 294141 PRB: Error Opening Shaped Recordset Based on Recordset with Temporary Table Q294141 KB294141 May 8, 2003
• 293802 PRB: ADO Refresh Method May Fail with Oracle Stored Procedure Q293802 KB293802 May 8, 2003
• 288403 PRB: Visual Basic String (BSTR) in Variant Field in ADO Recordset Cannot Be Persisted to ADTG Q288403 KB288403 May 8, 2003
• 286241 PRB: Error Message When You Save a NULL Value with ADODC and Bound Controls Q286241 KB286241 May 8, 2003
• 271553 PRB: Marshalling ADO Recordsets During an AddNew Method Q271553 KB271553 May 8, 2003
• 249012 PRB: Shaped Recordset Returns Incorrect Number of Records Q249012 KB249012 May 8, 2003
• 247810 PRB: Localization of ODBC Driver Causes Duplicate ODBC Driver Entries Q247810 KB247810 May 8, 2003
• 245374 PRB: adDBTime and adDBDate Columns Print Incorrect Values with ADO Q245374 KB245374 May 8, 2003
• 245367 PRB: Updating ADO Recordset Persisted from Read-Only Cursor May Fail Q245367 KB245367 May 8, 2003
• 238279 PRB: Executing Refresh Method of ADO Data Control Causes Syntax and Method Refresh Errors Q238279 KB238279 May 8, 2003
• 221240 PRB: Firewalls or Proxy Servers Can Cause RDS to Fail Q221240 KB221240 May 8, 2003
• 202955 PRB: Filter Property Fails When Using Multiple Single Quotation Marks Q202955 KB202955 May 8, 2003
• 200591 PRB: 8570 Report Sections Do Not Match DataSource Q200591 KB200591 May 8, 2003
• 195983 PRB: DataGrid Control Does Not Return Contents of Edited Cell Q195983 KB195983 May 8, 2003