On Mon, Sep 26, 2016 at 2:27 AM, amigoface@... [firebird-support] <firebird-support@yahoogroups.com> wrote:

 

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