In the code snippet below - I place a SQL Server connection.Open in a try block incase it throws an exception.
If I mung the server name in the connection string, and single step it - the Open simply hangs, without throwing an exception.
What am I missing?
Thanks much - Ken
string connectProject = Properties.Settings.Default.PS2007ReportingConnection;
string projectSQL = "SELECT ProjectUID, ProjectName, BaaN_ProjectID FROM MSP_EpmProject_UserView";
OutputUtilsLogs ulog = new OutputUtilsLogs();
DataTable dt = new DataTable();
using (SqlConnection connection = new SqlConnection(connectProject))
SqlCommand command = new SqlCommand(projectSQL, connection);
catch (Exception ex)
ulog.writeNTConsoleAndEventLog(ex, "Actuals", "--SQL connection Open from getProjectView failed.");