Talk:ActiveX Data Objects
|WikiProject Computing||(Rated Start-class)|
|WikiProject Microsoft Windows / Computing||(Rated Start-class, Low-importance)|
Haven't worked with ADO recently, but doesn't it require either a specific ADO driver for the database you want to talk to, or else an ODBC driver if the database speaks ODBC? Also, I thought you had to pass SQL statements in the Command objects; how can you use it without any SQL? A nice 'Hello World' type example would be nice. Also, a list of programming languages known to support it; I think the list would include C++, Visual Basic, Perl, and perhaps Python and Tcl as well, via ActiveState's work? Wesley
- This question is two and a half years old, but still deserves an answer. ADO does not require specific ADO drivers, it can use the two most common formats for Windows database drivers: OLEDB (better) and ODBC (worse). A command object can be used by simply specifying a table name or a stored procedure as the command text, it need not be an SQL statement. However depending on your table size, row length, the information you are retrieving, it might be better to issue an SQL statement, since you can select a subset of columns and use a WHERE clause to filter. Client-side filtering on a large table is a major performance hit. Rhobite 04:06, Oct 17, 2004 (UTC)
Platform independent C++ counterpart for ActiveX Data Objects and 'VARIANT'
I am looking for an platform independent C++ counterpart of ActiveX Data Objects and Variant data type, I have used these objects/data type earlier in ATL COM environment but now I want a subset of the same (no need of DB connection functionality i.e. disconnect container object only for data transfer) in pure C++ code. The aim is to return either basic data type or a Resordset object from all of the exposed api to have consistent interface, I do not want to expose custom objects (say 'Customer', 'Address', 'Item', 'Order', 'Invoice' etc). The client which receives this RecordsetC++ object should be able to iterate through rows as well as all the fields (column) and should be able to get the data type of the field. Vjdchauhan 10:32, 15 January 2007 (UTC).
- Please bear in mind that Wikipedia is not a discussion forum. I have replied on your talk page. -- int19h 19:19, 15 January 2007 (UTC)
- Thanks for your reply. Frankly I do not fully agree with Wikipedia is not a discussion forum as project pages are not as visible as articles and finding the corresponding project/portal pages on WP is a task in itself and how will one know which user is expert on which topic thus such queries do make sense on article talk pages and it still serves the basic WP policy of sharing info/knowledge. Thanks again for you reply. Vjdchauhan 06:25, 16 January 2007 (UTC).
Useful for Beginners
This article is very useful for the beginners those who are in software development. If the professionals are interested in innovative project development and/or develop a tool definitely this ADO data control article is useful. Thanks & Regards. --Ananthakumar Selvaraj, SeA Microsystems 13:15, 18 March 2013 (UTC) — Preceding unsigned comment added by Ananthakumar Selvaraj (talk • contribs)