> As a result, I have no idea why the Firebird FDB database file is
> still being used by the master application.
>
> Does anyone have any ideas as to how I can get around this so I can
> complete the delete process?
If all connections are properly closed you should be able to drop
database
> select first(8) ID from TBL_TEST
>
> where ID not in (select first(2) ID from TBL_TEST order by ID desc)
> order by ID desc
>
the execution plan can be show e.g. with flamerobin client.
The result should be the same as "select first 8 skip 2 from TBL_TEST
ORDER BY ID DESC"
Elmar
> we wrote an cross-platform application framework that should
> be relocatible including the database engine and the database file.
> For Windows systems there is a command line option "-a" to start
> Firebird as application. I did not find any similar for the Linux
> version. Is there any way
Am 20.12.19 um 22:59 schrieb Steve Naidamast
blackfalconsoftw...@outlook.com [firebird-support]:
> The first would be using DotNetZip to compress and encrypt the Firebird
> database file into a zip file with a pass word. The next level of encryption
> would be to take the zip file and encrypt
> All other database engines that I have worked with provide password
> protection, even SQLite, which is used primarily for desktop and device
> applications.
I'm not familiar which the technique SQLite uses.
But either they are using the password to encrypt database or it is an
fake
> Is there any way to secure the FDB file from unauthorized access (other than
> compression and encryption, which I am starting to implement in my project)
> and if not, is there expected to be at least password protection for the
> Embedded edition in Firebird 4.0?
Password protection does
> The application requires Firebird to be installed and running on both the
> client computer (which also runs Firebird client), and the server with the
> shared .fdb databases. Firebird is fully integrated with the Ascent
> program..
I'm sure the Ascent-people do know how to use
> In theory, if I create a Firebird database with IBExpert under
> MS-Windows, is it then possible to use it with a Linux application
> (written in Lazarus), giving it all the right rights, ie without going
> through an IBExpert's script export and re-import into FlameRobin)?
>
IBExpert,
> Database dialect is 1 and changing the column name and the connected
> code is not an option either at the moment, unfortunately.
It might be an option to modify code and compile for your own.
It might be sufficient to modify parse.y by replacing "LOCALTIME" by
some different Name that does
ed by: "Zoran"
>
>
> ++
>
> 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
> the
> I would like to know if someone can help me with the minimum system
> requirements for the Firebird 3.0, specific for Debian distribution.
> Distribution, kernel and so on.
Current stable (buster) does have 3.0.5 in repository.
Oldstable (stretch) does come with 3.0.1 only.
For any older
> I am planning the infrastructure and security and I have several
> doubts. My initial idea would be to have a database where users can
> save their emails and create a separate database for each client.
For an Web-Application this is not really common practice as you prevent
e.g. usage of
> firebird 1.5 linux built is for 32 bits, is it possible to install it
> in a 64 bit linux? Thanks.
As long as your 64Bit Linux does have support for 32Bit and the required
32Bit runtimes are installed it should be possible to install.
>
> 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 ?
I'm using firebird on debian for years - without any problems.
Presumably it
> Is there a way to include a column in a SELECT but substitute a value if
> it doesn't? I need my code to work with different versions of my db schema.
>
> eg I want to SELECT A, B, C, ... but C might not exist.
>
> SELECT * would work of course, except it will fetch a bunch of columns I
>
>
>
> I have a single Linux host server with several Virtualbox guest VM's.
> I've been attempting to move everything possible from the host to one
> of the guests.
>
> One of the last holdovers is Firebird. The reason is I use NFS to
> mount host folders within the guest for critical data -
after some time my fbserver does refuse to open new connections:
> elmar (Server) Tue Jul 11 13:05:36 2017
> Operating system call pthread_create failed. Error code 11
>
>
> elmar (Server) Tue Jul 11 13:05:36 2017
> Database: /usr/local/fbdata/maindb.fdb
> internal
You can define port number in firebird.conf
one of your Installations has to be done from source to get another
install path
> Does anybody know how to have two versions of Firebird running on
> Linux(ubuntu).
>
> I currently have 2.5 on port 3050 and would like to have 3.0 on port 3051.
>
> During my development - only single connection to FB Server, I do a
> lots of query. Each query took about 25-30 secs to complete, but CPU
> Utilization only used at around 16% on my six cores computer.
> On Ryzen 7 with 16 threads, I believe CPU utilization for FB is only 6%.
>
> Are there any
>
> One thing is for sure YOU can't login FACEBOOK with two different IDs
> from the SAME PC at the same TIME.
I would assume that to be true for using une WEB-Browser. It shpild be
no Problem to login with two IDs using e.g. chrome for one and foirefox
for the other and there is nothing
> 1)
> I assume on LInux (Debian based Mint version and an Ubuntu flavor) I
> install a variant of the server (in the repository I find the 2.5
> variants, but I'd be also happy installing a downloaded 3.0 instead).
> Then I need a generic DB manager like e.g. Flamerobin to do general
>
> How can I prevent that my database can be opened with another
> security.fdb.
You can use database encryption for that purpose - without knowing the
encryption key there is no way to access database.
In FB3 there is a new plugin mechanism for encryption added you should
have a look ath that.
> Is it possible to use 2 pc’s with firebird installed, accessing a single
> database that resides in a shared storage area network (which is acessible
> to both servers)?
It cannot be done when both machines have to access database at the same
time.
If you make sure that only one machine has
> So I was looking for the replacement and as it looks to me at the
> moment, I would pick LibreOffice Base as frontend, as I need to create
> forms and reports, and FirebirdSQL 3 as DB engine. (Any comments are
> welcome about my selection being good/bad).
Firebird 3 ist at RC1 state - is your
Hi,
i do have an problem with UNIQUE constraint on FB 2.5.2
Data is in an varchar having Charset win1252 and collation pxw_intl.
Insert is done using an prepared statement.
Writing Data
Amelie
Amélie
does raise an Unique-Error.
Just curious:
- Data comes from an Table having the same UNIQUE
Is there a way to open a databse file on a network share with firebird
embedded?
There is an Config-Option to allow that.
But besides performance degeneration you will get database-corruption
once the database is opened from multiple clients simultaneously.
For this reason opening remote
Am 19.08.2014 um 18:30 schrieb 'Carlos H. Cantu' lis...@warmboot.com.br
[firebird-support]:
Re: [firebird-support] Forced write, page size and buffer size The
best thing would be if someone could simulate some crashes (like power
failure) in both configurations and report back about existence
How do you get the connected users?
I did evaluate isc_database_info to list connected users.
Elmar
++
Visit http://www.firebirdsql.org and click the Resources item
on the main (top)
Hi all,
how can I detect if there are concurrent processes using the same
database on embedded firebird (2.5 Windows).
Enumerating connected users does not word on embedded.
Elmar
++
Visit
How can I setup an embedded database on MacOSX to ignore username and
password on login.
On Windows security2.fdb is not required, how can I reach that on MacOSX
Elmar
++
Visit
1) Are there any adverse conflicts between IB6.5 and Firebird in a
situation like this ... i.e., would running AT against an IB6.5 engine
ultimately damage the data?
As long as the data file is created and accessed by the IB6.5 server
only no damage should occurr.
The Firebird client lib
One question about UDF on 64-bits Firebird server, do I need to recompile
dll's with 64 - bits RAD?? or can I use compiled with 32 bits Delphi 2007
You have to recompile with 64Bit compiler - either Delphi or FreePascal.
Elmar
2) Can 32bit ODBC connect to 64bit installs? Are there any other pit
falls moving from 32bit to 64bit server (our app is 32bit)
Bittnes on client and server can be choosen as needed. In any case your
application requires 32Bit client libs. You can choose bitness of server
as you like (os as
A quick question: are there any restrictions on the (simultaneous) use of
multiple aliases pointing to the same database?
The server does internally resolve aliases at an early stage and calls
the internal open procedure with the regular name afterwards. I would
assume the server to forget
I have a simple app, which needs to run for a few users, written in C#.net.
The users to not have the ability to run an install on their own computers,
so we must install via a simple xcopy.
If the user must not install software it is not an good practise to
install it by xcopy.
Ask the
The client does fetch the resultset row by row. The Time sould be
determined more by the size of result than by the complexity of query.
Is this actually true? I just ran a test, remotely (through an internet
link) connecting to a database on a firebird 2.5 server, and I ran a
wireshark
Hmmm. Can I run a 2.5 server on another port, and access the same database?
One database can only be served by an single instance of FirebirdSQL.
I would gess it to be nearly impossible to make different releases of
classic server run as an single instance.
Elmar
Moreover, I can see that during the delays, the *outbound* link from the
client is clicking over about 1 kbps for the entire period. It *appears* that
the client is dribbling out information that the server is waiting on,
although I can't imagine what it is.
The client does fetch the
I have a question on backup/restore.
Think of a firebird classic on a linux box.
-Do a backup with existing attachments
-After backup, Rename the old gdb file to something else
-Restore the backup file with the original gdb name.
You have to kill all connected clients before starting
i want to do something like
update or insert into mytable(ID, amount) values (123, amount + 100);
how to do this ?
Have a look at
http://www.firebirdsql.org/refdocs/langrefupd21-update-or-insert.html
From with amount of record in a table it's start to be usefull to have
an index ?
100? 1000? 1 ?
Actually i thing about 200 ? maybe 1000 ?
I do remember an general estimation that tables with some few hundred
rows do not need index creation.
To be more specific you also have to
This is probably a stupid question but here goes anyway. I have a Delphi
application that is currently running on FB1.5. I need to move to FB2.5. Is
it necessary to update the FB client on the client PC's from 1.5 to 2.5 or is
the 1.5 client compatible with the 2.5 database?
I have found
There are no problems (like corruption) if the server was power down during
backup?
Since backup is an regular read-operation id should not cause corruption
when an power-fail does happen while backup. The backup file itself is
junk in case of an power-fail.
When I restore the backup at a
43 matches
Mail list logo