"Terrance" <Terrance@discussions.microsoft.com> wrote in message
news:23B708A9-5C18-4698-8D2D-97961C12050B@microsoft.com...
> Can anyone help me with an issue. I have a .net app that tries to connect
> to
> my sql server here on my laptop on my company's network. When I have
> someone
> on the network try the app they get the following message in the
> errorlog:
> *Timeout expired. The timeout period elapsed prior to completion of the
> operation or the server is not responding*
>
> I tried connecting through IP and machine name but no success. My Sql
> Server
> agent and Sql Server is running. I can access the data fine locally of
> course. Here is the connection string:
>
> private string connstring = "pwd=<password>;uid=<username>;" +
> "database=projectMgr;server=<machinename>";
>
> Here is what I'm using when the user tries to login:
>
> cmd.CommandType = CommandType.Text;
> cmd.Connection = sconn;
> cmd.CommandText = "SELECT username, upassword, rights FROM
> " +
> "usertable WHERE username = @username AND upassword =
> @upassword";
> cmd.CommandTimeout = 30000;
>
> SqlParameter sparam = new SqlParameter();
> sparam = cmd.Parameters.AddWithValue("@username", user);
> sparam.DbType = DbType.String;
> sparam.Direction = ParameterDirection.Input;
>
> sparam = cmd.Parameters.AddWithValue("@upassword",
> upassword);
> sparam.DbType = DbType.String;
> sparam.Direction = ParameterDirection.Input;
> sconn.Open();
>
> mAdapter.SelectCommand = cmd;
> mAdapter.Fill(myDataTable);
>
> if (myDataTable.Rows.Count > 0)
> {
> mFlag = true;
> appObject.uClass.urights =
> myDataTable.Rows[0]["rights"].ToString();
> }
> else
> {
> mFlag = false;
> }
>
> I using the timeout method but it's not helping.
> --
> TC

"RobinS" wrote:

> Check www.connectionstrings.com and see if your connection string is valid.
>
> Robin S.
> --------------------
> "Terrance" <Terrance@discussions.microsoft.com> wrote in message
> news:23B708A9-5C18-4698-8D2D-97961C12050B@microsoft.com...
> > Can anyone help me with an issue. I have a .net app that tries to connect
> > to
> > my sql server here on my laptop on my company's network. When I have
> > someone
> > on the network try the app they get the following message in the
> > errorlog:
> > *Timeout expired. The timeout period elapsed prior to completion of the
> > operation or the server is not responding*
> >
> > I tried connecting through IP and machine name but no success. My Sql
> > Server
> > agent and Sql Server is running. I can access the data fine locally of
> > course. Here is the connection string:
> >
> > private string connstring = "pwd=<password>;uid=<username>;" +
> > "database=projectMgr;server=<machinename>";
> >
> > Here is what I'm using when the user tries to login:
> >
> > cmd.CommandType = CommandType.Text;
> > cmd.Connection = sconn;
> > cmd.CommandText = "SELECT username, upassword, rights FROM
> > " +
> > "usertable WHERE username = @username AND upassword =
> > @upassword";
> > cmd.CommandTimeout = 30000;
> >
> > SqlParameter sparam = new SqlParameter();
> > sparam = cmd.Parameters.AddWithValue("@username", user);
> > sparam.DbType = DbType.String;
> > sparam.Direction = ParameterDirection.Input;
> >
> > sparam = cmd.Parameters.AddWithValue("@upassword",
> > upassword);
> > sparam.DbType = DbType.String;
> > sparam.Direction = ParameterDirection.Input;
> > sconn.Open();
> >
> > mAdapter.SelectCommand = cmd;
> > mAdapter.Fill(myDataTable);
> >
> > if (myDataTable.Rows.Count > 0)
> > {
> > mFlag = true;
> > appObject.uClass.urights =
> > myDataTable.Rows[0]["rights"].ToString();
> > }
> > else
> > {
> > mFlag = false;
> > }
> >
> > I using the timeout method but it's not helping.
> > --
> > TC
>
>