static public void OpenDatabase(string dataSource, bool readOnly = false) { UserName = Environment.UserName; ASL.Run.Log.UseExceptionLogger = false; // get configuration database parameters and connect to DB XmlDocument xdoc = new XmlDocument(); xdoc.Load(@"FSA042.params.xml"); XmlElement xDatabase = (XmlElement)xdoc.DocumentElement.SelectSingleNode("Database"); string userAtt = (readOnly) ? "roUsername" : "username"; string dbUserID = DecryptPW(xDatabase.GetAttribute(userAtt), 29); string dbPassword = DecryptPW(xDatabase.GetAttribute("password"), 29); SqlConnectionStringBuilder csb = new SqlConnectionStringBuilder(); csb.DataSource = dataSource; csb.InitialCatalog = "SDPM01_Master"; csb.UserID = dbUserID; csb.Password = dbPassword; csb.IntegratedSecurity = false; lastDbConnectionString = csb.ConnectionString; DbConnection = new ASL.SQL.DBConnection(lastDbConnectionString); }
static public void ReConnect() {// used only in FSA_ImportTxt... DbConnection = new ASL.SQL.DBConnection(lastDbConnectionString); }
static public void Close() { lastDbConnectionString = null; ProductVersion = null; if (DbConnection != null) { DbConnection.Connection.Close(); DbConnection = null; } }