Talk:ActiveX Data Objects

From Wikipedia, the free encyclopedia
Jump to: navigation, search
WikiProject Computing (Rated Start-class)
WikiProject icon 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.
Start-Class article Start  This article has been rated as Start-Class on the project's quality scale.
 ???  This article has not yet received a rating on the project's importance scale.
 
WikiProject Microsoft Windows / Computing  (Rated Start-class, Low-importance)
WikiProject icon 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.
Start-Class article Start  This article has been rated as Start-Class on the project's quality scale.
 Low  This article has been rated as Low-importance on the project's importance scale.
Taskforce icon
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!

Platform independent C++ counterpart for ActiveX Data Objects and 'VARIANT'[edit]

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).
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)

Useful for Beginners[edit]

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 (talkcontribs)