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

Contents of /trunk/TSControlPanel/frmConfigureControlPanel.cs

Parent Directory Parent Directory | Revision Log Revision Log


Revision 51 - (show annotations) (download)
Thu Jul 12 16:21:35 2012 UTC (7 years, 7 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 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 sqlCon = new SqlConnection(Properties.Settings.Default.atsConnectionString.Replace("AnywhereTS", "master"));
29 sqlCon.Open();
30 }
31 catch (SqlException sql_ex)
32 {
33 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 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 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 }
41 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