Re: [firebird-support] Re: Cannot delete Firebird database file as it is in use by the application..

2020-03-11 Thread Steve Naidamast blackfalconsoftw...@outlook.com [firebird-support]
Thank you very much for all your replies. I will try the "Clear Pools" option with the Firebird ADO.NET provider first. If that doesn't work, I have come up with the idea to start a small, external process that will check for the release of the file by the application and then delete it... Tha

[firebird-support] Re: Cannot delete Firebird database file as it is in use by the application..

2020-03-10 Thread Steve Naidamast blackfalconsoftw...@outlook.com [firebird-support]
Hello... I am developing a security extension, which is used as a loaded assembly to my main application, all of which use the Firebird Embedded Edition 2.59 for my application's database. As part of my security processes, I compress the file upon exiting the application. When the compression

Re: [firebird-support] Re: Securing Firebird Embedded database

2019-12-20 Thread Steve Naidamast blackfalconsoftw...@outlook.com [firebird-support]
Elmar... My current concept for making a Firebird Embedded Edition somewhat secure without a password (and as you say, using password means little if people already know a database;s internal structure) is to offer two levels of encryption. The first would be using DotNetZip to compress and en

Re: [firebird-support] Re: Securing Firebird Embedded database

2019-12-20 Thread Steve Naidamast blackfalconsoftw...@outlook.com [firebird-support]
bject: Re: [firebird-support] Re: Securing Firebird Embedded database On 2019-12-18 16:30, Steve Naidamast blackfalconsoftw...@outlook.com [firebird-support] wrote: > Is there any way to secure the FDB file from unauthorized access > (other than compression and encryption, which I am

Re: [firebird-support] Re: Securing Firebird Embedded database

2019-12-20 Thread Steve Naidamast blackfalconsoftw...@outlook.com [firebird-support]
Elmar... Thank you for your reply regarding protecting a Firebird Embedded Database. However, why is it assumed that a database file that is stored locally cannot be breached by unauthorized access? Given the nature of sophisticated security breaches and hacking endeavors today, such data file

[firebird-support] Re: Securing Firebird Embedded database

2019-12-18 Thread Steve Naidamast blackfalconsoftw...@outlook.com [firebird-support]
Hello... 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? Thank you... Steve Naida

Re: [firebird-support] oracle numeric conversion (22).

2019-12-10 Thread Steve Naidamast blackfalconsoftw...@outlook.com [firebird-support]
Hi Dimitry... Is it that we can no longer reply to messages on the Firebird Yahoo Group? I went there to ask about FB 4.0 and I could see all the messages but there were no reply options. As to what I was trying to respond to, you note in your message below that you would recommend FB 4.0. H

Re: [firebird-support] Problem returning multiple rows from a CTE-recursive procedure

2018-05-04 Thread Steve Naidamast blackfalconsoftw...@outlook.com [firebird-support]
Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] Sent: Friday, May 4, 2018 12:25 PM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] Problem returning multiple rows from a CTE-recursive procedure 04.05.2018 18:13, Steve Naidamast blackfalconsoftw...@outlook.com [firebird-supp

Re: [firebird-support] Problem returning multiple rows from a CTE-recursive procedure

2018-05-04 Thread Steve Naidamast blackfalconsoftw...@outlook.com [firebird-support]
Dimitry ... Thank you for your reply... 😊 However, I am not sure about the multiple "SUSPEND" statements on a per-record basis. If you look at my procedure below, you will note that there is only a single "SUSPEND" statement. Yet, all of the rows for the entered date that is used to exec