I am getting a Network or instance related error with my ap

Danish Habib

11y1kC#

I have a application in which in app.config i mentioned my connection string such as

connectionString="Data Source=ASPKCO-DANISH\SQLEXPRESS1;Initial Catalog=DMS2008;Integrated Security=True;Connect Timeout=30"

providerName="System.Data.SqlClient" />

and in code i am using this line

public ClsUserLoging IsValidLog(string UserID, string PassWord)

{

try

{

objClsUsers = null;

con = new SqlConnection(DMS_2008_Data.Properties.Settings.Default.DataConnection.ToString());

con.Open();

com = new SqlCommand();

com.Connection = con;

com.CommandType = CommandType.Text;

com.CommandText = "SELECT UserName, IsNever, CreateDate, ValidDays, ExpireDate FROM Users WHERE (UserID = @UserID) AND (UserPassWord = @UserPassWord)";

com.Parameters.Add("@UserID", SqlDbType.NVarChar, 30).Value = UserID.ToString().Trim();

com.Parameters.Add("@UserPassWord", SqlDbType.NVarChar, 60).Value = PassWord.ToString().Trim();

reader = com.ExecuteReader();

while (reader.Read())

{

objClsUsers = new ClsUserLoging();

objClsUsers.UserName = reader.GetString(0).ToString();

objClsUsers.Never = reader.GetBoolean(1);

objClsUsers.CreateDate = reader.GetDateTime(2);

objClsUsers.ValidDays = (short)reader.GetInt32(3);

objClsUsers.ExpireDate = reader.GetDateTime(4);

}

reader.Close();

com.Parameters.Clear();

}

catch (Exception ex)

{

objClsUsers = null;

throw ex;

}

finally

{

if (com != null)

com.Dispose();

if (con != null)

con.Dispose();

com = null;

con = null;

}

return objClsUsers;

}

I am getting an error a network or instance related error occured and there is not issue with DB and connection string because i am using another web application accessing the same db using web.config please assist

12 Replies

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

Danish Habib11y ago
I have to change the settings.settings file also for connection string so i solved it now
+1
Danish Habib11y ago
i am using the same way i just want to ask you i have a project in which in app.config
the connection string is defined as

connectionString="Data Source=ASPKCO-DANISH\SQLEXPRESS1;Initial Catalog=DMS2008;Integrated Security=True;Connect Timeout=300;MultipleActiveResultSets=True"
providerName="System.Data.SqlClient" />

connectionString="Data Source=ASPKCO-DANISH\SQLEXPRESS1;Initial Catalog=DMS2008;Integrated Security=True;Connect Timeout=30"
providerName="System.Data.SqlClient" />

and in code i am accessing the connection string using below code
con = new SqlConnection(ConfigurationManager.ConnectionStrings["DMS_2008_Data.Properties.Settings.Default.DataConnection"].ToString());
con.Open();

IT gives an error saying object reference is not set to an instance of object
0
Ravi Patel11y ago
Hi Danish ,

open project in visual studio go to server explorer (CTRL+ALT+S) click on connect to database , add
connection dialog box will open put server name . then select your database then click on test connection if connection is succeded then click on advanced tab copy the connection string then paste it into your web config file. then try to debug
0
Danish Habib11y ago
when i debug the application
con = new SqlConnection(ConfigurationManager.ConnectionStrings["DMS_2008_Data.Properties.Settings.Default.DataConnection"].ToString());
the con is null
0
Danish Habib11y ago
The Database is in my own machine my own sql server instance
0
Ravi Patel11y ago
Hi Danish ,

sql server database should be in your machine then try connection string like this
change your Data Source= ASPKCO-DANISH\SQLEXPRESS1 to Data Source= .

connectionString="Data Source= . ;Initial Catalog=DMS2008;Integrated Security=True;Connect Timeout=300;MultipleActiveResultSets=True"
providerName="System.Data.SqlClient" />

0
Danish Habib11y ago
RAVi when i used your code it says
Object reference not set to an instance of an object.
0

Ravi Patel11y ago

Hi ,

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DMS_2008_Data.Properties.Settings.Default.DataConnection"].ToString());

Danish Habib11y ago
I do not want to declare every time a con string varible and assign the app.config value to it what wrong with this
in app.config

connectionString="Data Source=ASPKCO-DANISH\SQLEXPRESS1;Initial Catalog=DMS2008;Integrated Security=True;Connect Timeout=300;MultipleActiveResultSets=True"
providerName="System.Data.SqlClient" />

and in code
con = new SqlConnection(DMS_2008_Data.Properties.Settings.Default.DataConnection.ToString());

con.Open();

0

Ravi Patel11y ago

Hi Danish,

pass connection string like this

static string ConStr = "Data Source=ASPKCO-DANISH\SQLEXPRESS1;Initial Catalog=DMS2008;Integrated Security=True;Connect Timeout=30"
SqlConnection con = new SqlConnection(ConStr);

Danish Habib11y ago
Dear i am just checking the user name and password entered from textboxes to the database nothing else
0
Mukesh Kumar11y ago
Hi,

Here you can check that might be you are using heavy data, so increase the timeout of connection and try.

thanks
0