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 wemcome :)
ps : my asp.net app work just fine locally with fb embedded
