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");

1 comment:

  1. Informative details of the connecting of MS SQL database management which you have shared within the snaps. Thanks a lot. coimbatore website designing company | online shopping in coimbatore