/[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 46 by william, Thu Jul 12 14:17:14 2012 UTC revision 50 by william, Thu Jul 12 14:51:57 2012 UTC
# Line 267  namespace AnywhereTS Line 267  namespace AnywhereTS
267                  {                  {
268                      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'")))
269                      {                      {
270                          Logging.ATSAdminLog.Debug("Gettting AnywhereTS Database Version");                          Logging.ATSAdminLog.Debug("Getting AnywhereTS Database Version#1");
271                          sqlCon = new SqlConnection(Properties.Settings.Default.atsConnectionString);                          sqlCon = new SqlConnection(Properties.Settings.Default.atsConnectionString);
272                          if (sqlCon.State != ConnectionState.Open) sqlCon.Open();                          if (sqlCon.State != ConnectionState.Open) sqlCon.Open();
273                          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 298  namespace AnywhereTS Line 298  namespace AnywhereTS
298    
299                          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'")))
300                          {                          {
301                              Logging.ATSAdminLog.Debug("Gettting AnywhereTS Database Version");                              Logging.ATSAdminLog.Debug("Getting AnywhereTS Database Version#2");
302                              sqlCon = new SqlConnection(Properties.Settings.Default.atsConnectionString);                              sqlCon = new SqlConnection(Properties.Settings.Default.atsConnectionString);
303                              if (sqlCon.State != ConnectionState.Open) sqlCon.Open();                              if (sqlCon.State != ConnectionState.Open) sqlCon.Open();
304                              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.46  
changed lines
  Added in v.50

  ViewVC Help
Powered by ViewVC 1.1.22