On 7-4-2016 20:54, Hugo Eyng hugoe...@msn.com [firebird-support] wrote:
> Hello Mark.
>
> I was like you showed 192.168.0.158:C:\DIR1\BASEDIR\MYDATABASE.FDB
>
> Than I changed from FB 32 to FB 64 and it stopped working. After that,
> after that even turnning to FB 32 it doesn´t work using this stru
On 5-4-2016 17:18, tcanfiel...@hotmail.com [firebird-support] wrote:
> I'm trying to set the exclusions for one of our servers and I see
> Firebird running.
>
> I don't have any experience with this program and I was hoping someone
> on the forum could shed some light on the needed exclusions.
>
>
On 7-4-2016 23:01, Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr
[firebird-support] wrote:
> Would you be so kind to provide an example SQL which shows how to do
> primary key with a case insensitive collation?
1. Register the WIN1254_UNICODE collation (it is defined in fbintl.conf,
but not includ
Suggestion
event studies "on connect"
1. an application with minimum rights connects to the database
1 '. in table "mon$attachmnts" field "MON$REMOTE_PROCESS" will record the
application name
2. in the trigger event "on connect" if the user connects SysAdmin, verifies
the application name in "MO
2016. 04. 07. 21:41 keltezéssel, Ann Harrison aharri...@ibphoenix.com
[firebird-support] írta:
> You're thinking of a case where there is a (possibly unstated) referential
> relationship between the table that you're getting fields from and the other
> table in the view. The table you're getting
Thanks for your suggestions.
I am actually searching for another way. This database is part of an
application that is deployed at our customers.
In the new firebird release it is possible to choose security authentication
via external .fbd file or programmed into the database itself.
We want to
08.04.2016 10:12, 'Mueller, Roland (GE87)' roland.muel...@honeywell.com
[firebird-support]
wrote:
> Is there any way to prevent this and only use our authentication ?
No.
--
WBR, SD.
+++
Roland,
the new Firebird 3 per-database security database capability/area is a bit
confusing or perhaps leads to wrong expectations, unfortunately.
When a user database acts itself also as a security database, this does not
mean that you get some sort of embedded user authentication as in Inter
> 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.
08.04.2016 11:32, Elmar Haneke el...@haneke.de [firebird-support] wrote:
> You can use database encryption for that purpose
No. Encryption can protect "cold" database on HDD in garbage collector, for
example,
but not an active one.
--
WBR, SD.
thanks for the replies, a little unrelated question: in this topic what does
the replies with only 'checking' related words mean?
gfix was correctly running, it finished in 2 hours but the database is still
corrupted, i try also with the -full command line argument but it didn't repair
the db.
Hello Mark.
I changed the firebird.conf by another one and restarted the server.
Now my string connection 192.168.0.158:C:\DIR1\BASEDIR\MYDATABASE.FDB is
working.
I compared both firebird.conf and found two differences:
1) In the line near
# Remove protection against opening databases on NF
Hi
What is the best way to go about to find out about this?
I have several projects that are using the FB database and I would like to
cleanup and remove all the indices that are just taking up space and thus
indirectly reduces performance?
Best regards
jardar
08.04.2016 15:17, Hugo Eyng hugoe...@msn.com [firebird-support] wrote:
> Do you know where could I find information about string connections and
> protocols?
In "The Firebird Book: a Reference for Database Developers", for example.
--
WBR, SD.
-
Hi,
Check your database with Database Analyst from HQbird (trial will be
enough) and look at the list of Useless indices (indices with only 1 key
for all values) and Bad indices (with a few keys for many values).
Then, you need to run tracing of your database in action, for example,
with HQB
Hi,
> What is the best way to go about to find out about this?
>
> I have several projects that are using the FB database and I would like
> to cleanup and remove all the indices that are just taking up space and
> thus indirectly reduces performance?
It is not that easy to clearly define the use
Thanks for instructions. It does work.
Is there a way to use created case insensitive collation as database wide
default? It would be easier for me not to specify collation for each and every
index definition.
Thanks.
From: firebird-support@yahoogroups.com
[mailto:firebird-support@ya
Thank you Dimitry.
I have this book. I will search.
Bye
Em 08/04/2016 10:29, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] escreveu:
> 08.04.2016 15:17, Hugo Eyng hugoe...@msn.com [firebird-support] wrote:
>> Do you know where could I find information about string connections and
>
> Thanks for instructions. It does work.
>
>
>
> Is there a way to use created case insensitive collation as database wide
> default? It would be easier for me not to specify collation for each and
> every index definition.
http://www.firebirdsql.org/refdocs/langrefupd25-ddl-charset.html
This d
19 matches
Mail list logo