using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace AnywhereTS { public partial class frmConfigureControlPanel : Form { public frmConfigureControlPanel() { InitializeComponent(); } private void btnOk_Click(object sender, EventArgs e) { // Validate database server string dataServer; dataServer = textInput.Text.Trim(); //Create a connection to SQL Server SqlConnection sqlCon = new SqlConnection(); try { sqlCon.ConnectionString = @"Data Source=" + dataServer + @"\SQLEXPRESS;Database='AnywhereTS';Integrated Security=True;Connect Timeout=30;User Instance=False"; sqlCon.Open(); } catch (SqlException sql_ex) { MessageBox.Show("Could not connect to the datbase server. Please check your spelling and your connections. SQL Server Express error:\n" + sql_ex.Number.ToString() + " " + sql_ex.Message.ToString()); return; } // Save database server to variable and registry ProSupport.strDatabaseServer = textInput.Text; ATSGlobals.SetATSRegValue(ProSupport.strRegDatabaseServer, ProSupport.strDatabaseServer); DialogResult = DialogResult.OK; //return } } }