Re: Unable to Connect To Sql Server 2000 using .NET 2005 EXPRESS
- From: "RobinS" <RobinS@xxxxxxxxxxxxxxx>
- Date: Thu, 26 Apr 2007 20:37:18 -0700
Check www.connectionstrings.com and see if your connection string is valid.
Robin S.
--------------------
"Terrance" <Terrance@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:23B708A9-5C18-4698-8D2D-97961C12050B@xxxxxxxxxxxxxxxx
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
.
- Follow-Ups:
- Prev by Date: DataTableDataView, how do I use dataview to show only 3 fields on the grid
- Next by Date: Re: SQLCommand ParameterDirection.ReturnValue not what it was
- Previous by thread: DataTableDataView, how do I use dataview to show only 3 fields on the grid
- Next by thread: Re: Unable to Connect To Sql Server 2000 using .NET 2005 EXPRESS
- Index(es):
Relevant Pages
|
