ADO connections on a web form (repost)

[Jeremy Ames]

Can someone please help with this?

Unfortunately, that did not work.
"Ignacio Machin ( .NET/ C# MVP )" <ignacio.mach in AT dot.state.fl.us >
wrote in message news:uw******** ********@TK2MSF TNGP11.phx.gbl. ..
Hi Jeremy,

Please try using 127.0.0.1 instead of (local) in the connection string:

cnTask.Connecti onString="Data Source=127.0.0. 1;" +

"Initial Catalog=EmpDB;" +

"User ID=WebClient;" +

"Password=WebCl ient";
Cheers,
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Jeremy Ames" <yo******@here. com> wrote in message
news:%2******** ********@TK2MSF TNGP10.phx.gbl. ..
Here is the code. I am using ADO.NET with new connections and
connections strings everytime.

private void BuildEmployeeDe tail(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];

LoadInitialList s(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.Conn ectionString="D ata Source=(local); " +

"Initial Catalog=EmpDB;" +

"User ID=guest;" +

"Password=" ;

SqlCommand cmdEmployee = new SqlCommand(sSql , cnEmployee);

cnEmployee.Open ();

drEmployee = cmdEmployee.Exe cuteReader();
int nCnt = 1;
while(drEmploye e.Read())

{

// create a row to add to the existing table

TableRow rowTemplate = new TableRow();

if (nCnt % 2 != 0)

rowTemplate.Bac kColor = System.Drawing. Color.White;

else

rowTemplate.Bac kColor = 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(r owTemplate, cellCol1, drEmployee.GetS tring(0), nCnt,
drEmployee.GetB oolean(2));
// enter a hidden task id and check box to the second cell

FillSecondCell( rowTemplate, cellCol2, drEmployee.GetB oolean(2), nCnt,
drEmployee.GetI nt32(1));
FillThirdCell(r owTemplate, cellCol3, nCnt, narValues, sarInitals,
drEmployee.GetI nt32(3));

// add all of the cells in the row to the table
tblDetail.Rows. Add(rowTemplate );
//dlCopyInitials. Dispose();

rowTemplate.Dis pose();

cellCol1.Dispos e();

cellCol2.Dispos e();

cellCol3.Dispos e();

nCnt += 1;

}

drEmployee.Clos e();

cnEmployee.Clos e();

cnEmployee.Disp ose();

}

private void LoadInitialList s(int [] narVals, string [] sarVals)

{

string sSql = "SELECT I.IsId, I.IsInitials FROM jwames.istable I ORDER
BY 2";

SqlConnection cnEmployee = new SqlConnection() ;

cnEmployee.Conn ectionString="D ata Source=(local); " +

"Initial Catalog=EmpDB;" +

"User ID=guest;" +

"Password=" ;

SqlCommand cmdEmployee = new SqlCommand(sSql , cnEmployee);

cnEmployee.Open ();

drEmployee = cmdEmployee.Exe cuteReader();

int nCnt = 0;

while(drEmploye e.Read())

{

sarVals[nCnt] = drEmployee.GetS tring(1);

narVals[nCnt++] = drEmployee.GetI nt32(0);

}

drEmployee.Clos e();

cnEmployee.Clos e();

cnEmployee.Disp ose();

}

private void UpdateTask(int nEmpId, int nTaskId, bool bChecked, int
nInitials)

