Can someone please help with this?
Unfortunately, that did not work.
"Ignacio Machin ( .NET/ C# MVP )" <ignacio.machin AT dot.state.fl.us>
wrote in message news:uw****************@TK2MSFTNGP11.phx.gbl...
Hi Jeremy,
Please try using 127.0.0.1 instead of (local) in the connection string:
cnTask.ConnectionString="Data Source=127.0.0.1;" +
"Initial Catalog=EmpDB;" +
"User ID=WebClient;" +
"Password=WebClient";
Cheers,
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"Jeremy Ames" <yo******@here.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...
Here is the code. I am using ADO.NET with new connections and
connections strings everytime.
private void BuildEmployeeDetail(int nEmpId)
{
int [] narValues = new int[15] {0,0,0,0,0,0,0,0,0,0,0,0,0,0,0};
string [] sarInitals = new string[15];
LoadInitialLists(narValues, sarInitals);
string sSql = "SELECT T.TaskDesc, C.TaskId, C.Complete, C.Initials " +
"FROM TasksComplete C " +
"JOIN Tasks T ON (C.TaskId = T.TaskId) " +
"WHERE RemovalId = " + nEmpId;
SqlConnection cnEmployee = new SqlConnection();
cnEmployee.ConnectionString="Data Source=(local);" +
"Initial Catalog=EmpDB;" +
"User ID=guest;" +
"Password=";
SqlCommand cmdEmployee = new SqlCommand(sSql, cnEmployee);
cnEmployee.Open();
drEmployee = cmdEmployee.ExecuteReader();
int nCnt = 1;
while(drEmployee.Read())
{
// create a row to add to the existing table
TableRow rowTemplate = new TableRow();
if (nCnt % 2 != 0)
rowTemplate.BackColor = System.Drawing.Color.White;
else
rowTemplate.BackColor = System.Drawing.Color.Silver;
// create cells to add to the previously created row
TableCell cellCol1 = new TableCell();
TableCell cellCol2 = new TableCell();
TableCell cellCol3 = new TableCell();
// enter the description into the first cell
FillFirstCell(rowTemplate, cellCol1, drEmployee.GetString(0), nCnt,
drEmployee.GetBoolean(2));
// enter a hidden task id and check box to the second cell
FillSecondCell(rowTemplate, cellCol2, drEmployee.GetBoolean(2), nCnt,
drEmployee.GetInt32(1));
FillThirdCell(rowTemplate, cellCol3, nCnt, narValues, sarInitals,
drEmployee.GetInt32(3));
// add all of the cells in the row to the table
tblDetail.Rows.Add(rowTemplate);
//dlCopyInitials.Dispose();
rowTemplate.Dispose();
cellCol1.Dispose();
cellCol2.Dispose();
cellCol3.Dispose();
nCnt += 1;
}
drEmployee.Close();
cnEmployee.Close();
cnEmployee.Dispose();
}
private void LoadInitialLists(int [] narVals, string [] sarVals)
{
string sSql = "SELECT I.IsId, I.IsInitials FROM jwames.istable I ORDER
BY 2";
SqlConnection cnEmployee = new SqlConnection();
cnEmployee.ConnectionString="Data Source=(local);" +
"Initial Catalog=EmpDB;" +
"User ID=guest;" +
"Password=";
SqlCommand cmdEmployee = new SqlCommand(sSql, cnEmployee);
cnEmployee.Open();
drEmployee = cmdEmployee.ExecuteReader();
int nCnt = 0;
while(drEmployee.Read())
{
sarVals[nCnt] = drEmployee.GetString(1);
narVals[nCnt++] = drEmployee.GetInt32(0);
}
drEmployee.Close();
cnEmployee.Close();
cnEmployee.Dispose();
}
private void UpdateTask(int nEmpId, int nTaskId, bool bChecked, int
nInitials)
{
SqlConnection cnTask = new SqlConnection();
cnTask.ConnectionString="Data Source=(local);" +
"Initial Catalog=EmpDB;" +
"User ID=WebClient;" +
"Password=WebClient";
SqlCommand cmdUpdateTask = new SqlCommand("usp_UpdateTaskCompletion",
cnTask);
cmdUpdateTask.CommandType = CommandType.StoredProcedure;
SqlParameter parTask = cmdUpdateTask.Parameters.Add("@p_TaskId",
SqlDbType.Int);
parTask.Value = nTaskId;
parTask = cmdUpdateTask.Parameters.Add("@p_RemovalId", SqlDbType.Int);
parTask.Value = nEmpId;
parTask = cmdUpdateTask.Parameters.Add("@p_Initials", SqlDbType.Int);
parTask.Value = nInitials;
parTask = cmdUpdateTask.Parameters.Add("@p_Complete", SqlDbType.Bit);
parTask.Value = bChecked;
cnTask.Open();
cmdUpdateTask.ExecuteNonQuery();
cnTask.Close();
cmdUpdateTask.Dispose();
cnTask.Dispose();
}
"Ignacio Machin ( .NET/ C# MVP )" <ignacio.machin AT dot.state.fl.us>
wrote in message news:OV**************@TK2MSFTNGP11.phx.gbl...
Hi Jeremy,
A piece of code will be nice, also, are you using ADO or ADO.NET ?
IF not these are a few hints,
1- See if you are really using the third connectionstring
2- Try to not reuse any of the previous used object, create new
Connection,
Command objects
Other than that I cannot think of a possible cause of this problem.
Cheers,
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"Jeremy Ames" <yo******@here.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl... I have a problem with one of connections using the wrong connection
string. I have a form that has three late bound sql connections. Each
connection
is local to the function that it used in. The problem I am having is that
the last connection uses a different username and password to sign in. By
the time that the third connection is opened, the other two connections
have been opened, closed, and disposed. What is happening is that the third
connection is still using the connection string from the other
connections and connecting with the wrong user credentials. This particular
connection executes an update command kept in a stored procedure. I do not allow
that particular user, the guest account, access to anything that changes
data. What could possibly be happening? I do not want to change my security
levels to allow this. Please help!
3  1332 
HI Jeremy,
I haven't forget about this :)
Two more suggestions:
1- Place a breakpoint after you assign you open your connection and see what
is the connection string, if it's the correct one then the problem may lay
in the SQL server configuration as described on suggestion 2.
I don't see any problem in your code, so now I'm thinking in the SQL server
configuration. Go to the enterprise manager/Security and make sure that
WebClient is using "SQL Server Authentication" and not "Windows
Authentication" then go to "Database Access" tab and see if the User in your
DB (empDB) is the correct one"
Cheers,
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"Jeremy Ames" <yo******@here.com> wrote in message
news:et**************@TK2MSFTNGP10.phx.gbl... Can someone please help with this?
Unfortunately, that did not work.
"Ignacio Machin ( .NET/ C# MVP )" <ignacio.machin AT dot.state.fl.us>
wrote in message news:uw****************@TK2MSFTNGP11.phx.gbl...
Hi Jeremy,
Please try using 127.0.0.1 instead of (local) in the connection string:
cnTask.ConnectionString="Data Source=127.0.0.1;" +
"Initial Catalog=EmpDB;" +
"User ID=WebClient;" +
"Password=WebClient";
Cheers,
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"Jeremy Ames" <yo******@here.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...
Here is the code. I am using ADO.NET with new connections and
connections strings everytime.
private void BuildEmployeeDetail(int nEmpId)
{
int [] narValues = new int[15] {0,0,0,0,0,0,0,0,0,0,0,0,0,0,0};
string [] sarInitals = new string[15];
LoadInitialLists(narValues, sarInitals);
string sSql = "SELECT T.TaskDesc, C.TaskId, C.Complete, C.Initials " +
"FROM TasksComplete C " +
"JOIN Tasks T ON (C.TaskId = T.TaskId) " +
"WHERE RemovalId = " + nEmpId;
SqlConnection cnEmployee = new SqlConnection();
cnEmployee.ConnectionString="Data Source=(local);" +
"Initial Catalog=EmpDB;" +
"User ID=guest;" +
"Password=";
SqlCommand cmdEmployee = new SqlCommand(sSql, cnEmployee);
cnEmployee.Open();
drEmployee = cmdEmployee.ExecuteReader();
int nCnt = 1;
while(drEmployee.Read())
{
// create a row to add to the existing table
TableRow rowTemplate = new TableRow();
if (nCnt % 2 != 0)
rowTemplate.BackColor = System.Drawing.Color.White;
else
rowTemplate.BackColor = System.Drawing.Color.Silver;
// create cells to add to the previously created row
TableCell cellCol1 = new TableCell();
TableCell cellCol2 = new TableCell();
TableCell cellCol3 = new TableCell();
// enter the description into the first cell
FillFirstCell(rowTemplate, cellCol1, drEmployee.GetString(0), nCnt,
drEmployee.GetBoolean(2));
// enter a hidden task id and check box to the second cell
FillSecondCell(rowTemplate, cellCol2, drEmployee.GetBoolean(2), nCnt,
drEmployee.GetInt32(1));
FillThirdCell(rowTemplate, cellCol3, nCnt, narValues, sarInitals,
drEmployee.GetInt32(3));
// add all of the cells in the row to the table
tblDetail.Rows.Add(rowTemplate);
//dlCopyInitials.Dispose();
rowTemplate.Dispose();
cellCol1.Dispose();
cellCol2.Dispose();
cellCol3.Dispose();
nCnt += 1;
}
drEmployee.Close();
cnEmployee.Close();
cnEmployee.Dispose();
}
private void LoadInitialLists(int [] narVals, string [] sarVals)
{
string sSql = "SELECT I.IsId, I.IsInitials FROM jwames.istable I ORDER
BY 2";
SqlConnection cnEmployee = new SqlConnection();
cnEmployee.ConnectionString="Data Source=(local);" +
"Initial Catalog=EmpDB;" +
"User ID=guest;" +
"Password=";
SqlCommand cmdEmployee = new SqlCommand(sSql, cnEmployee);
cnEmployee.Open();
drEmployee = cmdEmployee.ExecuteReader();
int nCnt = 0;
while(drEmployee.Read())
{
sarVals[nCnt] = drEmployee.GetString(1);
narVals[nCnt++] = drEmployee.GetInt32(0);
}
drEmployee.Close();
cnEmployee.Close();
cnEmployee.Dispose();
}
private void UpdateTask(int nEmpId, int nTaskId, bool bChecked, int
nInitials)
{
SqlConnection cnTask = new SqlConnection();
cnTask.ConnectionString="Data Source=(local);" +
"Initial Catalog=EmpDB;" +
"User ID=WebClient;" +
"Password=WebClient";
SqlCommand cmdUpdateTask = new SqlCommand("usp_UpdateTaskCompletion",
cnTask);
cmdUpdateTask.CommandType = CommandType.StoredProcedure;
SqlParameter parTask = cmdUpdateTask.Parameters.Add("@p_TaskId",
SqlDbType.Int);
parTask.Value = nTaskId;
parTask = cmdUpdateTask.Parameters.Add("@p_RemovalId", SqlDbType.Int);
parTask.Value = nEmpId;
parTask = cmdUpdateTask.Parameters.Add("@p_Initials", SqlDbType.Int);
parTask.Value = nInitials;
parTask = cmdUpdateTask.Parameters.Add("@p_Complete", SqlDbType.Bit);
parTask.Value = bChecked;
cnTask.Open();
cmdUpdateTask.ExecuteNonQuery();
cnTask.Close();
cmdUpdateTask.Dispose();
cnTask.Dispose();
}
"Ignacio Machin ( .NET/ C# MVP )" <ignacio.machin AT dot.state.fl.us>
wrote in message news:OV**************@TK2MSFTNGP11.phx.gbl...
Hi Jeremy,
A piece of code will be nice, also, are you using ADO or ADO.NET ?
IF not these are a few hints,
1- See if you are really using the third connectionstring
2- Try to not reuse any of the previous used object, create new
Connection,
Command objects
Other than that I cannot think of a possible cause of this problem.
Cheers,
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"Jeremy Ames" <yo******@here.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl... > I have a problem with one of connections using the wrong connection string. > I have a form that has three late bound sql connections. Each
connection
is > local to the function that it used in. The problem I am having is
that the > last connection uses a different username and password to sign in.
By the > time that the third connection is opened, the other two connections have > been opened, closed, and disposed. What is happening is that the
third > connection is still using the connection string from the other
connections > and connecting with the wrong user credentials. This particular
connection > executes an update command kept in a stored procedure. I do not
allow that > particular user, the guest account, access to anything that changes data. > What could possibly be happening? I do not want to change my
security levels > to allow this. Please help!
>
>
1- The information is coming back correct in the debug window for the
connection string.
2- The user is using sql authentication and it is setup with access to the
databases.
"Ignacio Machin ( .NET/ C# MVP )" <ignacio.machin AT dot.state.fl.us> wrote
in message news:%2******************@TK2MSFTNGP12.phx.gbl...
HI Jeremy,
I haven't forget about this :)
Two more suggestions:
1- Place a breakpoint after you assign you open your connection and see what
is the connection string, if it's the correct one then the problem may lay
in the SQL server configuration as described on suggestion 2.
I don't see any problem in your code, so now I'm thinking in the SQL server
configuration. Go to the enterprise manager/Security and make sure that
WebClient is using "SQL Server Authentication" and not "Windows
Authentication" then go to "Database Access" tab and see if the User in your
DB (empDB) is the correct one"
Cheers,
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"Jeremy Ames" <yo******@here.com> wrote in message
news:et**************@TK2MSFTNGP10.phx.gbl... Can someone please help with this?
Unfortunately, that did not work.
"Ignacio Machin ( .NET/ C# MVP )" <ignacio.machin AT dot.state.fl.us>
wrote in message news:uw****************@TK2MSFTNGP11.phx.gbl...
Hi Jeremy,
Please try using 127.0.0.1 instead of (local) in the connection string:
cnTask.ConnectionString="Data Source=127.0.0.1;" +
"Initial Catalog=EmpDB;" +
"User ID=WebClient;" +
"Password=WebClient";
Cheers,
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"Jeremy Ames" <yo******@here.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...
Here is the code. I am using ADO.NET with new connections and
connections strings everytime.
private void BuildEmployeeDetail(int nEmpId)
{
int [] narValues = new int[15] {0,0,0,0,0,0,0,0,0,0,0,0,0,0,0};
string [] sarInitals = new string[15];
LoadInitialLists(narValues, sarInitals);
string sSql = "SELECT T.TaskDesc, C.TaskId, C.Complete, C.Initials " +
"FROM TasksComplete C " +
"JOIN Tasks T ON (C.TaskId = T.TaskId) " +
"WHERE RemovalId = " + nEmpId;
SqlConnection cnEmployee = new SqlConnection();
cnEmployee.ConnectionString="Data Source=(local);" +
"Initial Catalog=EmpDB;" +
"User ID=guest;" +
"Password=";
SqlCommand cmdEmployee = new SqlCommand(sSql, cnEmployee);
cnEmployee.Open();
drEmployee = cmdEmployee.ExecuteReader();
int nCnt = 1;
while(drEmployee.Read())
{
// create a row to add to the existing table
TableRow rowTemplate = new TableRow();
if (nCnt % 2 != 0)
rowTemplate.BackColor = System.Drawing.Color.White;
else
rowTemplate.BackColor = System.Drawing.Color.Silver;
// create cells to add to the previously created row
TableCell cellCol1 = new TableCell();
TableCell cellCol2 = new TableCell();
TableCell cellCol3 = new TableCell();
// enter the description into the first cell
FillFirstCell(rowTemplate, cellCol1, drEmployee.GetString(0), nCnt,
drEmployee.GetBoolean(2));
// enter a hidden task id and check box to the second cell
FillSecondCell(rowTemplate, cellCol2, drEmployee.GetBoolean(2), nCnt,
drEmployee.GetInt32(1));
FillThirdCell(rowTemplate, cellCol3, nCnt, narValues, sarInitals,
drEmployee.GetInt32(3));
// add all of the cells in the row to the table
tblDetail.Rows.Add(rowTemplate);
//dlCopyInitials.Dispose();
rowTemplate.Dispose();
cellCol1.Dispose();
cellCol2.Dispose();
cellCol3.Dispose();
nCnt += 1;
}
drEmployee.Close();
cnEmployee.Close();
cnEmployee.Dispose();
}
private void LoadInitialLists(int [] narVals, string [] sarVals)
{
string sSql = "SELECT I.IsId, I.IsInitials FROM jwames.istable I ORDER
BY 2";
SqlConnection cnEmployee = new SqlConnection();
cnEmployee.ConnectionString="Data Source=(local);" +
"Initial Catalog=EmpDB;" +
"User ID=guest;" +
"Password=";
SqlCommand cmdEmployee = new SqlCommand(sSql, cnEmployee);
cnEmployee.Open();
drEmployee = cmdEmployee.ExecuteReader();
int nCnt = 0;
while(drEmployee.Read())
{
sarVals[nCnt] = drEmployee.GetString(1);
narVals[nCnt++] = drEmployee.GetInt32(0);
}
drEmployee.Close();
cnEmployee.Close();
cnEmployee.Dispose();
}
private void UpdateTask(int nEmpId, int nTaskId, bool bChecked, int
nInitials)
{
SqlConnection cnTask = new SqlConnection();
cnTask.ConnectionString="Data Source=(local);" +
"Initial Catalog=EmpDB;" +
"User ID=WebClient;" +
"Password=WebClient";
SqlCommand cmdUpdateTask = new SqlCommand("usp_UpdateTaskCompletion",
cnTask);
cmdUpdateTask.CommandType = CommandType.StoredProcedure;
SqlParameter parTask = cmdUpdateTask.Parameters.Add("@p_TaskId",
SqlDbType.Int);
parTask.Value = nTaskId;
parTask = cmdUpdateTask.Parameters.Add("@p_RemovalId", SqlDbType.Int);
parTask.Value = nEmpId;
parTask = cmdUpdateTask.Parameters.Add("@p_Initials", SqlDbType.Int);
parTask.Value = nInitials;
parTask = cmdUpdateTask.Parameters.Add("@p_Complete", SqlDbType.Bit);
parTask.Value = bChecked;
cnTask.Open();
cmdUpdateTask.ExecuteNonQuery();
cnTask.Close();
cmdUpdateTask.Dispose();
cnTask.Dispose();
}
"Ignacio Machin ( .NET/ C# MVP )" <ignacio.machin AT dot.state.fl.us>
wrote in message news:OV**************@TK2MSFTNGP11.phx.gbl...
Hi Jeremy,
A piece of code will be nice, also, are you using ADO or ADO.NET ?
IF not these are a few hints,
1- See if you are really using the third connectionstring
2- Try to not reuse any of the previous used object, create new
Connection,
Command objects
Other than that I cannot think of a possible cause of this problem.
Cheers,
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"Jeremy Ames" <yo******@here.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl... > I have a problem with one of connections using the wrong connection string. > I have a form that has three late bound sql connections. Each
connection
is > local to the function that it used in. The problem I am having is
that the > last connection uses a different username and password to sign in.
By the > time that the third connection is opened, the other two connections have > been opened, closed, and disposed. What is happening is that the
third > connection is still using the connection string from the other
connections > and connecting with the wrong user credentials. This particular
connection > executes an update command kept in a stored procedure. I do not
allow that > particular user, the guest account, access to anything that changes data. > What could possibly be happening? I do not want to change my
security levels > to allow this. Please help!
>
>
What happens if you try "host=127.0.0.1; database=EmpDB;
user=WebClient; password=WebClient"?
I really wish the connection string didn't allow so many
syntaxes...
JER -----Original Message-----
Can someone please help with this?
Unfortunately, that did not work.
"Ignacio Machin ( .NET/ C# MVP )" <ignacio.machin AT
dot.state.fl.us>wrote in message news:uwMY%
23***********@TK2MSFTNGP11.phx.gbl... Hi Jeremy,
Please try using 127.0.0.1 instead of (local) in the
connection string:
cnTask.ConnectionString="Data Source=127.0.0.1;" +
"Initial Catalog=EmpDB;" +
"User ID=WebClient;" +
"Password=WebClient";
Cheers,
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"Jeremy Ames" <yo******@here.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...
Here is the code. I am using ADO.NET with new
connections andconnections strings everytime.
private void BuildEmployeeDetail(int nEmpId)
{
int [] narValues = new int[15]
{0,0,0,0,0,0,0,0,0,0,0,0,0,0,0};
string [] sarInitals = new string[15];
LoadInitialLists(narValues, sarInitals);
string sSql = "SELECT T.TaskDesc, C.TaskId,
C.Complete, C.Initials " +
"FROM TasksComplete C " +
"JOIN Tasks T ON (C.TaskId = T.TaskId) " +
"WHERE RemovalId = " + nEmpId;
SqlConnection cnEmployee = new SqlConnection();
cnEmployee.ConnectionString="Data Source=(local);" +
"Initial Catalog=EmpDB;" +
"User ID=guest;" +
"Password=";
SqlCommand cmdEmployee = new SqlCommand(sSql,
cnEmployee);
cnEmployee.Open();
drEmployee = cmdEmployee.ExecuteReader();
int nCnt = 1;
while(drEmployee.Read())
{
// create a row to add to the existing table
TableRow rowTemplate = new TableRow();
if (nCnt % 2 != 0)
rowTemplate.BackColor = System.Drawing.Color.White;
else
rowTemplate.BackColor = System.Drawing.Color.Silver;
// create cells to add to the previously created row
TableCell cellCol1 = new TableCell();
TableCell cellCol2 = new TableCell();
TableCell cellCol3 = new TableCell();
// enter the description into the first cell
FillFirstCell(rowTemplate, cellCol1,
drEmployee.GetString(0), nCnt,drEmployee.GetBoolean(2));
// enter a hidden task id and check box to the
second cell
FillSecondCell(rowTemplate, cellCol2,
drEmployee.GetBoolean(2), nCnt,drEmployee.GetInt32(1));
FillThirdCell(rowTemplate, cellCol3, nCnt,
narValues, sarInitals,drEmployee.GetInt32(3));
// add all of the cells in the row to the table
tblDetail.Rows.Add(rowTemplate);
//dlCopyInitials.Dispose();
rowTemplate.Dispose();
cellCol1.Dispose();
cellCol2.Dispose();
cellCol3.Dispose();
nCnt += 1;
}
drEmployee.Close();
cnEmployee.Close();
cnEmployee.Dispose();
}
private void LoadInitialLists(int [] narVals, string
[] sarVals)
{
string sSql = "SELECT I.IsId, I.IsInitials FROM
jwames.istable I ORDERBY 2";
SqlConnection cnEmployee = new SqlConnection();
cnEmployee.ConnectionString="Data Source=(local);" +
"Initial Catalog=EmpDB;" +
"User ID=guest;" +
"Password=";
SqlCommand cmdEmployee = new SqlCommand(sSql,
cnEmployee);
cnEmployee.Open();
drEmployee = cmdEmployee.ExecuteReader();
int nCnt = 0;
while(drEmployee.Read())
{
sarVals[nCnt] = drEmployee.GetString(1);
narVals[nCnt++] = drEmployee.GetInt32(0);
}
drEmployee.Close();
cnEmployee.Close();
cnEmployee.Dispose();
}
private void UpdateTask(int nEmpId, int nTaskId,
bool bChecked, intnInitials)
{
SqlConnection cnTask = new SqlConnection();
cnTask.ConnectionString="Data Source=(local);" +
"Initial Catalog=EmpDB;" +
"User ID=WebClient;" +
"Password=WebClient";
SqlCommand cmdUpdateTask = new SqlCommand
("usp_UpdateTaskCompletion",cnTask);
cmdUpdateTask.CommandType =
CommandType.StoredProcedure;
SqlParameter parTask = cmdUpdateTask.Parameters.Add
("@p_TaskId",SqlDbType.Int);
parTask.Value = nTaskId;
parTask = cmdUpdateTask.Parameters.Add
("@p_RemovalId", SqlDbType.Int);
parTask.Value = nEmpId;
parTask = cmdUpdateTask.Parameters.Add
("@p_Initials", SqlDbType.Int);
parTask.Value = nInitials;
parTask = cmdUpdateTask.Parameters.Add
("@p_Complete", SqlDbType.Bit);
parTask.Value = bChecked;
cnTask.Open();
cmdUpdateTask.ExecuteNonQuery();
cnTask.Close();
cmdUpdateTask.Dispose();
cnTask.Dispose();
}
"Ignacio Machin ( .NET/ C# MVP )" <ignacio.machin AT
dot.state.fl.us>wrote in message
news:OV**************@TK2MSFTNGP11.phx.gbl... Hi Jeremy,
A piece of code will be nice, also, are you using
ADO or ADO.NET ? IF not these are a few hints,
1- See if you are really using the third
connectionstring 2- Try to not reuse any of the previous used object,
create newConnection,
Command objects
Other than that I cannot think of a possible cause
of this problem.
Cheers,
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"Jeremy Ames" <yo******@here.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl... > I have a problem with one of connections using the
wrong connection string. > I have a form that has three late bound sql
connections. Eachconnection
is > local to the function that it used in. The problem
I am having is thatthe > last connection uses a different username and
password to sign in. Bythe > time that the third connection is opened, the
other two connectionshave > been opened, closed, and disposed. What is
happening is that the third > connection is still using the connection string
from the otherconnections > and connecting with the wrong user credentials.
This particularconnection > executes an update command kept in a stored
procedure. I do not allowthat > particular user, the guest account, access to
anything that changesdata. > What could possibly be happening? I do not want to
change my security levels > to allow this. Please help!
>
>
. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: YesBalala |
last post by:
I am using CGI.pm, and getting the parameters similiar to the
followings,
use CGI::Carp qw(fatalsToBrowser);
use CGI qw(:all);
:
my $task = param('task');
my $username= param('username');
...
|
by: Jeremy Ames |
last post by:
I have a problem with one of connections using the wrong connection string.
I have a form that has three late bound sql connections. Each connection is
local to the function that it used in. The...
|
by: Colin McGuire |
last post by:
Hi - this was posted last weekend and unfortunately not resolved. The
solutions that were posted almost worked but after another 5 days of
working on the code everynight, I am not further ahead....
|
by: Peter Proost |
last post by:
Hi Group,
I've got an interesting problem, I don't know if this is the right group but
I think so because everything I've read about it so far says it's a .net
problem. Here's the problem, we're...
|
by: Arno R |
last post by:
Hi all,
I am about to distribute an A97-runtime app. which will be used on a LAN by approx. 30 users.
The network is pretty good, but there are a few managers who have wireless laptops...
Of...
|
by: Elliot Rodriguez |
last post by:
I have a form that contains a mix of dynamic controls and declared controls.
All of them are intrinsic .NET controls. Several functions within the page
use Request.Form to query the value of the...
|
by: Schmidty |
last post by:
If you do a page reload with $_SERVER will your program
lose a mysqli connection upon the reload of the page? Would this code
work? I need to know how to carry over a connection between methods as...
|
by: Usman Jamil |
last post by:
Hi
I've a class that creates a connection to a database, gets and loop on a
dataset given a query and then close the connection. When I use netstat
viewer to see if there is any connection open...
|
by: Greg |
last post by:
I'm creating a tcp socket connection from the thread in the c#
threadpool. Since the default workers thread is 500, sometimes my
program tries to open up 500 different tcp socket connections and...
|
by: Kemmylinns12 |
last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...
|
by: Naresh1 |
last post by:
What is WebLogic Admin Training?
WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge required to effectively administer and manage Oracle...
|
by: antdb |
last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine
In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...
|
by: Matthew3360 |
last post by:
Hi,
I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web server and have made sure to enable curl. I get a...
|
by: Oralloy |
last post by:
Hello Folks,
I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA.
My problem (spelled failure) is with the synthesis of my design into a bitstream, not the C++...
|
by: BLUEPANDA |
last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS starter kit that's not only easy to use but also...
|
by: Rahul1995seven |
last post by:
Introduction:
In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...
|
by: ezappsrUS |
last post by:
Hi,
I wonder if someone knows where I am going wrong below. I have a continuous form and two labels where only one would be visible depending on the checkbox being checked or not. Below is the...
|
by: DizelArs |
last post by:
Hi all)
Faced with a problem, element.click() event doesn't work in Safari browser.
Tried various tricks like emulating touch event through a function:
let clickEvent = new Event('click', {...
| |
