Re: [firebird-support] multiple embedded versions
one possible solution for me is to have a separate fbembed for each database but all share the same FBLock directory . do you think that it can work without conflict ?
Re: [firebird-support] multiple embedded versions
@Dmitry, @Ralf > i have managed to use the firebird embedded on the shared hosting by setting > the FIREBIRD_LOCK variable > Why? This is not necessary. this is necessary because the default firebird lock folder is "program data / firebird" wich is restricted for writing on shared hosting > another option is to use a single fbembed.dll library for all the > website but i don't know if it's possible . > It should be possible. i am not sure but each website correspond to a single process, and i have read somewhere that the fbembed library can be used by only one process at a time @Karol Bieniaszewski > Why this is system variable at all? > Why this is not a in firebird.conf i cannot find the option in the config file for setting the lock directory , only temp one Le ven. 1 mars 2019 à 13:53, Ralf Jansen ralf.jan...@mailstore.com [firebird-support] a écrit : > > > I’m using multiple firebird embedded versions from within the same process > without fiddling around in environment variables like FIREBIRD_LOCK or > conf files of the different firebird versions. > > > > There should be no need in doing anything special. Just use the version(s) > you like. > > > > Ralf > > > > > > *Von:* firebird-support@yahoogroups.com > > *Gesendet:* Donnerstag, 28. Februar 2019 21:17 > *An:* firebird-support@yahoogroups.com > *Betreff:* [firebird-support] multiple embedded versions > > > > > > hi, > > let's say that i have differents applications on different folders . > > > > each folder contain a firebird database and an embedded firebird dll . > > > > is it safe to use this setup knowing that all the embedded libraries will > use the same *firebird lock directory* . > > > > the reason for this and not using a regular firebird server is that i am > on a web shared hosting environement , > > i have several websites on the same server and each website have it's own > database and fbembed.dll library . > > > > i have managed to use the firebird embedded on the shared hosting by > setting > > the FIREBIRD_LOCK variable , but i dont know if it safe to use this setup > that way . > > > > > > another option is to use a single fbembed.dll library for all the website > but i don't know if it's possible . > > in any case there is a firebird database .gdb for each single website / > process . > > > > > > any idea is welcome , thanks . > > >
[firebird-support] multiple embedded versions
hi, let's say that i have differents applications on different folders . each folder contain a firebird database and an embedded firebird dll . is it safe to use this setup knowing that all the embedded libraries will use the same *firebird lock directory* . the reason for this and not using a regular firebird server is that i am on a web shared hosting environement , i have several websites on the same server and each website have it's own database and fbembed.dll library . i have managed to use the firebird embedded on the shared hosting by setting the FIREBIRD_LOCK variable , but i dont know if it safe to use this setup that way . another option is to use a single fbembed.dll library for all the website but i don't know if it's possible . in any case there is a firebird database .gdb for each single website / process . any idea is welcome , thanks .
[firebird-support] Gbak with embedded firebird
Hi, is there a way to use gbak with embedded firebird . 2.5 here what i have tried : - i download firebird in zip format . - downloaded the embeded version of fb - copied the fbembed.dll in the firebird bin folder and renamed it fblicent.dll - copied the msg files and the security db ... etc on that bin folder then executed this cmd command in the bin folder: gbak -C -USER SYSDBA -PAS masterkey -verbose E:\path\backup.gbk E:\path\restored.gdb but it's stuck with this output gbak:opened file E:\path\backup.gbk and no file is created i have a regular fb 2.5 installed on my machine (wich work with gbak) so i have disabled the service in order to use the embedded version have tried both 32 and 64 versions any help is welcome , thanks .
Re: [firebird-support] Re: very slow firebird embedded connection on a web application
using process monitor i have discovered that there is some tcp activities when running the sql query on the web application [image: test.jpg] Le mer. 12 déc. 2018 à 20:25, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] a écrit : > 12.12.2018 20:03, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] > wrote: > > What optimization advantages are you thinking of? > >Result set buffering can significantly speed up fetch. > > -- >WBR, SD. > > > > > > > ++ > > 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/ > > ++ > > > Yahoo Groups Links > > > > [Non-text portions of this message have been removed]
Re: [firebird-support] very slow firebird embedded connection on a web application
yep this mean that i am right about my connection issue :p i have also tried without including localhost or any iP . i am for 3 days now with this thing and tried almost any combination except the good one :/ Le mer. 12 déc. 2018 à 18:11, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] a écrit : > 12.12.2018 17:18, Issam Boughanmi amigof...@gmail.com [firebird-support] > wrote: > > also sometimes i have a Network Error (tcp_error) during my various > tests changes . > >It means that you are wrong in your assumption about using of an > embedded engine. > >And your connection string confirms that by mentioning "localhost". > embed.dll can work > as an ordinary client library, you know... > > > -- >WBR, SD. > > > > > > > ++ > > 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/ > > ++ > > > Yahoo Groups Links > > > >
Re: [firebird-support] very slow firebird embedded connection on a web application
just an assumption , but :
basically i have two actions in my test method :
- open the database with the dynamic connectionstring
- run a simple count(*) query on a table that contain 3 rows .
also sometimes i have a Network Error (tcp_error) during my various tests
changes .
and like i said it work fine locally.
btw i have fb 2.5 installed on my local machine , but i stop the service
when i want to test the embedded version .
also on the web application i set the lock destination directory with some
environement variable .
Environment.SetEnvironmentVariable("FIREBIRD", env.ContentRootPath);
Environment.SetEnvironmentVariable("FIREBIRD_LOCK",
Path.Combine(env.ContentRootPath, @"fblock\"));
when i run the web application some empty trace files are created on that
folder , so the embed lib is found but take a long long time to get
data from the database or have a tcp_error message .
can you check if my connectionstring is correct please :
@"Datasource=localhost;initial catalog=h:\fullpath\database.fdb;server
type=1;user id=SYSDBA;character set=UTF8;pooling=False;client
library=h:\fullpath\embed.dll";
(i have tried lot of variants )
the fb version i am using is :
Firebird-2.5.8.27089-0_x64_embed
[firebird-support] very slow firebird embedded connection on a web application
hi,
i want to use a firebird embedded database in an asp.net core 2.1 web
application
Windows 64 shared hosting
Firebird-2.5.8.27089-0_x64_embed
FbClient 6.4.0
here the code i am using to query the database :
[HttpGet]
public string TestFBQuery()
{
var r = "";
string path = AppDomain.CurrentDomain.BaseDirectory;
var connectionString = @"initial catalog=??DB??;server type=Embedded;user
id=SYSDBA;character set=UTF8;pooling=False;client library=??lib??";
connectionString =
connectionString.Replace("??DB??",path+"BDD\APP_DATABASE.gdb");
connectionString = connectionString.Replace("??lib??",path+"fbembed.dll");
using (var connection = new FbConnection(connectionString))
{
connection.Open();
using (var command = new FbCommand("select count(*) from
APP_OPTIONS", connection))
{
r= command.ExecuteScalar().ToString();
}}
return r;
}
it work but very very slowly (about 1 minute !!!)
any idea on what can produce this , maybe something related to server ip or
something like that ?
any help is welcome , thanks .
Re: [firebird-support] update or insert inside a stored procedure
@Mark: it's a little hard to give a reproducible example but please look this please : 1) Error on executing the stored procedure [image: e1.jpg] so i search for records with these Fields [image: e2.jpg] then run a new query with the hardcoded values without a problem [image: e3.jpg] [Non-text portions of this message have been removed]
Re: [firebird-support] update or insert inside a stored procedure
@Karol : there is 3 fields : v*A*num : primar key vInum + ancode : composite unique index . this is a little wierd to me : if the matching is based on the primary key , normally on the execution when the record is found it will update right and not insert a new one? also like i said if i run this same query as a standalone outside the SP it run fine .. hope it make sense .
Re: [firebird-support] force disconnect and replace db in use
sorry for the lack of informations : the firebird version is 2.5.8 embedded in windows 64 *shared hosting* the web application is developped using asp.net core in c# this database hosted on the net are exclusively used for read only operations i mean no configuration is done but the users only view the data on the net with this database , no changes can be made i want to be able to stop the embedded server and disconnect all the currrent connections in order to replace the database in use with newer version , this can be done every night with a custom software developped that upload the newer database with ftp . thanks again .
[firebird-support] force disconnect and replace db in use
hi, is there any programming api to force firebird connections and pools to disconnect . i have a database that run on a shared web hosting in embedded mode . i want to be able to force disconnect in order to be able to replace the database programatically .
[firebird-support] reacreate database with a different charset
i want to change the charset of an existing database from none to utf8, it seems that the safest way is to create a new one then pump data to it . i have tried two methods both gave me the same error . 1 - recreate a new database with utf8 charset , then create a simple stored procedure to pump data via "execute block on external datasource" 2 - use fbclone with this command line fbclone -l fbembed.dll -v -s source.gdb -t destination.gdb -u SYSDBA -p masterkey -tc UTF8 -wc UTF8 both gave me mailformed string error, and a most of rows were not copied to the destination database... exemple verbose error Incompatible column/host variable data type GDS Code: 335544569 - SQL Code: -303 - Error Code: 249 fields values --- VANUM = 244458 RUBNUM = 5054 VALEUR = Absence de germes pathogènes. ATBANA = DATEMODIF = 16/05/2018 any help is welcome thanks
Re: [firebird-support] Firebird 3 embedded lock/temp files
nice, i have found the "TempDirectories" section in firebird.conf so i guess that tha's it :) so i have to test that . and about classis and super server what do you recommend for this ? about lock files , i am not sure what this is usefull for . 1 : can we setup the environement vars in shared hosting ? 2 : the database is used for *strictly read only* operations, can we configure firebird to treat databases as read only options only . i am guessing that this lock files are related somehow, so if we disable write operations maybe it will help . and maybe i don't even need to setup lock files or things like that . 2018-07-16 16:09 GMT+02:00 Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] : > 16.07.2018 15:56, Issam Boughanmi amigof...@gmail.com [firebird-support] > wrote: > > is it possible to set custom path for the lock and temp files in > firebird 3 embedded via > > config file or anything else ? > >Yes, temp files directory are configured in firebird.conf or > FIREBIRD_TMP environment > variable and lock file can be moved by FIREBIRD_LOCK environment variable. > > > -- >WBR, SD. > > > > > > > ++ > > 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/ > > ++ > > > Yahoo Groups Links > > > >
[firebird-support] Firebird 3 embedded lock/temp files
hi everyone . is it possible to set custom path for the lock and temp files in firebird 3 embedded via config file or anything else ? i want this to test my web application in a shared hosting before i buy a vps or a dedicated server . i remember that i have tried some time ago with 2.5 without success because the firebird engine have no access to program data folder in a shared hosting . so i am wondering if this is possible in fb3 or fb2.5 :p any idea or information on this is much appreciated :) thanks .
[firebird-support] hosting on linux questions
hi, i want to setup a vps to host my web site / application using existing firebird databases 1- after some search , it seems that the recommended linux distribution for a web server is centos 7, then ubuntu . any feedbacks , recommendations, ideas on this please , and how it behave with firebird ? 2 - i am not really a linux user , what is the best place/directory to put the fdb databases ? 3 - i have several databases for differents custumers (20 / 30 or more), can a single firebird server handle many databases correctly ? thanks .
Re: [firebird-support] Firebird 3 Wire compression encrypt basic setup ?
thanks a lot .
Re: [firebird-support] Firebird 3 Wire compression encrypt basic setup ?
hi Mark, thanks for the great answer :) ok let's forget Fb3 wire thing ... like i said i have already a working zebedee setup, now what is the main benefit for using ssh instead apart that zebedee development is stopped in 2005 :p ? ps : in the firebird faq there is a mention about ssl too , what is the difference about all these acronyms in our context (ssh, ssl , ...)?
Re: [firebird-support] execute block where External datasource is localhost :p
hmmm that make sense . thanks for your help, really appreciate .
[firebird-support] execute block where External datasource is localhost :p
i am writing a little .net application that connect to a remote database server hosted on internet to make a sort of replication . so the database source live in my local firebird server the destination database is on the firebird server hosted on the intenet here the query execute block as DECLARE panum INT; DECLARE nom varchar(50); DECLARE prenom varchar(50); DECLARE dna date; DECLARE datemodif date; DECLARE VARIABLE VSQL VARCHAR(500); begin VSQL = 'select panum, nom, prenom, dna, DATEMODIF from patient where (datemodif is not null) and (datediff (day from current_date to cast(DATEMODIF as date)) >= 0) '; FOR execute statement VSQL ON EXTERNAL DATA SOURCE '127.0.0.1:C:\BDD\D2018.gdb' AS USER 'sysdba' PASSWORD 'masterkey' INTO :panum, :nom, :prenom, :dna, :DATEMODIF DO merge into patient bb using (select :panum panum, :nom nom, :prenom prenom, :dna dna, :DATEMODIF datemodif from RDB$DATABASE ) n on bb.panum = n.panum when matched then update set bb.nom = :nom, bb.prenom = :prenom, bb.dna = :DNA, bb.DATEMODIF = :DATEMODIF when not matched then insert(panum, nom, prenom, dna, datemodif) values(:panum, :nom, :prenom, :dna, :datemodif); suspend; end; both servers run fb3.0.3 on a windows 64 machines . but it fail saying that it cannot find the host 127.0.0.1 . i have also tried localhost and my local ip adress as well . if i flip the direction so my source database is the remote server and the destination is my local server *it works* i know that's a little wierd but i have some constraints for doing it like that any help is welcome , thanks .
Re: [firebird-support] Firebird : Arithmetic overflow exception only in execute block statement
yep ! i have noticed that after posting :p sometimes all what you have to do is to take a deep breath and take a closer look on your code ... thanks . 2018-05-05 19:44 GMT+01:00 Mark Rotteveel m...@lawinegevaar.nl [firebird-support] <firebird-support@yahoogroups.com>: > > > On 2018-05-05 19:49, Issam Boughanmi amigof...@gmail.com > [firebird-support] wrote: > > i have this heterogeneous cross database query > > > > execute block as > > DECLARE panum INT; > > DECLARE nom varchar(50); > > DECLARE prenom varchar(50); > > DECLARE dna date; > > DECLARE datemodif date; > > DECLARE m date; > > DECLARE VARIABLE VSQL VARCHAR(100); > > begin > > VSQL = 'select panum, nom, prenom, dna, DATEMODIF from patient where > > > > (datemodif is not null ) and (datediff (day from current_date to > > cast(DATEMODIF as date))>-2)'; > > > > FOR execute statement VSQL ON EXTERNAL DATA SOURCE > > 'localhost/3050:C:/BDD/Replications/Source/D2018.gdb' AS USER > > 'sysdba' > > PASSWORD 'masterkey' > > INTO :panum, :nom, :prenom, :dna, :DATEMODIF DO > > > > suspend; > > end; > > > > wich give me an arithmetic overflow or string truncation error . > > > > > > if > > i run the query in a single database it work fineselect panum, nom, > > prenom, dna, DATEMODIF from patient where (datemodif is > > not null ) and (datediff (day from current_date to cast(DATEMODIF as > > date))>-2) > > > > if i remove the datediff where clause condition in the original query > > it work also. > > > > the two databases are exactly the same (schema and data), actually > > it's a copy/paste . > > > > any idea on what's going on please ? > > The query you are trying to assign to VSQL is longer than 100 characters > (162 according to my editor, including new lines). You'll need to > declare VSQL to be larger than VARCHAR(100). > > Mark > >
[firebird-support] Firebird : Arithmetic overflow exception only in execute block statement
i have this heterogeneous cross database query execute block as DECLARE panum INT; DECLARE nom varchar(50); DECLARE prenom varchar(50); DECLARE dna date; DECLARE datemodif date; DECLARE m date; DECLARE VARIABLE VSQL VARCHAR(100); begin VSQL = 'select panum, nom, prenom, dna, DATEMODIF from patient where (datemodif is not null ) and (datediff (day from current_date to cast(DATEMODIF as date))>-2)'; FOR execute statement VSQL ON EXTERNAL DATA SOURCE 'localhost/3050:C:/BDD/Replications/Source/D2018.gdb' AS USER 'sysdba' PASSWORD 'masterkey' INTO :panum, :nom, :prenom, :dna, :DATEMODIF DO suspend;end; wich give me an arithmetic overflow or string truncation error . if i run the query in a single database it work fine select panum, nom, prenom, dna, DATEMODIF from patient where (datemodif is not null ) and (datediff (day from current_date to cast(DATEMODIF as date))>-2) if i remove the datediff where clause condition in the original query it work also. the two databases are exactly the same (schema and data), actually it's a copy/paste . any idea on what's going on please ?
Re: [firebird-support] VS2008 DDEX/ADO.NET confusion
hi, i have never tried firebird on windows CE, but i can tell you that you need only as minimum the firebird embedded installation + ADO.net provider to get an SGBD for your app . for firebird pick the zip archive and extract all the dll inside into your app folder, there is also a readme . for ado.net also picj zip or 7zip archive . the DDEX is only for the IDE integration, for example to be able to use fb in the designer . but you can ignore the ddex and access the firebird engine by code . hope it help 2015-11-28 6:38 GMT+01:00 slucas slu...@iquanta.com [firebird-support] < firebird-support@yahoogroups.com>: > > > may someone please give me some clarity? i am using visual studio > 2008. i have to use that version to develope an embedded program for a > smart device. so i am locked into VS2008. > > i am trying to find and implement the correct library for fb_client.dll > for use on this windows CE embedded device. i can't for the life of me > figure out what libraries to install for VS2008 that actually work? i > have downloaded the DDEXProvider-3.0.2.0.msi and installed if for > VS2008x32 and x64. is that enough? i have also read that i also need > to install the ADO.NET library. is that true or can i use the DDEX by > itself? > > and if i can use the DDEX library by itself, can someone point me to an > example/tutorial on exactly how to setup a connection, query, sql, > close, close, in pure code please? > > thank you in advance, lucas > >
