Use VC 2008 with SQL Server 2008?

Hi,

I want to write a VC 2008(MFC) app to create a SQL Server database, then create a data table inside it, and then add some records to the table. I am using SQL Server 2008. I want to know which method is the best? ADO, OLE-DB, ODBC, DAO, or any other methods? Which method is recommended by Microsoft?

Thanks

I tried to use DAO to access SQL Server 2008 but without success.
ADO works good. note that you should use SQLNCLI10 provider, not SQLOLEDB.

And I'm sure OLE-DB and ODBC will work too.

I use ODBC. It works the same as it always has.

you can also use the native driver

http://msdn.microsoft.com/en-us/library/ms131291.aspx

so there are no external dependencies