Re: [firebird-support] Firebird Embedded on web hosting

 

Can you please give some detail of Operating System and Version/Distro you are using ?

Kind Regards

Alain Bastien
34 Dr Ross Avenue
Rose Hill 72102
Mauritius
Mobile Tel: +230  5 719 30 30

Skype:alainbastien

Viber: 7320143

On Mon, Sep 26, 2016 at 2:27 AM, amigoface@gmail.com [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

__._,_.___

---

Posted by: Alain Bastien <alainbastien@gmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (15)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit Your Group

• New Members 3

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___