Talk:ADO
|
|
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!