Subject Firebird Embedded on shared web hosting
Author


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