MFC SQL Database Driver and Read/Write
===

I'm trying to connect to a sql database and write (in this case its just a test and I'm writing out the letter 'a').

My code:

	CDatabase database;
	CString SqlString;
	CString sCatID, sCategory;
	CString sDriver = _T("SQL Sever Driver (*.sql)");
	CString sDsn;
	CString sFile = _T("C:\\database\\form.sql");

	sDsn.Format(_T("ODBC;DRIVER={%s};DSN='';DBQ=%s"), sDriver, sFile);
	TRY
	{
		database.Open(NULL, false, false, sDsn);
		CRecordset recset (&database);

		SqlString = _T("INSERT INTO Form VALUES (\"a\")");
		recset.Open(CRecordset::dynamic, SqlString);
		database.Close();
	}
	CATCH(CDBException, e)
	{
		AfxMessageBox(e->m_strError);
	}
	END_CATCH;


I'm receiving this error: "Data source name not found and no default driver specified".

How do I add a SQL driver into Visual Studios 2010 (I thought it was installed with Visual Studios, but it's not visible as a data source either if I add an MFC database class).

And how can I write to a database,  I thought CRecordset was the correct method, but I can't find any help online with this.

Thanks,