1051) 9/29/2007 Q221240 PRB: Firewalls or Proxy Servers Can Cause RDS to Fail (Q221240)
Microsoft Remote Data Service for ADO (RDS) fails with different error messages when used in conjunction with some firewalls and proxy servers. 1052) 9/29/2007 Q216389 INFO: Maintaining Binary Compatibility in Components with ADOR (Q216389)
Originally, ADOR was designed to be a standalone component. However, as ADO has evolved in design and use, this is no longer ADOR's purpose. ADOR is now only a sub to the MSADO15.DLL and exists only to maintain backward compatibility. 1053) 9/20/2007 Q235566 BUG: Unexpected Cursor Behavior with Set NoCount Statement and SQLOLEDB (Q235566)
If you try to open a server-side ADO recordset with the "Set NoCount" statement, you would always get ForwardOnly recordset. 1054) 10/1/2007 Q237977 INFO: OLE DB Session Pooling Timeout Configuration (Q237977)
Beginning with MDAC 2.1, session pooling timeouts for OLE DB providers can now be configured in a manner very similar to ODBC connection pooling. This permits control over the length of time that an unused session will be retained in the po 1055) 9/29/2007 Q229929 INFO: Registry Entries and Keywords for SQL Server Connection Strings (Q229929)
This article describes the different registry entries that are created when you create a data source name (DSN) by using the Microsoft SQL Server ODBC Driver. 1056) 9/20/2007 Q193946 HOWTO: Demo of ADO AddNew, Update, Delete, Find and Filter (Q193946)
ActiveX Data Objects (ADO) implements record manipulation commands analogous to those found in the native FoxPro language. 1057) 9/29/2007 Q195049 HOWTO: Maintain Binary Compatibility in Components Exposing ADO (Q195049)
Recompiling a Visual Basic Project that uses Binary Compatibility can generate a warning to the following effect: 1058) 9/28/2007 Q195236 HOWTO: Get ADO Default Connection Information (Q195236)
Default connection properties might differ by driver. In your application, it might be important to obtain the ADO version number because you might need to know whether the driver uses server-side or client-side cursors, supports transactio 1059) 9/27/2007 Q176086 HOWTO: Retrieve Recordsets from Oracle Stored Procedures Using ADO (Q176086)
This article shows how to create a Visual Basic 5.0 and ActiveX Data Objects (ADO) project or a Visual Basic 6.0 and ADO project that returns a typical Recordset from an Oracle stored procedure. This article builds on the concepts covered i 1060) 9/29/2007 Q293658 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 1061) 9/29/2007 Q190371 HOWTO: Use Bound Controls with an ADO Recordset (Q190371)
If you want to use a bound ListBox, ComboBox, or Grid control with an ActiveX Data Objects (ADO) recordset, then use the DataList, DataCombo, or DataGrid control instead of the DBList, DBCombo, or DBGrid control. If you try to use DBList, D 1062) 9/29/2007 Q196084 HOWTO: Retrieve Foreign Key Information from SQL Server (Q196084)
When creating remote views using SQL Server tables as the data source, Visual FoxPro automatically sets the KeyField property to .T. for columns that are included in a primary index key. You can use the SQL Server stored procedure, sp_pkeys 1063) 9/29/2007 Q196384 HOWTO: Perform Bulk Inserts Using SQLSetPos (Q196384)
This article contains sample code that demonstrates how to perform bulk inserts using the SQLSetPos ODBC API call. The sample code illustrates a specific instance where bulk inserts are performed on the "Jobs" table in the SQL Server "Pubs" 1064) 9/28/2007 Q130506 HOWTO: Use AERROR() in Place of DBERROR() for ODBC Errors (Q130506)
DBERROR() is no longer used to retrieve errors generated by an ODBC function. 1065) 9/29/2007 Q237536 PRB: 80004005 Unspecified Error When Passing Disconnected Recordset from MTS to ASP (Q237536)
When passing a disconnected ActiveX Date Objects (ADO) Recordset from a Component Object Model (COM) component inside a Microsoft Transaction Server (MTS) Server Package/COM+ Application to Active Server Pages (ASP), you may receive one of
1
2
.... .... 67
68
69
70
[ 71 ]
72
73
74
75
Previous Page
Page 71 of 75
Next Page
|