Dong Lam Trien

Dong Lam Trien

  • 830
  • 986
  • 146.5k

How to connect to SQL Server data without using SQL Server Management

Sep 21 2020 1:35 AM
is it possible to connect SQL Server data according to file connection type, just like in microsoft access data connection
 
public static string sConnectionString = @ "Provider = Microsoft.Jet.OLEDB.4.0; Data Source =" + @ "| DataDirectory | \ data.mdb" + "; Persist Security Info = False; Jet OLEDB: Database Password = 123";
 
How do you convert the above access connection into sql server connection ?

Answers (6)