I am using Firebird database and newly started with this database so I am implementing with Visual studio 2015. I am accessing a Firebird Embedded database using ADO.NET and my Firebird Embedded database file extension is .CMP. I am successfully using ADO.NET.
Now I want to use with Firebird Entity Framework. I have done a successful install. When I click entity data model and select the Firebird data source it opens connection properties where I select server type =1(embedded)
.
This is my ADO.NET connection string:
string Connectionstring = "User=SYSDBA;Password=masterkey;Database=localhost:G\\CLINEDB.CMP;DataSource=localhost;Port=3050;Dialect=3; Charset=NONE;Role=;Connection lifetime=15;Pooling=true; MinPoolSize=0;MaxPoolSize=50;Packet Size=8192;ServerType=1;"
When I click test connection it show this error:
Unable to load DLL fbembed: the specified module could not be found
I have downloaded the embedded folder from Firebird and added it to the project solution so in advance option added 'Client Library as fbclient.dll file from project solution' for this I am getting error
Connection lost to database
How can I fix this?