{

SqlConnection cnTask = new SqlConnection() ;

cnTask.Connecti onString="Data Source=(local); " +

"Initial Catalog=EmpDB;" +

"User ID=WebClient;" +

"Password=WebCl ient";
SqlCommand cmdUpdateTask = new SqlCommand("usp _UpdateTaskComp letion",
cnTask);

cmdUpdateTask.C ommandType = CommandType.Sto redProcedure;
SqlParameter parTask = cmdUpdateTask.P arameters.Add(" @p_TaskId",
SqlDbType.Int);

parTask.Value = nTaskId;

parTask = cmdUpdateTask.P arameters.Add(" @p_RemovalId", SqlDbType.Int);

parTask.Value = nEmpId;

parTask = cmdUpdateTask.P arameters.Add(" @p_Initials", SqlDbType.Int);

parTask.Value = nInitials;

parTask = cmdUpdateTask.P arameters.Add(" @p_Complete", SqlDbType.Bit);

parTask.Value = bChecked;

cnTask.Open();

cmdUpdateTask.E xecuteNonQuery( );

cnTask.Close();

cmdUpdateTask.D ispose();

cnTask.Dispose( );

}

"Ignacio Machin ( .NET/ C# MVP )" <ignacio.mach in AT dot.state.fl.us >
wrote in message news:OV******** ******@TK2MSFTN GP11.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 connectionstrin g
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******** ********@TK2MSF TNGP10.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!

