Sams Teach Yourself Microsoft® Windows® DNA Programming in 21 Days

Day 6

Quiz

1:	True/False. Connection strings always reference a DSN.
A1:	False, you can have DSN-less connections.
2:	When would the RecordCount for a recordset always come back with -1?
A2:	With ForwardOnly and ReadOnly recordsets, it will not return a recordcount.
3:	What's the name of the default OLE DB Provider?
A3:	MSDASQL.
4:	What object and corresponding method would you use to update a record?
A4:	Command.Execute .
5:	What should you add to your command object when calling stored procedures and what methods do you use?
A5:	Add parameters to the stored procedure using the Append method off the Parameters collection and the CreateParameter method on the Command object .
6:	What are the two new objects with ADO 2.5?
A6:	The Record and ...