Hi Thanks for clicking,
We have this issue. We are trying to connect to SQL server uing the code show.
However it keeps dropping the Pwd="Password" in the ConnectionString when I check it in the debugger
Can anyone help??
It simply returns "MultipleActiveResultSets=
True;Data Source=" & strSQLServerName & ";Initial Catalog=trackerSQL;Integra
ted Security=False;User ID=sa;"
and drops the Pwd bit
Dim strConnectionString As String = "MultipleActiveResultSets=True;Data Source=" & strSQLServerName & ";Initial Catalog=trackerSQL;Integrated Security=False;User ID=sa;Pwd=password"
cnnSQL = New System.Data.SqlClient.SqlConnection()
cnnSQL.ConnectionString = strConnectionString