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 WorkDirectory(ServerInfo servInfo)
{
fullPath = String.Format("{0}\\servers\\{1}\\",
Directory.GetCurrentDirectory(),
servInfo.serverGuid.ToString());
Debug.WriteLine(fullPath);
if (!Directory.Exists(fullPath))
{
Directory.CreateDirectory(fullPath);
}
}
public Boolean Connect(ServerInfo sinfo)
{
mysqlConnection = new MySqlConnection(
String.Format("server={0};user id={1};password={2};database={3};",
sinfo.dbInfo.sqlhost, sinfo.dbInfo.sqluser, sinfo.dbInfo.sqlpass, sinfo.dbInfo.sqldb));
try
{
mysqlConnection.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;
}
