You do not want to use ODBC unless there is no other choice.

You can use SQL Server Express which is free or the full-blown SQL Server and use ADO with the native client oledb provider to access the data.