Connection string in actual host

Question

0.00/5 (No votes)

See more:

Hi there...
In local hast I have a connection string(web.config) as below

HTML

connectionStrings>
    <add name="bongahConnectionString" connectionString="Data Source=MEHDI-PC;Initial Catalog=bongah;Integrated Security=True"
      providerName="System.Data.SqlClient" />
  </connectionStrings>

and in host there is a connectionstring like this

HTML

data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true

when i try to access to db this error appear

The network path was not found

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ComponentModel.Win32Exception: The network path was not found

Source Error:

C#

Line 78: { Line 79: SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["bongahConnectionString"].ToString()); Line 80: con.Open(); Line 81: string query1 = "SELECT ID FROM aparteman WHERE ID=(SELECT MAX(ID)FROM aparteman)"; Line 82: SqlCommand cmd = new SqlCommand(query1, con);

What can i do?

Posted 2-Jan-14 2:35am

m-e-h-d-h-i

Updated 2-Jan-14 3:27am

v3

Add a Solution

Comments

Arslan Elahi 2-Jan-14 8:59am

@mehdi pour ...it simple you have to change your connection string ... network path errors come usually due to wrong connection string

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

♥…ЯҠ…♥ · Answer 1 · 2014-01-02T03:42:00

Hi Mehdi,

Data Source=MEHDI-PC;Initial Catalog=bongah;Integrated Security=True

1) In the above connection string, try to replace MEHDI-PC to IP Address it will be more easy to understand in Connection string point of view.(optional)
2) I think you have missed the DB instance name in it.

Sample SQL Server Connection string should look like this

XML

connectionString="SERVER=192.168.xx.xx\SQL2008;DataBase=DatabaseName;Initial Catalog=bongah;UID=Username;pwd=****;"

Hope this helps you a bit.

Regards,
RK

allimran96 · Answer 2 · 2014-01-02T03:58:00

Use This Code in Web.config

XML

<connectionstrings>
    <add name="NewConnectionString" connectionstring="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\shoping.mdf;Integrated Security=True;User Instance=True" providername="System.Data.SqlClient" />
</connectionstrings>

Now Use this code in FileName.aspx.CS file

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["NewConnectionString"].ConnectionString);

Connection string in actual host

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0