Re: [firebird-support] Re: Cannot open database file in local hard disk

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

Re: [firebird-support] Re: Cannot open database file in local hard disk

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

Re: [firebird-support] Cannot open database file in local hard disk

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

[firebird-support] Cannot open database file in local hard disk

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

Re: [firebird-support] Re: Cannot open database file in local hard disk

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

Re: [firebird-support] Re: Cannot open database file in local hard disk

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

Re: [firebird-support] Cannot open database file in local hard disk

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

[firebird-support] Re: Cannot open database file in local hard disk

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

[firebird-support] Cannot open database file in local hard disk

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

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

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

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

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

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

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

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

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'

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

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

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

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

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

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

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

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

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

-- 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

[firebird-support] Bad performance of Firebird in Windows Server 2012

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.

Re: [firebird-support] Writing to Aliases.conf in non-admin mode

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.

Re: [firebird-support] firebird service terminated unexpectedly

;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.

[firebird-support] firebird service terminated unexpectedly

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

Re: [firebird-support] Unlock record

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

Re: [firebird-support] Unlock record

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

Re: [firebird-support] Unlock record

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

Re: [firebird-support] Unlock record

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

Re: [firebird-support] I don´t receive my messages

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

Re: SV: [firebird-support] Unlock record

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

[firebird-support] I don´t receive my messages

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

[firebird-support] Unlock record

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