unixODBC and Linux (MS-SQL)

Has anyone been able to get unixODBC on linux via C++ to access MS-SQL databases at all, we are trying to do this but have not had much success to date. -Bill