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
hmmm that make sense .
thanks for your help, really appreciate .
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
n 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);
> > DECL
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
thanks a lot .
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 ,
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
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
d 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
>
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
@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]
@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
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 .
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
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
-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
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
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 = "";
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
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
@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
>
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 ?
23 matches
Mail list logo