There are two ways: First is by a standalone driver, or, by ODBC
datasource connection.

For test purpose you can try making an ODBC connection and connecting
through it, however, if your application would execute in remote
locations I prefer using Drivers. You can search for drivers also at
google, where many vendor implementations are available including
Microsoft.