public Boolean Connect(ServerInfo sinfo) { //seems like both sqlite and sqlce don't like the word database... WorkDirectory wd = new WorkDirectory(sinfo); String path = wd.GetFullPath(sinfo.dbInfo.sqldb); String conString = "data source=" + path + ";"; if (!File.Exists(path)) { using(SqlCeEngine engine = new SqlCeEngine(conString)) { engine.CreateDatabase(); } } sqlceConnection = new SqlCeConnection(conString); try { sqlceConnection.Open(); } catch (Exception e) { Console.WriteLine("Connection error: " + e.Message); return false; } return true; }
public Boolean Connect(ServerInfo sinfo) { //doesn't accept database for w/e reason //data source it is... WorkDirectory wd = new WorkDirectory(sinfo); sqliteConnection = new SQLiteConnection("data source=" + wd.GetFullPath(sinfo.dbInfo.sqldb) + ";"); try { sqliteConnection.Open(); } catch (Exception e) { Console.WriteLine("Connection error: " + e.Message); return false; } return true; }
public void SaveConfig(String config) { Console.WriteLine("Saving config to: " + config); WorkDirectory wd = new WorkDirectory(this.servInfo); wd.WriteFile(config, "Test Data"); currentConfig = config; }