private string ConvertSQLCE35ConnectionStringToOLEDB(string ce35ConnectionString)
{
StringBuilder oledbConnectionString = new StringBuilder();
PFDataAccessObjects.PFDatabase db = null;
string databasePath = string.Empty;
string databasePassword = string.Empty;
try
{
db = new PFDataAccessObjects.PFDatabase(PFDataAccessObjects.DatabasePlatform.SQLServerCE35);
db.ConnectionString = ce35ConnectionString;
databasePath = db.GetPropertyValue("DatabasePath").ToString();
databasePassword = db.GetPropertyValue("DatabasePassword").ToString();
oledbConnectionString.Length = 0;
oledbConnectionString.Append("Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;");
oledbConnectionString.Append("Data Source=");
oledbConnectionString.Append(databasePath);
oledbConnectionString.Append(";");
if (databasePassword.Trim().Length > 0)
{
oledbConnectionString.Append("SSCE:Database Password='******';");
}
}
catch (System.Exception ex)
{
_msg.Length = 0;
_msg.Append(AppGlobals.AppMessages.FormatErrorMessage(ex));
throw new System.Exception(_msg.ToString());
}
finally
{
;
}
return(oledbConnectionString.ToString());
}
