Try to create role SYSDBA in your database, then You prevent SYSDBA to connect
to database.
Tom
--- In firebird-support@yahoogroups.com, trskopo trskopo@... wrote:
Dear Thomas Steinmaurer,
Thanks for your reply.
I don't give SysDba password to users, but since Firebird is freely
Hi, we have a problem updating metadata (running sql update in java code via
JDBC but it appears to be an engine issue). We need to run a metadata update
for 100's of sites and the following problem appears to occur for all
databases we have used in testing.
We have a table 'Person' in
--- In firebird-support@yahoogroups.com, Thomas Steinmaurer ts@... wrote:
I'm using Firebird 2.5 with Database Workbench V4.1.2. Perhaps it is a
minor niggle in FlameRobin?
Thanks Thomas and Milan
Hope to have an update of FlameRobin soon
Kind regards
Bhav
Is there a way to see which savepoints currently exist? I'm trying to
troubleshoot a project w/FB 2.5 and figure out where a savepoint is
vanishing.
Thanks in advance!
-Mike
[Non-text portions of this message have been removed]
How can I make this SQL execute faster? 2.5 seconds is way too long.
To solve the NATURAL (Slow) access of records via SELECT, I usually just create
some appropriate indexes and retry, until FB is fast-as-lighting again. Some
how, I'm tied up with this SQL which I cannot seem to get going
Why do you left join to JET_SAV_PNT? I would do a regular join from JET to
JET_SAV_PNT and then if you need a left join to JET_FLD_NMS so be it. Your
where clause indicates that you always expect a value in JET_SAV_PNT so just
get rid of the left join for that table.
-steve
--
Steve Wiser
We are experiencing a very strange behaviour with FB 2.1, we have a DB with
just 1 table, and 1 SP to update the table. There are very few records on the
table, and we run updates on it every minute. We noticed the DB size keep
growing at about 10 to 20 mega per day. From memory in 1996
I have a firebird table that I am trying to open in Access.
The field type is 'double precision' and when there is decimal places in the
table ($$.CC) an 'error' occurs for the whole line.
When there is no decimal ($$) the table opens with no 'error's.
Can someone please help?
Are you using