SQL-DMO

[monrobot13]

I was just doing some searching for SQL stuff here on CP and saw some things using SQL-DMO. After looking through the SQL Server Books Online that I downloaded I had a quick question. SQL-DMO doesn't seem like a good tool for retrieving information from a database, but more for administering it (adding tables, columns, etc). Am I right in that assesment? Is the best way for an MFC app to use CRecordset, and related ODBC classes? Thanks. - monrobot13

[LizardWiz]

I typically use ADO to run stored procedures and sql statements. I use DMO to write administrative utilities that run backups and script objects...etc. I would agree with your assessment, at least from my perspective. ~LizardWiz()

[monrobot13]

Nice to hear that my assesment was correct. You brought another question to my mind. Is there MFC classes or include files/libs that I need to use ADO? I keep reading about it, but I've no idea how I use it. Thanks for the help. - monrobot13