1036) 2/10/2002 Q293658Q293658  Q293658.html">HOWTO: Force Query-Based Updates with ADO and MSDASQL (Q293658)
When you use ActiveX Data Objects (ADO) with the Microsoft OLEDB Provider for ODBC Driver (MSDASQL), and you try to update a table using a server-side cursor, ADO uses positioned update by default. In this case, the MSDASQL provider calls t

1037) 2/10/2002 Q293823Q293823  Q293823.html">HOWTO: Configure ADO to Ignore Duplicates During a Bulk Insert into an Access Database (Q293823)
When you insert a number of records into a table in a Microsoft Access database, you may want any records that duplicate existing records to be ignored with no error or warning message, and you may want only unique new values to be inserted

1038) 2/10/2002 Q293886Q293886  Q293886.html">PRB: Prepare Command with Nonexistent Table Returns Success with Jet OLEDB Provider (Q293886)
When

1039) 2/10/2002 Q304365Q304365  Q304365.html">BUG: Slow Performance with SQLOLEDB Inserting BLOB Data into SQL Server Using Stored Procedure (Q304365)
The Microsoft OLE DB provider for SQL Server (SQLOLEDB) is almost ten times slower than the Microsoft OLE DB provider for ODBC Drivers (MSDASQL) when inserting binary large object (BLOB) data into a SQL Server database using a stored proce

1040) 2/10/2002 Q192886Q192886  Q192886.html">PRB: Alpha MS Oracle ODBC Driver Does Not Work With Oracle8 (Q192886)
When you attempt to create a Data Source Name (DSN) for the Alpha version of the Microsoft Oracle ODBC Driver (v2.573.2927) for use with the Oracle8 client components, you receive the following error:

1041) 2/10/2002 Q238116Q238116  Q238116.html">PRB: Accessing a Temporary SQL Server Table Results in a DB_E_NOTABLE (Q238116)
When using the SQL Server ODBC driver with forward-only server-side cursors in trying to access a local temporary SQL Server table that was explicitly created using the same ActiveX Data Object (ADO) connection object, the application rec

1042) 2/10/2002 Q263561Q263561  Q263561.html">INFO: Non-BDE Paradox and dBase ISAM Drivers (Q263561)
Microsoft has created new Paradox and dBASE ISAM drivers for Microsoft Jet 4.0 that do not require the installation of the Borland Database Engine (BDE) to provide full read/write access to Paradox and dBASE files. The current Jet 4.0-based

1043) 2/10/2002 Q269735Q269735  Q269735.html">INFO: IBM DB2 ODBC Driver and Microsoft Transaction Server (Q269735)
This article describes the steps that you should use while performing distributed transactions under Microsoft Transaction Server (MTS) when you use the IBM DB2 ODBC driver version 6.01 or later.

1044) 2/10/2002 Q232831Q232831  Q232831.html">INFO: Use the Merant 3.5 ODBC Driver to Work in Production Environments with IIS and MTS (Q232831)
Applications that require the Sybase SQL Server Database Management System and Microsoft Internet Information Server (IIS) version 4.0 or Microsoft Transaction Server (MTS) version 2.0 should use the Connect ODBC for Sybase Driver version 3

1045) 2/8/2002 Q231943Q231943  Q231943.html">INFO: Microsoft Data Access Components (MDAC) Release History (Q231943)
This article outlines the different Microsoft Data Access Component (MDAC) versions available and the products that install them.

1046) 12/8/2001 Q308401Q308401  Q308401.html">FIX: SQLExecute on a Prepared Statement with SQL_NOSCAN_ON Causes Client-Side AV (Q308401)
When you execute a statement that was prepared with the SQL_ATTR_NOSCAN attribute, you may receive an access violation (AV) as follows:

1047) 12/8/2001 Q311505Q311505  Q311505.html">BUG: "PL/SQL Argument Name Is Invalid" Error Message When You Use MSDAORA with 30 Character Parameter (Q311505)
When you use Microsoft OLE DB Provider for Oracle (MSDAORA) to run a stored procedure that takes parameters of 30 characters in length, you receive the following error message:

1048) 12/8/2001 Q302248Q302248  Q302248.html">FIX: SQLOLEDB Does Not Work with DBACCESSOR_OPTIMIZED Flag and SSPROP_ENABLEFASTLOAD (Q302248)
Using the Microsoft OLEDB Provider for SQL Server (SQLOLEDB) that comes with Microsoft Data Access Components (MDAC) version 2.6 or 2.6 SP1, when you set the value of the SSPROP_ENABLEFASTLOAD property to true in the SQLSERVERDATASOURCE pro

1049) 12/8/2001 Q308037Q308037  Q308037.html">FIX: ADO GetValue Does Not Check DBSTATUS_S_ISNULL for VARIANT (Q308037)
When using ActiveX Data Objects (ADO) against certain OLE DB providers, you may find that recordset fields that should be NULL do not test for NULL correctly either by checking the VARIANT.vt value for VT_NULL (in Microsoft Visual C++) or b