Tuesday, November 4, 2014

How to connect from VS2013 to MS SQL Server 2012

1. Using the management studio to manage the databases






2. Connection from VS 2013









Connection String:

Provider=SQLNCLI11;Data Source=FMI-431-2\SQLEXPRESS;Password=sa;User ID=sa;Initial Catalog=Users


Access connection
            aConnection = 
                new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\fmi\\Source\\Repos\\fmiedd\\111121321321_StudentStoayn\\CRUDDummyAccessConsole2b\\CRUDDummyAccessConsole2b\\data\\Users.accdb");