Problem with sql connection string syntax

Question

I'm trying to connect to SQL server using SQLCLIENT.

And I think I have a problem with CONNECTION STRING.

The name of the SERVER as it appears: "LAPTOP-LUC355KE \ MSSQLSERVER01"

When I write the name, C# has a problem with the "\", I tried to make "/" but I can't connect to the server and I get an error message that the name may not be correct.

error: The network name cannot be found.

C# code

its c# you need to escape the \, put in 2 of them, or put an @ before the beginning " — BugFinder
– BugFinder, Commented Nov 22, 2019 at 7:38

Vignesh Kumar A · Accepted Answer · 2019-11-22 07:47:34Z

2

Method 1 : Use @ at beginning of string

@"LAPTOP-LUC355KE \ MSSQLSERVER01"

Method 2 : Use the Web.config and its good practice to read the connection string from there

You need to add a reference to System.Configuration and then use:

System.Configuration.ConfigurationManager.
    ConnectionStrings["connectionStringName"].ConnectionString;

answered Nov 22, 2019 at 7:47

Vignesh Kumar A

28.6k14 gold badges67 silver badges119 bronze badges

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

Comments

Tanveer Badar · Accepted Answer · 2019-11-22 07:41:14Z

1

You need to escape the \ character in machine name by doubling it.

This should get you started:

LAPTOP-LUC355KE\\MSSQLSERVER01

P.S.: Unless it is throw-away code you are writing, it is extremely bad practice to hard-code connection strings in the code.

answered Nov 22, 2019 at 7:41

Tanveer Badar

5,5622 gold badges29 silver badges34 bronze badges

Comments

Nits Patel · Accepted Answer · 2019-11-22 07:47:03Z

0

Connection string:

Bellow System.webserver

  </system.webServer>
  <connectionStrings>
    <add name="YourConection_String_Name"
      connectionString="Data Source= Your_Sql_Port_No; Initial Catalog=Your_Data_Base_Name;User ID=your_Sql_ID;Password=Your_Sql_Password;Max Pool Size=10240;Pooling=true;"
      providerName="System.Data.SqlClient"/>
  </connectionStrings>

May It helps..

answered Nov 22, 2019 at 7:47

Nits Patel

3884 silver badges16 bronze badges

Collectives™ on Stack Overflow

Problem with sql connection string syntax

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related