/[AnywhereTS-MSSQL]/trunk/TSControlPanel/frmConfigureControlPanel.cs
ViewVC logotype

Annotation of /trunk/TSControlPanel/frmConfigureControlPanel.cs

Parent Directory Parent Directory | Revision Log Revision Log


Revision 51 - (hide annotations) (download)
Thu Jul 12 16:21:35 2012 UTC (7 years, 11 months ago) by william
File size: 2033 byte(s)
fix an issue that was resolved by connecting to master database instead of AnywhereTS database

1 william 4 using System;
2     using System.Collections.Generic;
3     using System.ComponentModel;
4     using System.Data;
5     using System.Drawing;
6     using System.Text;
7     using System.Windows.Forms;
8     using System.Data.SqlClient;
9    
10     namespace AnywhereTS
11     {
12     public partial class frmConfigureControlPanel : Form
13     {
14     public frmConfigureControlPanel()
15     {
16     InitializeComponent();
17     }
18    
19     private void btnOk_Click(object sender, EventArgs e)
20     {
21     // Validate database server
22     string dataServer;
23     dataServer = textInput.Text.Trim();
24     //Create a connection to SQL Server
25     SqlConnection sqlCon = new SqlConnection();
26     try
27     {
28 william 51 sqlCon = new SqlConnection(Properties.Settings.Default.atsConnectionString.Replace("AnywhereTS", "master"));
29 william 4 sqlCon.Open();
30     }
31     catch (SqlException sql_ex)
32     {
33 william 17 MessageBox.Show("Could not connect to the datbase server. Please check your spelling and your connections. SQL Server error:\n" + sql_ex.Number.ToString() + " " + sql_ex.Message.ToString());
34 william 46 using (log4net.NDC.Push(string.Format("SqlException: ID={0} MESSAGE={1}{2}Diagnostics:{2}{3}", sql_ex.Number.ToString(), sql_ex.Message, System.Environment.NewLine, sql_ex.ToString())))
35     {
36 william 49 using (log4net.NDC.Push(string.Format("ConnectionString={0}", Properties.Settings.Default.atsConnectionString)))
37     {
38     Logging.TSControlPanelLog.Error("Could not connect to the datbase server");
39     }
40 william 46 }
41 william 4 return;
42     }
43    
44    
45     // Save database server to variable and registry
46     ProSupport.strDatabaseServer = textInput.Text;
47     ATSGlobals.SetATSRegValue(ProSupport.strRegDatabaseServer, ProSupport.strDatabaseServer);
48    
49     DialogResult = DialogResult.OK; //return
50     }
51     }
52     }

  ViewVC Help
Powered by ViewVC 1.1.22