/[AnywhereTS-MSSQL]/trunk/TSAdminTool/Database.cs
ViewVC logotype

Diff of /trunk/TSAdminTool/Database.cs

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 44 by william, Thu Jul 12 12:59:45 2012 UTC revision 45 by william, Thu Jul 12 13:01:44 2012 UTC
# Line 264  namespace AnywhereTS Line 264  namespace AnywhereTS
264                      using (log4net.NDC.Push(string.Format("SQL Statment={0}", "SELECT value from AnywhereTS..AppInfo where property='version'")))                      using (log4net.NDC.Push(string.Format("SQL Statment={0}", "SELECT value from AnywhereTS..AppInfo where property='version'")))
265                      {                      {
266                          Logging.ATSAdminLog.Debug("Gettting AnywhereTS Database Version");                          Logging.ATSAdminLog.Debug("Gettting AnywhereTS Database Version");
                         sqlCon.Close();  
267                          sqlCon = new SqlConnection(Properties.Settings.Default.atsConnectionString);                          sqlCon = new SqlConnection(Properties.Settings.Default.atsConnectionString);
268                          if (sqlCon.State != ConnectionState.Open) sqlCon.Open();                          if (sqlCon.State != ConnectionState.Open) sqlCon.Open();
269                          sqlCmd = new SqlCommand("SELECT value from AnywhereTS..AppInfo where property='version'", sqlCon);                          sqlCmd = new SqlCommand("SELECT value from AnywhereTS..AppInfo where property='version'", sqlCon);
# Line 296  namespace AnywhereTS Line 295  namespace AnywhereTS
295                          using (log4net.NDC.Push(string.Format("SQL Statment={0}", "SELECT value from AnywhereTS..AppInfo where property='version'")))                          using (log4net.NDC.Push(string.Format("SQL Statment={0}", "SELECT value from AnywhereTS..AppInfo where property='version'")))
296                          {                          {
297                              Logging.ATSAdminLog.Debug("Gettting AnywhereTS Database Version");                              Logging.ATSAdminLog.Debug("Gettting AnywhereTS Database Version");
                             sqlCon.Close();  
298                              sqlCon = new SqlConnection(Properties.Settings.Default.atsConnectionString);                              sqlCon = new SqlConnection(Properties.Settings.Default.atsConnectionString);
299                              if (sqlCon.State != ConnectionState.Open) sqlCon.Open();                              if (sqlCon.State != ConnectionState.Open) sqlCon.Open();
300                              sqlCmd = new SqlCommand("SELECT value from AnywhereTS..AppInfo where property='version'", sqlCon);                              sqlCmd = new SqlCommand("SELECT value from AnywhereTS..AppInfo where property='version'", sqlCon);

Legend:
Removed from v.44  
changed lines
  Added in v.45

  ViewVC Help
Powered by ViewVC 1.1.22