the ‘microsoft.ace.oledb.12.0’ provider is not registered on the local machine

Published on

Situations: When you try connecting Access database in visual studio. importing excel file into SQL Server OS: Windows 2008 R2 Error: The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine. (System.Data) Solution; (If you have Office installed in the system you may not come across this) Install the following from the link given below. (Access Database … Continue reading the ‘microsoft.ace.oledb.12.0’ provider is not registered on the local machine

MS SQL Server 2005, 2008 – How to set unique constraint for a column

Published on

Here is how to set unique constraint for a column in Microsoft SQL Server 2005, 2008 to 2012. Using SQL: See the full syntax here. In SQL Server Management Studio Express: Right-click table, choose Modify or Design(For Later Versions) Right-click field, choose Indexes/Keys… Click Add For Columns, select the field name you want to be unique. For Type, choose Unique Key. Click Close, Save the table.