Have you had a look at these pages in the v16 doc? They contain a sample setup for the SA 16 demo database:
They relate to MS SQL 2005/2008 but I guess the setup should work with MS SQL 2012 as well. Note: Though you may use the generic MSDASQL driver it's recommended to use the builtin SAOLEDB driver.
In case your setup does not work yet feel free to tell what connection strings and properties you have used so far...
answered 07 Jul '14, 03:55