[Ignacio Machin \( .NET/ C# MVP \)]

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******** ******@TK2MSFTN GP10.phx.gbl...

Can someone please help with this?

Unfortunately, that did not work.
"Ignacio Machin ( .NET/ C# MVP )" <ignacio.mach in AT dot.state.fl.us >
wrote in message news:uw******** ********@TK2MSF TNGP11.phx.gbl. ..
Hi Jeremy,

Please try using 127.0.0.1 instead of (local) in the connection string:

cnTask.Connecti onString="Data Source=127.0.0. 1;" +

"Initial Catalog=EmpDB;" +

"User ID=WebClient;" +

"Password=WebCl ient";
Cheers,
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Jeremy Ames" <yo******@here. com> wrote in message
news:%2******** ********@TK2MSF TNGP10.phx.gbl. ..
Here is the code. I am using ADO.NET with new connections and
connections strings everytime.

private void BuildEmployeeDe tail(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];

LoadInitialList s(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.Conn ectionString="D ata Source=(local); " +

"Initial Catalog=EmpDB;" +

"User ID=guest;" +

"Password=" ;

SqlCommand cmdEmployee = new SqlCommand(sSql , cnEmployee);

cnEmployee.Open ();

drEmployee = cmdEmployee.Exe cuteReader();
int nCnt = 1;
while(drEmploye e.Read())

{

// create a row to add to the existing table

TableRow rowTemplate = new TableRow();

if (nCnt % 2 != 0)

rowTemplate.Bac kColor = System.Drawing. Color.White;

else

rowTemplate.Bac kColor = 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(r owTemplate, cellCol1, drEmployee.GetS tring(0), nCnt,
drEmployee.GetB oolean(2));
// enter a hidden task id and check box to the second cell

FillSecondCell( rowTemplate, cellCol2, drEmployee.GetB oolean(2), nCnt,
drEmployee.GetI nt32(1));
FillThirdCell(r owTemplate, cellCol3, nCnt, narValues, sarInitals,
drEmployee.GetI nt32(3));

// add all of the cells in the row to the table
tblDetail.Rows. Add(rowTemplate );
//dlCopyInitials. Dispose();

rowTemplate.Dis pose();

cellCol1.Dispos e();

cellCol2.Dispos e();

cellCol3.Dispos e();

nCnt += 1;

}

drEmployee.Clos e();

cnEmployee.Clos e();

cnEmployee.Disp ose();

}

private void LoadInitialList s(int [] narVals, string [] sarVals)

{

string sSql = "SELECT I.IsId, I.IsInitials FROM jwames.istable I ORDER
BY 2";

SqlConnection cnEmployee = new SqlConnection() ;

cnEmployee.Conn ectionString="D ata Source=(local); " +

"Initial Catalog=EmpDB;" +

"User ID=guest;" +

"Password=" ;

SqlCommand cmdEmployee = new SqlCommand(sSql , cnEmployee);

cnEmployee.Open ();

drEmployee = cmdEmployee.Exe cuteReader();

int nCnt = 0;

while(drEmploye e.Read())

{

sarVals[nCnt] = drEmployee.GetS tring(1);

narVals[nCnt++] = drEmployee.GetI nt32(0);

}

drEmployee.Clos e();

cnEmployee.Clos e();

cnEmployee.Disp ose();

}

private void UpdateTask(int nEmpId, int nTaskId, bool bChecked, int
nInitials)

{

SqlConnection cnTask = new SqlConnection() ;

cnTask.Connecti onString="Data Source=(local); " +

"Initial Catalog=EmpDB;" +

"User ID=WebClient;" +

"Password=WebCl ient";
SqlCommand cmdUpdateTask = new SqlCommand("usp _UpdateTaskComp letion",
cnTask);

cmdUpdateTask.C ommandType = CommandType.Sto redProcedure;
SqlParameter parTask = cmdUpdateTask.P arameters.Add(" @p_TaskId",
SqlDbType.Int);

parTask.Value = nTaskId;

parTask = cmdUpdateTask.P arameters.Add(" @p_RemovalId", SqlDbType.Int);

parTask.Value = nEmpId;

parTask = cmdUpdateTask.P arameters.Add(" @p_Initials", SqlDbType.Int);

parTask.Value = nInitials;

parTask = cmdUpdateTask.P arameters.Add(" @p_Complete", SqlDbType.Bit);

parTask.Value = bChecked;

cnTask.Open();

cmdUpdateTask.E xecuteNonQuery( );

cnTask.Close();

cmdUpdateTask.D ispose();

cnTask.Dispose( );

}

"Ignacio Machin ( .NET/ C# MVP )" <ignacio.mach in AT dot.state.fl.us >
wrote in message news:OV******** ******@TK2MSFTN GP11.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 connectionstrin g
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******** ********@TK2MSF TNGP10.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!
>
>

[Jeremy Ames]

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.mach in AT dot.state.fl.us > wrote
in message news:%2******** **********@TK2M SFTNGP12.phx.gb l...
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******** ******@TK2MSFTN GP10.phx.gbl...

Can someone please help with this?

Unfortunately, that did not work.
"Ignacio Machin ( .NET/ C# MVP )" <ignacio.mach in AT dot.state.fl.us >
wrote in message news:uw******** ********@TK2MSF TNGP11.phx.gbl. ..
Hi Jeremy,

Please try using 127.0.0.1 instead of (local) in the connection string:

cnTask.Connecti onString="Data Source=127.0.0. 1;" +

"Initial Catalog=EmpDB;" +

"User ID=WebClient;" +

"Password=WebCl ient";
Cheers,
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Jeremy Ames" <yo******@here. com> wrote in message
news:%2******** ********@TK2MSF TNGP10.phx.gbl. ..
Here is the code. I am using ADO.NET with new connections and
connections strings everytime.

private void BuildEmployeeDe tail(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];

LoadInitialList s(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.Conn ectionString="D ata Source=(local); " +

"Initial Catalog=EmpDB;" +

"User ID=guest;" +

"Password=" ;

SqlCommand cmdEmployee = new SqlCommand(sSql , cnEmployee);

cnEmployee.Open ();

drEmployee = cmdEmployee.Exe cuteReader();
int nCnt = 1;
while(drEmploye e.Read())

{

// create a row to add to the existing table

TableRow rowTemplate = new TableRow();

if (nCnt % 2 != 0)

rowTemplate.Bac kColor = System.Drawing. Color.White;

else

rowTemplate.Bac kColor = 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(r owTemplate, cellCol1, drEmployee.GetS tring(0), nCnt,
drEmployee.GetB oolean(2));
// enter a hidden task id and check box to the second cell

FillSecondCell( rowTemplate, cellCol2, drEmployee.GetB oolean(2), nCnt,
drEmployee.GetI nt32(1));
FillThirdCell(r owTemplate, cellCol3, nCnt, narValues, sarInitals,
drEmployee.GetI nt32(3));

// add all of the cells in the row to the table
tblDetail.Rows. Add(rowTemplate );
//dlCopyInitials. Dispose();

rowTemplate.Dis pose();

cellCol1.Dispos e();

cellCol2.Dispos e();

cellCol3.Dispos e();

nCnt += 1;

}

drEmployee.Clos e();

cnEmployee.Clos e();

cnEmployee.Disp ose();

}

private void LoadInitialList s(int [] narVals, string [] sarVals)

{

string sSql = "SELECT I.IsId, I.IsInitials FROM jwames.istable I ORDER
BY 2";

SqlConnection cnEmployee = new SqlConnection() ;

cnEmployee.Conn ectionString="D ata Source=(local); " +

"Initial Catalog=EmpDB;" +

"User ID=guest;" +

"Password=" ;

SqlCommand cmdEmployee = new SqlCommand(sSql , cnEmployee);

cnEmployee.Open ();

drEmployee = cmdEmployee.Exe cuteReader();

int nCnt = 0;

while(drEmploye e.Read())

{

sarVals[nCnt] = drEmployee.GetS tring(1);

narVals[nCnt++] = drEmployee.GetI nt32(0);

}

drEmployee.Clos e();

cnEmployee.Clos e();

cnEmployee.Disp ose();

}

private void UpdateTask(int nEmpId, int nTaskId, bool bChecked, int
nInitials)

{

SqlConnection cnTask = new SqlConnection() ;

cnTask.Connecti onString="Data Source=(local); " +

"Initial Catalog=EmpDB;" +

"User ID=WebClient;" +

"Password=WebCl ient";
SqlCommand cmdUpdateTask = new SqlCommand("usp _UpdateTaskComp letion",
cnTask);

cmdUpdateTask.C ommandType = CommandType.Sto redProcedure;
SqlParameter parTask = cmdUpdateTask.P arameters.Add(" @p_TaskId",
SqlDbType.Int);

parTask.Value = nTaskId;

parTask = cmdUpdateTask.P arameters.Add(" @p_RemovalId", SqlDbType.Int);

parTask.Value = nEmpId;

parTask = cmdUpdateTask.P arameters.Add(" @p_Initials", SqlDbType.Int);

parTask.Value = nInitials;

parTask = cmdUpdateTask.P arameters.Add(" @p_Complete", SqlDbType.Bit);

parTask.Value = bChecked;

cnTask.Open();

cmdUpdateTask.E xecuteNonQuery( );

cnTask.Close();

cmdUpdateTask.D ispose();

cnTask.Dispose( );

}

"Ignacio Machin ( .NET/ C# MVP )" <ignacio.mach in AT dot.state.fl.us >
wrote in message news:OV******** ******@TK2MSFTN GP11.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 connectionstrin g
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******** ********@TK2MSF TNGP10.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!
>
>

[Jerry Negrelli]

What happens if you try "host=127.0.0.1 ; database=EmpDB;
user=WebClient; password=WebCli ent"?

I really wish the connection string didn't allow so many
syntaxes...

JER

-----Original Message-----
Can someone please help with this?

Unfortunatel y, that did not work.
"Ignacio Machin ( .NET/ C# MVP )" <ignacio.mach in AT dot.state.fl.us >wrote in message news:uwMY% 23***********@T K2MSFTNGP11.phx .gbl... Hi Jeremy,

Please try using 127.0.0.1 instead of (local) in the connection string:
cnTask.Connecti onString="Data Source=127.0.0. 1;" +

"Initial Catalog=EmpDB;" +

"User ID=WebClient;" +

"Password=WebCl ient";
Cheers,
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Jeremy Ames" <yo******@here. com> wrote in message
news:%2******* *********@TK2MS FTNGP10.phx.gbl ...
Here is the code. I am using ADO.NET with new connections andconnections strings everytime.

private void BuildEmployeeDe tail(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];

LoadInitialList s(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.Conn ectionString="D ata Source=(local); " +

"Initial Catalog=EmpDB;" +

"User ID=guest;" +

"Password=" ;

SqlCommand cmdEmployee = new SqlCommand(sSql , cnEmployee);
cnEmployee.Open ();

drEmployee = cmdEmployee.Exe cuteReader();
int nCnt = 1;
while(drEmploye e.Read())

{

// create a row to add to the existing table

TableRow rowTemplate = new TableRow();

if (nCnt % 2 != 0)

rowTemplate.Bac kColor = System.Drawing. Color.White;

else

rowTemplate.Bac kColor = 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(r owTemplate, cellCol1, drEmployee.GetS tring(0), nCnt,drEmployee.Get Boolean(2));
// enter a hidden task id and check box to the second cell
FillSecondCell( rowTemplate, cellCol2, drEmployee.GetB oolean(2), nCnt,drEmployee.Get Int32(1));
FillThirdCell(r owTemplate, cellCol3, nCnt, narValues, sarInitals,drEmployee.Get Int32(3));

// add all of the cells in the row to the table
tblDetail.Rows. Add(rowTemplate );
//dlCopyInitials. Dispose();

rowTemplate.Dis pose();

cellCol1.Dispos e();

cellCol2.Dispos e();

cellCol3.Dispos e();

nCnt += 1;

}

drEmployee.Clos e();

cnEmployee.Clos e();

cnEmployee.Disp ose();

}

private void LoadInitialList s(int [] narVals, string [] sarVals)
{

string sSql = "SELECT I.IsId, I.IsInitials FROM jwames.istable I ORDERBY 2";

SqlConnection cnEmployee = new SqlConnection() ;

cnEmployee.Conn ectionString="D ata Source=(local); " +

"Initial Catalog=EmpDB;" +

"User ID=guest;" +

"Password=" ;

SqlCommand cmdEmployee = new SqlCommand(sSql , cnEmployee);
cnEmployee.Open ();

drEmployee = cmdEmployee.Exe cuteReader();

int nCnt = 0;

while(drEmploye e.Read())

{

sarVals[nCnt] = drEmployee.GetS tring(1);

narVals[nCnt++] = drEmployee.GetI nt32(0);

}

drEmployee.Clos e();

cnEmployee.Clos e();

cnEmployee.Disp ose();

}

private void UpdateTask(int nEmpId, int nTaskId, bool bChecked, intnInitials)

{

SqlConnection cnTask = new SqlConnection() ;

cnTask.Connecti onString="Data Source=(local); " +

"Initial Catalog=EmpDB;" +

"User ID=WebClient;" +

"Password=WebCl ient";
SqlCommand cmdUpdateTask = new SqlCommand ("usp_UpdateTas kCompletion",cnTask);

cmdUpdateTask.C ommandType = CommandType.Sto redProcedure;

SqlParameter parTask = cmdUpdateTask.P arameters.Add ("@p_TaskId" ,SqlDbType.Int) ;

parTask.Value = nTaskId;

parTask = cmdUpdateTask.P arameters.Add ("@p_RemovalId" , SqlDbType.Int);
parTask.Value = nEmpId;

parTask = cmdUpdateTask.P arameters.Add ("@p_Initial s", SqlDbType.Int);
parTask.Value = nInitials;

parTask = cmdUpdateTask.P arameters.Add ("@p_Complet e", SqlDbType.Bit);
parTask.Value = bChecked;

cnTask.Open();

cmdUpdateTask.E xecuteNonQuery( );

cnTask.Close();

cmdUpdateTask.D ispose();

cnTask.Dispose( );

}

"Ignacio Machin ( .NET/ C# MVP )" <ignacio.mach in AT dot.state.fl.us >wrote in message news:OV******** ******@TK2MSFTN GP11.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 connectionstrin g 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******** ********@TK2MSF TNGP10.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!
>
>

.