> 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
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.
Thanks.
From: firebird-support@yahoogroups.com
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
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
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
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
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
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.
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.
> 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 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.
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
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
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
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
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 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
I would suggest that the best way to prevent anyone getting hold of your
database and opening it with a separate security database is to have good
security & physical protection on your server, limited access to the server
room (if appropriate) and so on. Normal security precautions in other
20 matches
Mail list logo