Subject | Firebird Embedded on shared web hosting |
---|---|
Author | |
Post date | 2016-09-25T23:46:21Z |
hi everyone !
I am struggling with firebird 2.5.4 for two day now to make it working on a shared web hosting (arvixe)
i will give you just the short story ...
- copied fbembed.dll and all it's dependencies to my bin folder
- create the 3 environnements variables on server and check they are ok with this
var path = (Path.GetDirectoryName(Assembly.GetExecutingAssembly().CodeBase)).Replace("file:\\", "");
Environment.SetEnvironmentVariable("FIREBIRD", path);
Environment.SetEnvironmentVariable("FIREBIRD_LOCK", path + "\\FIREBIRD_LOCK");
Environment.SetEnvironmentVariable("FIREBIRD_TMP", path + "\\FIREBIRD_TMP");
Environment.SetEnvironmentVariable("FIREBIRD_TEMP", path + "\\FIREBIRD_TEMP");
- create the entity framework connectionstring dynamically like this
FBEntities context = null;
string p = "metadata=res://*/FBModel.csdl|res://*/FBModel.ssdl|res://*/FBModel.msl;provider=FirebirdSql.Data.FirebirdClient;provider connection string='client library=??fbembed??;initial catalog=|DataDirectory|MyDatabase.gdb;user id=SYSDBA;password=masterkey;Connection lifetime = 0; Pooling = true; MinPoolSize = 0; MaxPoolSize = 500; Packet Size = 8192; ServerType = 1'";
p = p.Replace("??fbembed??", path + @"\fbembed.dll");
p = p.Replace("|DataDirectory|", Directory.GetParent(path) + @"\BDD\");
context = new FBEntities(p);
but when i try to access to the database i recieve this error message
operating system directive OpenProcess failed
important notes :
1) i have checked that some junky file is created in the FIREBIRD_LOCK subfolder so the environement variable is used
2) i am not using firebird.conf
any help is welcome :)
ps : my asp.net app work just fine locally with fb embedded