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;
}
}
