What do you think?
Rate this book
Professional ADO 2.5 Programming
All windows developers need to use ADO. ActiveX Data Objects (ADO) 2.5 is Microsoft's latest Data Access technology. It is used to enable fast and efficient data transfer between a database and the end users. What's more, ADO 2.5 works across a range of languages (VB, VC, ASP, Access, Office etc) and with a range of back-end databases - SQL Server 7, Oracle 8i, Access 2000 etc. Almost all developers work with some combination of these technologies, so they all need to know ADO.
1000 pages, Paperback
First published February 1, 2000
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 of 1 review
February 15, 2011
Great book even though it's dated, of course when you are programming in a dated language it doesn't matter! This was a great introduction into all the things ADO can do.
It would have been nice if it had more specific information for the parts that I played with but unfortunately it didn't. On the VBA excel blogs they have been tossing around the idea of using recordsets like classes. A great idea since you can create fabricated shaped recordsets from scratch in a single line with calculations. Then you try it out and find out that recordsets are incredibly slow compared to classes made with dictionaries. So they might be good as a class when your dataset is small but when it is big, it's not worth it! Of course, if you are interested in doing a ton of filtering then recordsets are faster than using the advanced filter in excel, but if you plan on printing the results to excel then the advanced filter wins hands down.
It would have been nice if it had more specific information for the parts that I played with but unfortunately it didn't. On the VBA excel blogs they have been tossing around the idea of using recordsets like classes. A great idea since you can create fabricated shaped recordsets from scratch in a single line with calculations. Then you try it out and find out that recordsets are incredibly slow compared to classes made with dictionaries. So they might be good as a class when your dataset is small but when it is big, it's not worth it! Of course, if you are interested in doing a ton of filtering then recordsets are faster than using the advanced filter in excel, but if you plan on printing the results to excel then the advanced filter wins hands down.
Displaying 1 of 1 review