To give you a head start, the ODBC classes can be thought of as a "catch all" for any database that supports an ODBC driver. For example, you can use the ODBC classes to connect to Sql Server, Access, or Oracle. However, since you have indicated that you are using Sql Server I would suggest using the SQL classes since they are optimized for use with Sql Server.
Read this if you want to know how to get a correct reply for your question:
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7