CDatabase/CRecordSet in MFC console app

[hzt0qb]

I need to get information from a MSSQL server from a MFC console app.
Do I need to use CDataBase and CRecordSet? how do they (if at all) tie up together.
I need to get a single field based on a "select [field] where [field] like '[var]' and [field] like '[var]'".

~Thanks
me

 

[Cagliostro]

CDatabase db;
db.open("driver={SQL Server};server={servername};uid={userID};pwd={password};database={dbname}"
CRecordset rcs(&db);
rcs.Open(
AFX_DB_USE_DEFAULT_TYPE,
"select * from ..."
);
Ion Filipski

filipski@excite.com