How to connect to SQL Server data without using SQL Server Management Studio in C# ?

  • Thread starter Thread starter lamtriendong
  • Start date Start date
L

lamtriendong

Guest
ask: 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 ?

Continue reading...
 

Similar threads

B
How To Connect to SQL Server Database From PowerShell
Replies
0
Views
32
Brien Posey
B
B
How To Visualize SQL Server Data in PowerShell (With Sample Script)
Replies
0
Views
37
Brien Posey
B
L
How to connect to SQL Server via proxy ?
Replies
0
Views
186
lamtriendong
L
A
Cant connect to SQL Server instance
Replies
0
Views
147
Alban06
A
L
Is it possible to connect SQL Server via internet without opening port like teamview software ?
Replies
0
Views
140
lamtriendong
L
Back
Top