76) 12/14/2003 294160294160  294160.html">BUG: Update of Newly Inserted Row Causes DB_E_ERRORSOCCURRED
(294160) - On updating a row which has been newly inserted into a table, whether through an OLEDB rowset or an ActiveX Data Objects (ADO) recordset, the following error may occur: (0x80040e21, DB_E_ERRORSOCCURRED) Multiple-step OLE DB operation generated errors....

77) 12/14/2003 294149294149  294149.html">BUG: Function Sequence Error Not Returned for Transactions When Connection Pooling Is Disabled
(294149) - When ODBC connection pooling is disabled, using the following sequence in a loop does not result in a "Function sequence error": SQLExecDirect SQLFetch SQLSetStmtOption (SQL_ATTR_AUTOCOMMIT,SQL_AUTOCOMMIT_OFF) SQLTransact(SQL_COMMIT) SQLSetStmtOption...

78) 12/14/2003 294140294140  294140.html">FIX: Connection Pooling Causes Windows 2000 Computer with MDAC 25/2.5 SP1 to Stop Responding
(294140) - When an application that uses multiple threads that share a global environment handle implements Open Database Connectivity (ODBC) connection pooling, the application may stop responding (hang) on the platforms listed above with MDAC version 2.5 or...

79) 12/14/2003 286370286370  286370.html">PRB: OpenQuery Function Fails with Queries That Exceed 8000 Characters
(286370) - When you try to execute an extremely long query text (greater than 8000 characters) inside of an OPENQUERY function, with a linked server, you may see error messages similar to: Server: Msg 170, Level 15, State 1, Line 1 Line 1: Incorrect syntax near...

80) 12/14/2003 281646281646  281646.html">FIX: Buffer Overrun When Using SQLConnectW with ODBC Pooling
(281646) - When you call the ODBC function SQLConnectW and supply non-null terminated strings for the data source name (DSN), user ID (UID), or password (PWD) parameters along with length indicators indicating the exact byte length of the strings, this may later...

81) 12/14/2003 281633281633  281633.html">FIX: SQLOLEDB Provider Incorrectly Leaves Transaction Open
(281633) - Running a certain sequence of commands involving explicit transactions and parameters in an application program using the SQLOLEDB Provider incorrectly leaves an uncommitted transaction open. This can cause severe blocking and other problems.

82) 12/14/2003 280084280084  280084.html">PRB: Parameters.Refresh Fails Using Parameter Token in Nested SQL
(280084) - When you call the ActiveX Data Objects (ADO) Parameters.Refresh function on a SQL statement that contains parameter tokens inside of a nested SELECT statement, the following error may be reported by the SQL Server OLEDB Provider and SQL Server ODBC...

83) 12/14/2003 265885265885  265885.html">FIX: Cannot Get OLE DB Errors on Japanese Windows 95 and Windows 98
(265885) - When you run an OLE DB or ActiveX Data Objects (ADO) application on Japanese Windows 95 or Japanese Windows 98 with MDAC 2.5 installed, Japanese error messages that are raised by the OLE DB Core Services layer are blank. When an error in the OLE DB...

84) 12/14/2003 249819249819  249819.html">HOWTO: Pass a Timestamp Value To or From SQL Server With ODBC API
(249819) - The SQL Server data type timestamp is a column value that is automatically updated every time a row is inserted or updated. Values in timestamp columns are not date/time data. By default, they are defined as binary(8) (for non nullable columns) or...

85) 12/14/2003 267455267455  267455.html">PRB: Problems Encountered When You Use Oracle Aggregate Functions on Non-Null Columns With Client-Side Cursors
(267455) - When you use aggregate functions like DECODE() on Oracle views derieved from tables with non-null columns, NULL values can be returned. Attempting to query the value of the column or trying to perform a MoveFirst causes the following error message:...

86) 12/14/2003 247758247758  247758.html">INFO: No Padding of Parameters Done by SQL Driver Prior to Version 3.7x
(247758) - SQLBindParameter() in the SQL Server ODBC driver version 3.7x behave differently from previous releases of the driver. With SQL Server ODBC drivers prior to version 3.7x, parameter values specified with SQLBindParameter() are not padded with spaces...

87) 12/14/2003 252475252475  252475.html">BUG: ODBC Admin Displays Only a Certain Number of DSNs
(252475) - The ODBC Administrator will not display more than 4096 characters worth of data source names (DSNs). The data sources may be entered correctly (physically present in the registry) and still work correctly but not all of them display.

88) 12/14/2003 254021254021  254021.html">HOWTO: Return an Array of Recordsets from an ADO/RDS Server
(254021) - This article assumes intermediate knowledge of ATL, ADO and RDS technologies. This article demonstrates one way to pass an array of Recordsets from an ActiveX Data Objects (ADO)/Remote Data Service (RDS) server.

89) 12/14/2003 247253247253  247253.html">PRB: Error Importing an Oracle Table in Access 2000 When Tablename Contains Lower Case Letters in USER_OBJECTS System Catalog
(247253) - The error message: ORA-00942: table or view does not exist will be seen when trying to access a table which was exported from Access 2000 using MSORCL32.DLL and the destination table is not specified using upper case letters.

90) 12/14/2003 247070247070  247070.html">BUG: Opening a Long-Running View from SQL Server Enterprise Manager Gets ODBC Timeout
(247070) - Opening a view that executes a long running query in the SQL Server 7.0 Enterprise Manager (SEM) will get an ODBC Timeout error.