Microsoft Data Access Components (MDAC) 2.7 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.7 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
• 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
• 293349 PRB: Retrieving Properties with OLE DB May Cause Memory Leak Q293349 KB293349 January 16, 2015
• 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
• 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
• 191094 PRB: MDAC 2.x Requires DCOM95 to Install Under Windows 95 Q191094 KB191094 October 26, 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
• 837770 PRB: Error occurs when you try to rollback MDAC installation Q837770 KB837770 March 16, 2007
• 241267 PRB: SQL Server Link to Remote Database Fails with Error 7399 Q241267 KB241267 February 12, 2007
• 306345 PRB: ASP Error 80004005 "Data Source Name Not Found" Q306345 KB306345 August 11, 2006
• 175671 PRB: 80004005 ConnectionOpen (CreateFile()) Error Accessing SQL Q175671 KB175671 May 2, 2006
• 174640 PRB: ASP Error "The Query Is Not Updateable" When You Update Table Record Q174640 KB174640 May 2, 2006
• 164479 PRB: Windows 95 Hangs When You Use ADO with Active Server Pages Q164479 KB164479 May 2, 2006
• 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
• 178040 PRB: ConnectionWrite(GetOverLappedResult) on Update/Insert - SQL Q178040 KB178040 March 2, 2005
• 170012 PRB: ASP Error 0115 When Connecting to Sybase/Oracle Database Q170012 KB170012 March 2, 2005
• 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
• 267455 PRB: Problems Encountered When You Use Oracle Aggregate Functions on Non-Null Columns With Client-Side Cursors Q267455 KB267455 December 8, 2003
• 286370 PRB: OpenQuery Function Fails with Queries That Exceed 8000 Characters Q286370 KB286370 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
• 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
• 291999 PRB: DB2 Stored Procedures on OS390 Return Invalid Parameter Information Q291999 KB291999 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
• 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
• 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
• 289278 PRB: Setting DBPROP_REMOVEDELETED Property to VARIANT_FALSE Fails to Open Fast-Forward Cursor Q289278 KB289278 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
• 311950 PRB: "Insufficient Base Table Information for Updating" Error Message When You Update a FoxPro Table with the Database Environment Q311950 KB311950 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
• 293886 PRB: Prepare Command with Nonexistent Table Returns Success with Jet OLEDB Provider Q293886 KB293886 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
• 259555 PRB: Error Occurs When You Open an ADO Recordset on an XML Stream Q259555 KB259555 October 31, 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
• 259569 PRB: Installing Third-Party Product Breaks Windows 2000 MDAC Registry Settings Q259569 KB259569 September 16, 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
• 318817 PRB: Configure RDS on a Windows XP IIS Server Q318817 KB318817 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
• 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
• 305676 PRB: Memory Leak When MDAC Is Running on Windows NT 4.0 Q305676 KB305676 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