SQL Server connection string in winform application

Question

I'm going to create a SQL Server database file (.MDF file) in Visual Studio 2012 (C#).

I'm working on a desktop application, I've added a new .MDF file to project, but I don't know what is my connection string, I get this error when I try to connect to my DB:

SqlConnection SQLConnection = new SqlConnection("Data Source=db\\ofoghdb.mdf");
SQLConnection.Open();

Error:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

I'm fairly familiar with SQL Server in web development, but I'm going to use it in a desktop (winform) app and I get above error

There are a few reason for this error. sswug.org/articlesection/default.aspx?TargetID=44331 — Soner Gönül
– Soner Gönül, Commented Apr 24, 2013 at 8:43

Kang · Accepted Answer · 2013-04-24 09:01:01Z

1

maybe your connectionString should like this？

connectionString="Data Source=(LocalDb)\v11.0;Initial Catalog=databaseName;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\my.mdf"

answered Apr 24, 2013 at 9:01

Kang

736 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Andrey Gordeev · Accepted Answer · 2013-04-24 08:47:14Z

1

Try to specify a full path to the database:

SqlConnection SQLConnection = new SqlConnection(@"Data Source=C:\ofoghdb.mdf");
SQLConnection.Open();

See more here

answered Apr 24, 2013 at 8:47

Andrey Gordeev

32.7k16 gold badges143 silver badges169 bronze badges

Comments

AnandPhadke · Accepted Answer · 2013-04-24 08:50:09Z

0

You should be using like this to connect to a database server:

SqlConnection oSQLConn = new SqlConnection();
oSQLConn.ConnectionString = "Data Source=(local);" +
                            "Initial Catalog=mySQLServerDBName;" +
                            "Integrated Security=SSPI";

answered Apr 24, 2013 at 8:50

AnandPhadke

13.5k5 gold badges28 silver badges34 bronze badges

2 Comments

Ali_dotNet Over a year ago

so where is m database file name?

AnandPhadke Over a year ago

in connection string as far as I know,we have to use dbserver name and not .mdf file name or path

Vishal Vaishya · Accepted Answer · 2013-04-24 09:03:03Z

0

Try this connection string.

SqlConnection SQLConnection = new SqlConnection(@"Server=(localdb)\v11.0;Integrated Security=true;AttachDbFileName=DB\MyData.mdf");
SQLConnection.Open();

answered Apr 24, 2013 at 9:03

Vishal Vaishya

6165 silver badges15 bronze badges

Comments

Lorenz Meyer · Accepted Answer · 2015-04-06 12:52:59Z

0

Try this

OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" 
    + Environment.GetFolderPath(Environment.SpecialFolder.Personal) 
    + "\\folder name\\Databass name " + ";Persist Security Info=False;");

edited Apr 6, 2015 at 12:52

Lorenz Meyer

20.1k23 gold badges83 silver badges130 bronze badges

answered Apr 6, 2015 at 12:34

Ahmed Saed

1

Collectives™ on Stack Overflow

SQL Server connection string in winform application

5 Answers 5

Comments

Comments

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related