View Full Version : Can you recommend me a textbook in ADO ?

07-10-2007, 11:43 AM
Can you recommend me a textbook in ADO ? Where I may find additional exercises in MYSQL & ADO with solutions ?

07-10-2007, 01:16 PM
The ASP Bible is a good place to start. It has everything, including ADO.

You will also want to use the VBScript Functions page and the ADO pages by MS.

VBScript Functions (http://msdn2.microsoft.com/en-us/library/d1wf56tt.aspx)

ADO Functions (http://msdn2.microsoft.com/en-us/library/ms678086.aspx)

As to working with MySQL, DO NOT USE the rs.addnew and rs.update methods. They don't work well***, and they make your app database dependent on MS. Use standard SQL statements (INSERT, UPDATE, DELETE, etc.)

*** - That being said, they do work. However, in my experience of running ASP exclusively with MySQL since MySQL 3.23 (I'm on 5.0.38 now), the ADO functions addnew and update don't work that well.