Hello everybody:
Evidently, as many of you said, the problem was related to the parameter
DatabaseAccess in firebird.conf. The strange thing is that this
parameter was commented. So it should be the predetermined value, which
I think is "Full". Now it is again commented and it is working. It
Good news!!!
With the tip of Neil I found a strange solution. I did the following:
Try to open a database file with IB_SQL. I couldn't.
Restart Firebird service.
Try to open a database file with IB_SQL. I couldn't.
Make a copy of the original Firebird.conf, which has the commented line
base1.Server:=SERVER_ else
IBODatabase1.Server:=PC_NAME; //localhost
if not IBODatabase1.Connected then
IBODatabase1.Connect;
(using SYSDBA and masterkey.. or user)
Best Regards,
MLCVISTA
Le mardi 20 février 2018 16:09:33 CET, Eduardo
guse...@gmail.com [fire
Hello:
I use Firebird 2.1 and in some computers I cannot open a database file
which is in the local hard disk.
For example, let's suppose I have the database C:\Test\MYDATABASE.FDB
and I try to open it with IB_SQL (from IBObjects).
If I use C:\Test\MYDATABASE.FDB I get "unavailable
As you say, that sounds to be related, but unfortunately I found that
line commented as it is by default. Every line related with
DatabaseAccess is commented. I even compared the whole file
firebird.conf with the one in another computer with the same Windows (in
which one I don't have the
In every computers I tried there is exactly the same version of Firebird
installed: 2.1.4.18393 32 bits.
The databases where generated with the same version of Firebird. And
remember that if I use an alias, I can open the database. The problem is
when I try to open it using the path of the
Thanks for your suggestion.
The user have total control of the file and the folder. I can modify it
and even delete it. I tried moving the file to other folders and I tried
with many FDB files. If I copy the FDB to another computer with
Firebird, then I can open it without any problem. So the
Just a little correction to my message. Where I wrote firebird.conf, I
should have written aliases.conf.
Mensaje original
*Asunto: *Cannot open database file in local hard disk
*De: *Eduardo
*A: *firebird-support@yahoogroups.com
*Fecha: *20/02/2018 10:57
Hello:
I use Firebird 2.1 and in some computers I cannot open a database file
which is in the local hard disk.
For example, let's suppose I have the database C:\Test\MYDATABASE.FDB
and I try to open it with IB_SQL (from IBObjects).
If I use C:\Test\MYDATABASE.FDB I get "unavailable
I am not an expert in these subjects. I am just learning. :-)
But that's just what I understood. They recommend to disable disk write
cache when installing SQL Server because of the potential risk of data
loss and they also talk about enhanced caching controller systems which
provide cache
It seems a good idea but I am not the one who configure the server in
this case and I am not sure if they would like to do that. But, if they
do that, can I enable disk cache in a VM that is phisically in the same
disk as another VM which is PDC? The disk cache belongs to the VM or the
There is an interesting (and quite long) article about SQL Server and
disk cache in MS site.
https://support.microsoft.com/en-us/kb/234656
They talk about "enhanced caching controllers" and they say things like
the following:
* /- SQL Server installations are targeted at systems that
Thank you for the link. I read it but they don´t ensure that in a second
disk you can enable write cache. Anyway on this server there is only one
disk.
Mensaje original
*Asunto: *Re: [firebird-support] Bad performance of Firebird in Windows
Server 2012
*De: *'Leyne, Sean'
I know, but that's impossible to do on that server. So the only solution
I found so far is to install the application in another computer.
But anyway I would like to understand why this is necessary in Firebird.
It would be great if anybody knows the answers to my questions of my
previous
No, this is not the solution. One of the firs things I do when I install
my application is to create firewall rules for ports 3050 and 3051. In
this case I even deactivate the firewall but nothing changed.
My english is not perfect, but I can´t write in portuguese!
Mensaje original
I read that disabling forced writes is not safe.
But there is something that I really don´t understand.
If I disable forced writes, then when I make commits, data goes to the
RAM of the server and afterwards, in some moment, the data will be
physically written to the database.
If I enable
Eduardo
Mensaje original
*Asunto: *Re: [firebird-support] Bad performance of Firebird in Windows
Server 2012
*De: *'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]
<firebird-support@yahoogroups.com>
*Para: *Eduardo guse...@gmail.com [firebird-support]
<firebir
-- Mensaje original
*Asunto: *Re: [firebird-support] Bad performance of Firebird in Windows
Server 2012
*De: *'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]
<firebird-support@yahoogroups.com>
*Para: *Eduardo guse...@gmail.com [firebird-support]
<firebird-support@yahoo
Hi guys:
I have an application developped in Delphi that uses Firebird
Superserver 2.1.4.18393.
It is installed in a Windows network. During many years, the server had
Windows Server 2003 and everything worked fine. Some time ago they
changed it temporarily to another PC with Windows 8.1.
I did what (I think is what) you need many years ago. I don´t remember
exactly the details, but this is still working. What I did was the
following:
When my application initiates, it checks if there exists a database
named MYAPPLICATIONCONFIGURACION.FDB. If it doesn't exist, it creates
it.
;firebird-support@yahoogroups.com>
*Fecha: *29/09/2015 04:41
On Mon, 28 Sep 2015 17:51:08 -0300, "Eduardo guse...@gmail.com
[firebird-support]" <firebird-support@yahoogroups.com> wrote:
> Hello:
>
> I have an application developped in Delphi that uses Firebird
> 2.1.
Hello:
I have an application developped in Delphi that uses Firebird
2.1.4.18393 SuperServer.
The application is running well in many enterprises. But there is one
place where there is a problem. They have a server with Windows and 4
client computers with Windows. They have been using the
I am still trying to find a way to unlock a record when the PC that
locked it (using SELECT ... WITH LOCK) hanged...
I thought the following:
The user who executed the SELECT ... WITH LOCK started a transaction.
When his PC hanged, this transaction remains active.
Is there a way to identify
Thank you for your answer.
I agree with you. Firebird should allow for all/any attachment to be
deleted.
Closing the application to unlock the record is not the solution I am
looking for. My problem is when there are many users using the
application, then one of them hangs his PC with a
I add some information to my previous mail. When I try to delete the
record of MON$ATTACHMENTS, the complete message I got is the following:
SQL ERROR CODE:-817
SQL ERROR MESSAGE:
The insert, update, delete, ddl or authorization statement cannot
be executed because the transaction is inquiry
I tried what you said doing the following:
- Opened my application.
- Executed the option which locks a record (executes a SELECT * FROM
TABLE1 WHERE (FIELD1 = 'some value') WITH LOCK).
- Opened the database with IB_SQL.
- Identified the record of MON$ATTACHMENTS table associated with my
there isn't
much one can do about it.
Best,
Carlos
On 20/01/2015 17:49, Eduardo guse...@gmail.com [firebird-support] wrote:
Hello:
Yesterday I sent an e-mail to the list but I didn´t receive it. I
received other mails from the list but didn´t receive my own message.
Today I received an answer to my
I looked in a database, and in MON$STATEMENTS tabla I have the following
fields:
MON$STATEMENT_ID
MON$ATTACHMENT_ID
MON$TRANSACTION_ID
MON$STATE
MON$TIMESTAMP
MON$SQL_TEXT
MON$STAT_ID
How can I detect which is the record I have to delete to unlock my
record? This is the only table I have to
Hello:
Yesterday I sent an e-mail to the list but I didn´t receive it. I
received other mails from the list but didn´t receive my own message.
Today I received an answer to my message and I sent a new mail. Again I
didn´t received my own message.
I am subscribed since many years ago but I
Hello:
I have an application in Delphi that uses Firebird 2.1 SuperServer. For
some operations I use a SELECT like the following:
SELECT * FROM TABLE1 WHERE (FIELD1 = 'some value') WITH LOCK
As you can see, I use WITH LOCK to lock the record. Then, when the
application executes a commit or
30 matches
Mail list logo