Microsoft Data Access Components (MDAC) 2.6 articles, fixes and updates - December 2003

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 that have been released in December 2003. The list is daily updated.

• 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
• 294149 BUG: Function Sequence Error Not Returned for Transactions When Connection Pooling Is Disabled Q294149 KB294149 December 5, 2003
• 293901 BUG: Incorrect Number of Rows Inserted Using MS ODBC Driver and Stored Procedure on SQL Server Q293901 KB293901 December 5, 2003
• 293659 BUG: SQL Server ODBC Driver Incorrectly Maps Unicode Datatypes with SQL_C_DEFAULT Q293659 KB293659 December 5, 2003
• 289280 BUG: Oracle ODBC Connectivity Slow with MDAC 2.5/2.6 on Windows 95/98/NT Q289280 KB289280 December 5, 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
• 271852 BUG: MS Oracle ODBC Driver Truncates Trailing Spaces in Column Name Q271852 KB271852 December 5, 2003
• 262934 PRB: ActiveX Data Objects Update Method Fails When the SELECT Statement Contains a Subquery Q262934 KB262934 December 5, 2003
• 259959 INFO: Techniques to Debug Connectivity Issues to an Oracle Server Using the ODBC Driver and OLE DB Provider Q259959 KB259959 December 5, 2003
• 258576 INFO: Limitations of IRowsetIndex::Seek() Used with Jet database Q258576 KB258576 December 5, 2003
• 251254 PRB: "Disk or Network Error" or "Unspecified Error" Returned when Using Jet Q251254 KB251254 December 5, 2003
• 247758 INFO: No Padding of Parameters Done by SQL Driver Prior to Version 3.7x Q247758 KB247758 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
• 247070 BUG: Opening a Long-Running View from SQL Server Enterprise Manager Gets ODBC Timeout Q247070 KB247070 December 5, 2003
• 241347 BUG: Inserting/Updating Dates Before "01-01-1900" Into SQL Using JDBC-ODBC Creates Errors Q241347 KB241347 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
• 239725 BUG: SQL Server Error "Specified Column Precision 38 Is Greater Than the Maximum Precision of 28. (2750)" When Running Parameterized Query Q239725 KB239725 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
• 222831 HOWTO: Retrieving Numeric Data with SQL_NUMERIC_STRUCT Q222831 KB222831 December 5, 2003
• 216973 PRB: "Errors Occurred" upon Accessing Index Server 2.0 via RDS Q216973 KB216973 December 5, 2003
• 214854 INFO: Improved ODBC DataType Mappings with Jet 4.0 Q214854 KB214854 December 5, 2003
• 202376 PRB: Idle Jet Application Can Prevent Standby Mode Q202376 KB202376 December 5, 2003
• 177138 INFO: Nested Transactions Not Available in ODBC/OLE DB/ADO Q177138 KB177138 December 5, 2003
• 304394 FIX: Oracle Driver Doesn't Sort SQLPrimaryKeys Result Set by Key Sequence Q304394 KB304394 December 3, 2003
• 301518 BUG: WriteText Method Fails If You Set the charset Property of the ADO Stream Object to ASCII Q301518 KB301518 December 3, 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
• 294163 BUG: ADO Recordset EditMode Property Is Not Set If You Close Form While Editing Q294163 KB294163 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
• 257731 BUG: Error Message "Rows Must Be Released" with SQLOLEDB and ADO Recordset Events Q257731 KB257731 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
• 232144 INFO: Jet OLE DB Provider Version 4.0 Supports SELECT @@Identity Q232144 KB232144 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
• 195512 INFO: Reusing ADO Recordsets Maintains Properties Q195512 KB195512 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
• 180211 BUG: Synonyms Do Not Work With Oracle Stored Procedures Q180211 KB180211 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
• 140696 INF: RAISERROR, PRINT, and the MS SQL Server ODBC Driver Q140696 KB140696 December 3, 2003