991) 9/29/2007 Q192308 PRB: View Designer Misreads Date Criteria in ODBC Date Format (Q192308)
After saving and closing a remote view with a date criteria in the Open Database Connectivity (ODBC) Date Format, the View Designer does not read the criteria correctly. For example: 992) 9/26/2007 Q195047 HOWTO: Call a Parameterized SQL Server Stored Procedure from ADO (Q195047)
The main purpose of the ActiveX Data Objects (ADO) Command object is to allow the execution of stored procedures and parameterized commands against a data provider. 993) 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 994) 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. 995) 9/29/2007 Q195512 INFO: Reusing ADO Recordsets Maintains Properties (Q195512)
When you create a Recordset object without an active command, the recordset remains empty until it is associated with one. Therefore, it is possible to create a Recordset object at any point in a procedure, but not populate it until necessa 996) 9/26/2007 Q195585 PRB: "SQL: Cannot Locate Table" Message w/ Modify View Command (Q195585)
After issuing a Modify View command, the following message displays: 997) 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 998) 9/29/2007 Q203638 HOWTO: Return Information About SQL Server Linked Servers (Q203638)
SQL Server 7.0 allows the addition of external data sources as linked servers. This feature provides access to distributed, heterogeneous queries against OLE DB data sources. When connecting to SQL Server, a cursor listing available tables 999) 9/28/2007 Q314755 BUG: Error When You Install MDAC 2.7 After MDAC 2.6 Service Pack 2 (Q314755)
If you install Microsoft Data Access Components (MDAC) 2.7 after you have installed MDAC 2.6 Service Pack 2, you may receive the following error message: 1000) 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 1001) 9/23/2007 Q177947 PRB: "Syntax Error in FROM Clause" Using Text ODBC Driver (Q177947)
When you use the AppWizard to create a CRecordset class using the ODBC Text Driver, your project will compile. However, when you try to open the recordset, you will get the following error message: 1002) 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 1003) 1/10/2007 Q190773 INFO: ODBC/OLE DB/ADO/RDS are Inter-Dependent for MDAC 2.x (Q190773)
Microsoft Data Access Components (MDAC) version 2. 1004) 9/29/2007 Q193332 FILE: MDACCON.EXE Using Connection Strings with ODBC/OLEDB/ADO/RDS (Q193332)
Mdaccon.exe is a sample that that demonstrates the use of ODBC Driver and OLE DB Provider connection strings. Four separate projects, one each in C++, Visual Basic for Applications, and Java, as well as a C++ OLE DB Consumer Application, de 1005) 8/21/2006 Q192652 PRB: ADO/RDS Update Error with Third Party ODBC Drivers (Q192652)
When attempting an ActiveX Data Objects (ADO)/ Remote Data Services (RDS) update, using the OLEDB provider for ODBC (MSDASQL) with a third party ODBC driver, you may receive an error.
1
2
.... .... 63
64
65
66
[ 67 ]
68
69
70
71
.... 75
Previous Page
Page 67 of 75
Next Page
|