Talk:ActiveX Data Objects

This article is rated Start-class on Wikipedia's content assessment scale. It is of interest to the following WikiProjects:

Computing This article is within the scope of WikiProject Computing, a collaborative effort to improve the coverage of computers, computing, and information technology on Wikipedia. If you would like to participate, please visit the project page, where you can join the discussion and see a list of open tasks.ComputingWikipedia:WikiProject ComputingTemplate:WikiProject ComputingComputing articles ??? This article has not yet received a rating on the project's importance scale. Microsoft Windows: Computing Low‑importance This article is within the scope of WikiProject Microsoft Windows, a collaborative effort to improve the coverage of Microsoft Windows on Wikipedia. If you would like to participate, please visit the project page, where you can join the discussion and see a list of open tasks.Microsoft WindowsWikipedia:WikiProject Microsoft WindowsTemplate:WikiProject Microsoft WindowsMicrosoft Windows articles Low This article has been rated as Low-importance on the project's importance scale. This article is supported by WikiProject Computing.

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)

Wow!

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

talk page. -- int19h 19:19, 15 January 2007 (UTC)[reply

]

Agreed - the existance of a native C++ alternative to ADO would be relevant to the article. —Preceding unsigned comment added by 75.176.100.243 (talk) 22:52, 13 December 2009 (UTC)[reply]

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)

messege 185.187.94.66 (talk) 21:08, 24 November 2021 (UTC)[reply]