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

Dong Lam Trien

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 ?

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dong Lam Trien6y ago
Thank you for reading my article but you misunderstand me, I have read through your links to me but there is no article I am looking for. I will describe the connection I am looking for.
Suppose I have a SQL Server data file: data.mdf and this file is saved in the path "D: \ DataBase \ data.mdf" in C # I have to declare to join as:
[CODE]
public static string sConnectionString = @ "??? = ???; ??? =" + @ "D:\DataBase\data.mdf" + "; ??? = ???; ???: Database Password = ";
[/CODE]
Sachin Singh6y ago
There is no way to read a mdf file that is the file created by sql server without going through the sql server engine.
However there are many third party tools like OrcaMDF.A C# parser for MDF files. Allows you to read tables, metadata andindexes from MDF files without it being attached to a running SQLServer instance.
You can convert your mdf file to mdb file , using export import option of sql server , or you can use online conversion tool, after that you already know how to read an access file.
hope this answers your question.
Dong Lam Trien6y ago
I have read the link you sent me, I look for a database connection like the file connection example above, which means I have a SQL Server data file called Data.mdf, I know the file path. , I will connect via the path of the Data.mdf file, please pay attention to connect via the filename path I do not use SQL Server Management Studio, SQL Express, SQL Standard Edition, ... do you understand my question ?
Nisha Regil6y ago
Please refer to link http://csharp.net-informations.com/data-providers/csharp-sql-server-connection.htm
Hope that may help.

Alternatively The below can be added as Connection Strings In Web. config File Using ASP.NET
jahid hussain6y ago
I think best answer of your questions.

follow this link and found your answer : https://csharpanyanswerfound.blogspot.com/
jahid hussain6y ago
Yes