e firebird-supp...@googlegroups.com
Note, if you are subscribed to more than one Firebird-related Yahoo!
group, your will need to go through a similar process for each of your
groups.
Helen Borrie
for Firebird Project
--
This email has been checked for viruses by AVG.
https://www.avg.com
l script, if you installed from
the official Firebird kit.
Helen
>
> Kind regards,
> Yassir
>
>
>
>
>
--
Best regards,
Helenmailto:hele...@tpg.com.au
---
This email has been checked for viruses by AVG.
https://www.avg.com
_IP) is preferred, however, as WNET is notoriously noisy. You
must set up the Protocol and DatabaseName properties as appropriate to
each other and to the transport you want to use. If you get it right
on the application side, Fb3 should be able to sort it out on the
server side.
Helen
---
This email has been checked for viruses by AVG.
https://www.avg.com
-)
BTW, sweeping is not garbage collection. It is a process that marks
old record versions for GC, which will be carried out subsequently by
a GC worker thread (on Superserver) or by cooperative GC, or both,
depending on how your GCPolicy is set up in firebird.conf. GC happens
automatically, one way or another. A gbak backup also causes
cooperative GC, unless you run gbak with the -[no_]g[arbage_collect]
switch.
Helen
---
This email has been checked for viruses by AVG.
https://www.avg.com
there is something else that make
> Firebird runs slower on Windows 10.
It is worth reading this:
http://dyemanov.blogspot.com/2012/03/firebird-vs-windows-file-system-caching.html
Helen
---
This email has been checked for viruses by AVG.
https://www.avg.com
Rita Liotta wrote:
> Hi, Helen:
>
> Can you name some of these tools? I'm just floundering try to find one.
>
Only you can know what you need, according to your expertise with
databases and SQL and your comprehension of the drivers needed to use
a particular toolset. As
ately, though, some sort of driver connects to the Firebird API and
the Firebird API manages the connection of the database to the
Firebird engine. There is no workaround to avoid having the Firebird
engine in some form at the back end.
Helen
---
This email has been checked for viruses by AVG.
https://www.avg.com
;s not
going to work for them. GTTs didn't come on the scene till 2.1. Also,
it won't work in 2.1 +, either, if you have not upgraded the ODS of
the databases to 11.1 or higher.
Helen
---
This email has been checked for viruses by AVG.
https://www.avg.com
ot as to whether sweeping before the
backup, thus taking the GC out of gbak's hands, would gain you
anything in terms of the time this housekeeping would take.
Helen
---
This email has been checked for viruses by AVG.
https://www.avg.com
cols.
You are not the first to bump into this with Fb3. Last year, Vlad and
I put together a tech topic on the subject. In case you want a bit
more information, here's the URL:
https://www.ibphoenix.com/files/ConnectionStrings_Fb3.pdf
Cheers,
Helen
---
This email has been checked for viruses by AVG.
https://www.avg.com
lient.dll in the same directory where the
client application executable is located, to ensure that Windows will
find it first and not seek it out via the PATH variable.
Helen
---
This email has been checked for viruses by AVG.
https://www.avg.com
tion is visible only within the EH
block and, of course, only if an exception actually occurred that
threw execution into the EH block.
Nowhere does it suggest that you could expect anything by trying to
use the function in DSQL.
Helen
---
This email has been checked for viruses by AVG.
https://www.avg.com
right way to remove himself from the group.
Helen (Moderator)
---
This email has been checked for viruses by AVG.
https://www.avg.com
eate_database] switch.
Meanwhile, at some point during thos two days, after someone had
inserted some data into database1.fdb, someone else came along and
renamed the database to database_2. Gremlins, maybe?
Helen
---
This email has been checked for viruses by AVG.
https://www.avg.com
ASON || ||'",'
'"'|| SITENUM ||'",'
'"'|| REPLICATED ||'",'
'"'|| WORKSTATION ||'"'
FROM MACROLOG
WHERE TIMEREF >= (CURRENT_DATE - 7)
ORDER BY TIMEREF
Note, if TIMEREF is a TIMESTAMP, not a DATE, then your varchar for the
cast will need to be varchar(25).
If this isn't what you are looking for, come back with some more
detail about the expected output, environment, etc.
Helen
---
This email has been checked for viruses by AVG.
https://www.avg.com
it yourself?
Another factor could be that the backup was from a database with
on-disk structure (ODS) 11.0 or older being restored to ODS 11.1 or
higher. You may need to include the -fix_fss_M switch to have text in
metadata (such as CHECK constraints) converted to unicode_fss.
Helen
---
This email has been checked for viruses by AVG.
https://www.avg.com
to try and do a custom Firebird install for
your early testing. Just unzip the whole thing and then go back later
and get rid of the pieces you don't need.
Helen
---
This email has bee
n different Windows versions if the service was configured the
same way on each server. Of course, we are talking about the
Professional versions, not Home, etc., that do not support services.
I don't know whether this answers your question, though.
Helen
---
This email has been checked for viruses by AVG.
https://www.avg.com
instsvc i -s -d -n "FirebirdServer - firebird3"
(you don't need the double-quotes if the name has no spaces.)
Helen
---
This email has been checked for viruses by AVG.
https://www.avg.com
thing to try
during some time when the table isn't in use. It would be worth
considering how long it has been since the last backup-and-restore
cycle, too.
Cheers,
Helen
---
This email has been checked for viruses by AVG.
https://www.avg.com
ile/documentation/reference_manuals/fblangref25-en/html/fblangref25-ddl-tbl.html#fblangref25-ddl-tbl-gtt
Helen
---
This email has been checked for viruses by AVG.
https://www.avg.com
Steve Naidamast wrote:
> By using a global table in Firebird, could not multiple users cause
> a conflict if two such users were to issue the same query against the global
> table?
No. A GTT definition is persistent, of course, but persistent data
are not stored in it. A GTT instance is created
g the PSQL code you saved.
If you are using Firebird prior to Fb3 then GET THE MESSAGE that you
should **NEVER** try to modify the system tables. From FB3 onwards,
those tables are read-only but with older versions you can still shoot
yourself in the foot.
Helen
---
This email has been checked
Mark wrote:
> On 20-1-2019 22:35, Helen Borrie hele...@iinet.net.au [firebird-support]
> wrote:
>> Firebird 3 allows configuration at both client and server for some
>> parameters, including these two. Changes to these parameters must be
>> done at the client side for you
once
aliases.conf is saved, whereas anything reconfigured in firebird.conf
will necessitate a server restart before it is visible.
You can find more details in this article:
https://www.ibphoenix.com/files/Authentication_FB3.pdf
Helen
---
This email has been checked for viruses by AVG.
https://www.avg.com
If not can I raise this as an issue?
You can raise it as an issue by requesting an improvement at
http://tracker.firebirdsql.org.
Helen
---
This email has been checked for viruses by AVG.
https://www.avg.com
m your login with
the role. In Fb 4 beta 1, a user with the GRANT ADMIN ROLE (SEC$ADMIN TRUE)
does not need to log in with the RDB$ADMIN role. I don't know whether this
is going to be backported to Fb 3.0.5.
Helen
---
This email has been checked for viruses by AVG.
https://www.avg.com
s much information
there as you can.
and
2. Subscribe to firebird-devel list - you can do it from this page:
https://www.firebirdsql.org/en/mailing-lists/ (scroll down) for
discussion of your ideas.
Helen
---
This email has been checked for viruses by AVG.
https://www.avg.com
>This seems to do nothing. I have tried looking through the PhP.ini
>file for some way to influence how the data is formatted and cannot
>find anything. I have even tried using ..
>
>ini_set('date.timezone', 'Europe/London');
>
>But this also did nothing.
I hope you understand a bit more now about what's going on in these
interfaces. Good luck.
Helen
---
This email has been checked for viruses by AVG.
https://www.avg.com
ert it now, but please be
mindful of this for future discussions.
If it is not directly a support topic, then please take it to
firebird-general.
If it is a technical question about a feature in a future release,
including alphas and betas, take it to firebird-devel.
Helen (Moderator)
---
This
Hello Mark,
Tuesday, October 30, 2018, 8:20:51 AM, you wrote:
> On 29-10-2018 02:06, Helen Borrie hele...@iinet.net.au
> [firebird-support] wrote:
>> Character set NONE is a bare-bones ASCII set and does not provide
>> intrinsic support for any characters beyond the 1
ith Unicode
characters, while your database can only make sense of US ascii.
> Is this a bug or simply something I don't understand?
Well, it isn't a bug. ;-)
Helen
---
This email has been checked for viruses by AVG.
https://www.avg.com
Dominik,
>> Which sub-release?
> The latest, i.e. 2.5.8.27089
OK.
>> Yes. The symptoms suggest you have a large number of record versions
>> that are waiting for garbage collection. New records cannot be
>> written to existing pages until after that garbage has been cleared.
> This makes sense
Dominik Psenner wrote:
> we are observing an interesting issue and hope for interesting
> insights what could cause the symptoms. First of all a few numbers
> about the database and the firebird instance in question:
> · Database contains several hundred tables
> · Few tables co
jonatan.laurit...@yahoo.dk wrote:
> Sometimes I need to write extended error message from the SQL
> procedure and trigger code. So far I have used the following procedure:
> create or alter procedure REPORT_ERROR (MSG varchar(400))as
> BEGIN
> update rdb$exceptions set
> rdb$message=:MSG
fabia...@itbizolutions.com.au wrote:
> I've noticed the following strange behavior on Firebird 3 latest
> release, 64 bits, on Windows 2012, 24 processor server, 200 GB ram, magnetic
> HDDs (no SSDs):
> 1) After executing and commiting a massive delete on a table, any
> select or insert takes ti
antoedinchar...@gmail.com wrote:
> Have planned the upgrade of FB, and the works are going on.
>
Firebird 2.5.2 to Fb 2.5.8 is not an upgrade you have to plan. It is
a point release, i.e., the same software with patches. You need to do
this. Just keep safe copies of security2.fdb, firebird.conf
antoedinchar...@gmail.com :
Not enough information. What version of Firebird are you using?
> I am trying to GRANT edit/recreate procedures for manager level
> users and blocking the same from normal users.
Explain exactly what you mean by "manager level users".
> I was able to do the same in
is the purpose of a RDBMS. Apparently, you want to follow
the spreadsheet model, in which a single set of data is exclusive to a
single application. So - you maintain multiple instances of the same
data by hand and say your prayers.
> From this my problem is born, but I can change my formulations.
> I need to think.
If you are unfamiliar with the ACID rules and normalization, look them up.
Helen
---
This email has been checked for viruses by AVG.
https://www.avg.com
gt; months, and I've not experience: I now plan the job to develop, later I
> will verify the new releases.
The question of whether you use 2.5 or 3.0 is not relevant to your
problem. Spend some more time understanding how a relational database
works - and forget your preconceptions from previous work you have
done using spreadsheets or fiel-based data storage systems.
Helen
---
This email has been checked for viruses by AVG.
https://www.avg.com
meddling with the values of
generators, you are making a bed of nails. Incidentally, there *are*
ways to turn back generators so, theoretically, you could "re-use" a
missing value. In practice, you must not try to.
Helen
---
This email has been checked for viruses by AVG.
https://www.avg.com
,
user/group permissions, network configurations and text editors, along
with the bash shell and some system tools at the command-line level.
Helen
---
This email has been checked for viruses by AVG.
https://www.avg.com
brary of the Firebird web site. You might want to
pick up the Mac version of Flamerobin at some point, if you prefer a
graphical interface.
Hope this helps. Use this list if you bump into something that
doesn't seem to work properly for you.
Helen
>
>
>
list compared
to this one but I'm still having to moderate subscribe requests and
first posts.
Let's suppose that River's post yesterday put a fairly accurate finger
on the current problems. Let's weather it for a week or two and see
how things shake out.
Helen
---
This email has been checked for viruses by AVG.
https://www.avg.com
to their own servers. There's also the activities of
U.S.-based list providers having to become compliant with the EU
privacy laws by the July 30 deadline. It's probably a mix of
circumstances.
Helen
---
This email has been checked for viruses by AVG.
https://www.avg.com
s granted to
PUBLIC. This isn't something you should do with a real-life database,
though.
> Can you possibly help me or point me in the right direction?
If you don't know the db owner's credentials then log in as SYSDBA.
If you post again, would you please exclude all the c
wobble...@yahoo.co.uk,
> is there a good and up to date official source of documentation on
> firebird.conf
The firebird.conf file itself, version current for the Fb version you
are using. You won't get more up to date than that anywhere.
For Fb3, which allows per-database config for a lot of
pa
e...the older code to
truncate out anything following a space (i.e., assumed to be the
now-invalid allocation size) was gaily truncating forward from the
first space in the directory name itself. (That was an amazing piece
of searching that dug that up!)
Helen
---
This email has been checked for viruses by AVG.
https://www.avg.com
> 27.07.2018 21:41, Helen Borrie hele...@iinet.net.au [firebird-support] wrote:
>> I don't know where you got the idea that you could specify the size of
>> a temp directory.
Dmitry replied
>It is an Interbase feature.
Uh...ok... @_@
If you want to allocate specif
ou can consider
having a dedicated disk, such as a fast SSD, for TempDirectories.
The engine holds the temp file structures in RAM if it can: it only
puts them to disk if available RAM is too low. Hence, allocating a
RAM disk for TempDirectories doesn't make sense, either.
Helen
---
This emai
question there:
https://groups.google.com/forum/#!forum/firebird-net-provider
Helen (Moderator)
---
This email has been checked for viruses by AVG.
https://www.avg.com
e anything in there, you need to restart the Firebird
service for it to take effect.
Helen
--
Kind regards,
Helen Borrie
---
This email has been checked for viruses by AVG.
https://www.avg.com
Vishal Tiwari wrote:
> It's urgent...
> We are facing a database performance issue. Currently, we are using firebird
> version 2.5.2 ODS 11.2.
> If we try to run a simple SQL i.e. Select * from using
> FlameRobin, it is taking time and next time the time span increases.
> Same happens from all o
> Also, apparently, this is not a blanket restriction, since I can
> successfully run the UPDATE RDB$PROCEDURES on at least 1 other
> converted DB (that is essentially the same as the DB I cannot runthis
> UPDATE on).
Smells like a privileges problem. The updater has to be SYSDBA,
Mark wrote:
> The problem I have with this solution, is that when using a Firebird
> database, you shouldn't be accessing a Firebird dstabase through a
> share, and Firebird should disallow that by default.
And it does. It would require RemoteFileOpenAbility to be true. By
default it is fals
Eduard Calveras wrote:
> Since few days ago, after Windows 10 update, some applications
> writes in Delphi can not connect to network Firebird 2.5.5 server.
> These applications can connect with BDE, InterBase, FIB, FireDac... but all
> are using the GDS32.dll
> In other side, applications as F
Karol Bieniaszewski wrote:
> when we create dommain we can do:
> CREATE DOMAIN XXX TYPE VARCHAR(50) COLLATE PXW_PLK;
>
> but how to alter this domain to have still collation?
>
> ALTER DOMAIN XXX TYPE VARCHAR(150) COLLATE PXW_PLK;
>
>
> Engine Code: 335544569
> Engine Message :
> Dynam
Steve Naidamast wrote:
> I am using the Firebird 2.5 Embedded Edition with the Firebird
> ADO.NET provider version 5.5 or 5.7. I am not sure which, since it
> has been so long since I set up the references for my project and
> the assembly being used is not taken from the actual provider
> librar
fo...@darsys.com.ar wrote:
> Hi
> Since few hours ago, in some customers after Windows 10 update, my app can
> not connect to server.
> Fb server works, and clients with previous Windows versions work.
> Error; 8004 - Unable to complete server request to host...
As far as I can see, error 800
Hello m.wentingm...@othmerding.de,
You wrote:
a question about a function in the ODBC driver.
This is the wrong forum (database support).
For your ODBC driver questions, subscribe to the firebird-odbc-devel
list.
Send an email to this address:
firebird-odbc-devel-requ...@lists.sourceforg
is aware of the current size if the table and may be
able to make dynamic adjustments that your static plan cannot take
into account.
Hth.
Helen
se notes closely to see how things
work now.
> Or has Firebird Embedded Edition reached a level of maturity that
> it requires no further development at this time?
Embedded always was one choice from four server models. That has not
changed.
Helen
acgomes2...@yahoo.com.br wrote:
> select
> A.Codigo
> 'DINHEIRO' FORMA_PAGTO
> FROM NF A
> where A.dataEmissao between '01.01.2018' and '31.01.2018'
> and A.Modelo = '55'
This should work fine if you place a comma after A.Codigo. It does
not make any sense to ORDER BY 2 (nor ORDER BY 1,2)
Hello Todd,
Todd Brasseur wrote:
> Having Issues with 'create user' with Firebird 3.0
> It works fine on one computer where we are testing but not the other.
> We think we did the same thing on both computers.
> Installed Firebird
> Created SYSDBA Account
> Created PRIVATEADMIN Account
> Gr
Also, I don't know
whether your IBDAC components are aware of the restriction on multiple
edits. It is probably something you should ask Devart.
Helen
eAccess parameter with the RESTRICT argument. Don't forget
that you have to restart Firebird after changes to firebird.conf or
databases.conf.
Helen
Saturday, March 3, 2018, 3:20:25 PM, DougC wrote:
> Very glad this got done! Thanks to everyone who made it possible.
> However, the PDF option yields a 404 error.
Fixed - sorry!
HB
The Documentation team is proud to announce that the Firebird 3
Developer's Guide, by Denis Simonov, is now available in English:
https://www.firebirdsql.org/en/reference-manuals/#fbdevgd30
This volume consists of chapters that walk through the development of
a simple application for several lan
> 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 u
Hello Arnaldo,
Friday, February 16, 2018, 2:19:19 AM, Arnaldo wrote:
> maybe i have always misunderstood the garbage collection mechanism, the
> sweep interval, etc.. and i'm realising only now, but:
> I have this database (Firebird 3.03 SuperServer x64)
> My question is : why garbage collection
Ed Dressel wrote:
> Any suggestions?
>
Several days ago, you wrote:
> We are in the middle of letter our users upgrade their database from
> 1.56 to 3.x at their will. Users can upgrade when they want to--so
> we install 1.56 embedded db as gds32.dll and 3.x as fblcinet.dll in
> the same directo
> Your last advice concerns me a bit. Is it also valid for
> changing stored procedures or triggers ?
As an abiding principle - yes. But, for SPs and triggers, the effect
varies according to a few factors. The BLR for these modules is
cached on first use. Changes conducted whilst the m
at
> http://www.ibphoenix.com/resources/documents/
> ++
> ----
> Yahoo Groups Links
--
Kind regards,
Helen Borrie
anything. Implicit casting casts
non-integer numbers as double precision. Any operands that are
database columns are not cast implicitly - they use the type defined
for them.
Helen
, if you have uncommitted inserts to a referenced table in
one transaction, then those uncommitted records are not visible to a
transaction that is trying to insert into the detail table.
Note that isql does not autocommit DML statements.
Helen
ue again.
Of course, you don't want the trigger to fetch another new value and
overwrite the one you reserved, so you must make your BI trigger
detect whether the INSERT command supplies a value.
Helen Borrie
Hello LtColRDSChauhan,
The net-provider list that you have been posting to on Sourceforge is
inactive. Any postings there are ignored.
You need to go to this URL:
https://groups.google.com/forum/#!forum/firebird-net-provider
and join the "new" group. It has been "new" for more than two months
Tuesday, November 28, 2017, 12:06:27 PM, Justis wrote:
>I’m running firebird 3.0; I’m not sure what version of firebird the database
>files were generated with.
You can find out, using another command line tool. Open a command
shell and go to the Firebird root directory.
Then do
gstat -h d:\
Monday, November 27, 2017, 11:35:47 PM, Justis wrote:
> I’m running the latest version of Firebird on my windows PC, and
> I’ve got some .fbd files on my F:// Drive.
> I’m trying to connect to them via Firebird’s JDBC driver, but I’m getting
> absolutely nothing.
The JDBC driver is that - a dri
he old CHM help file in the \help\2004 subdirectory of your
ODBC installation. If you encounter problems, please subscribe to the
firebird-odbc-devel list on Sourceforge and present your question
there. Firebird-support is for database-related questions, not drivers.
Helen
t in the system32 subdirectory. I don't
know why it is omitted from the Fb3 kits.
Helen
queries in LIKE argument used string with national
> characters (in this case - WIN1251)
The difference between the two results confirms that transliteration
is healthy when you provide a valid argument for LIKE, i.e., provide a
wildcard character.
If you wanted to pass a query like that, you should use STARTING
[WITH]:
select * from TABLE1 where FIELD1 STARTING WITH 'абв';
Helen
ourse...but on the surface it looks as if you would
better serve your need by using a DSQL statement directly, rather than
trying to bury it in a SP. Or you could define a view, which would be
unordered, and supply the order by clause when selecting from it.
Helen
y horribly old. I always install
from our own tar.gz because it just works, it's the latest sub-release
and I don't get files being spread all over the system.
Helen
stalled an old fbclient.so in its WD. So
check that as well.
I strongly recommend that you study the two PDF books in
/opt/firebird/doc. There you have the Quick Start Guide and the
release notes. Our release notes are very detailed.
Helen
Hello Hamish,
Thursday, October 5, 2017, 4:53:24 PM, you wrote:
[...] all that
Have you considered trying a symbolic link?
https://www.howtogeek.com/howto/16226/complete-guide-to-symbolic-links-symlinks-on-windows-or-linux/
reference by statements affecting the application database.
If your problem is caused by (2), I think you will need to isolate
your CREATE USER statement(s) into a different SP, to be run and
committed in a separate transaction, before you run the script
assigning the permissions in the application database.
Helen
Hello Allan,
Tuesday, October 3, 2017, 1:02:48 AM, Allan Jardine wrote:
> In the mean time I've tried installing the Firebird package from
> dnf (I actually tried this first and have just tried it again). It
> appears to install okay, but then any interaction I try to make with
> the database I g
ompany in
Texas, U.S.A. If you are able to eliminate network faults then your
only option is to contact their software support, giving a better
description of the problem than the one you provided here.
Helen
lation mode. In other isolation modes, long-running
transactions in both READ ONLY and READ WRITE will block GC and evade
sweeps.
Helen
that the engine needs pages for other things besides data -
it maintains index pages, blob pages, etc. Once a page has been used
as one type of page (data or index or blob) it cannot be reused for
another type of storage. So some of your operations could be
consuming quite a lot of new pages and this is not an unhealthy sign,
either! ;-)
Helen
ail in Chapter 9 of The Firebird Book Second Edition eBook. The
same in hard copy is in Chapter 8 of TFB2e Volume 1 (Firebird
Fundamentals).
Helen
bit" is mentioned there, then it's a mistake.
It is a mistake. It has been corrected in the online notes.
Any more discussion about anything in the Fb 4 Alpha, please take it
to firebird-devel.
^heLen^
BA.
So apparently you're not bothered by vulnerabilities. Actually, if
you were, you would not even consider using UDFs.
Helen
fbclient.dll in the
\bin\ directory there will not work with 32-bit clients. You can
extract the 32-bit client from the \bin\ directory of the 32-bit zip
kit.
Helen
And this is not a trivial problem. I have spent days trying to
> remove UDFs from my existing 2.5 version databases, and it is not an easy job.
Well, it's hard to help with a solution to your non-trivial problem if
you provide only a trivial account of what goes wrong.
Helen
database is located). RESTRICT will work, too, if d:\databases is
included in the list of allowed directories.
Don't forget that any changes you do in firebird.conf will take effect
only after restarting the Firebird service.
Helen
no?
The notes say "...starts up via init/systemd..." which means one or
the other. You're in trouble if your system does not use either one.
;-)
And no more Fb 4 questions here, please.
^heLen
.
Those files will go to disk and you simply might not have enough disk
space available.
Note, too, that on a VM it is strongly recommended that you configure
TempDirectories explicitly and not rely on a preconfigured temp or tmp
directory that might be missing or shared by greedy apps.
Helen
ase.
But if the dependency is as I described it, then the FK should be in
Unites, referencing the PK in Location. And - simply - never allow
NULL to be written to a constraint element.
AFAIR, Firebird follows some standard that allows one record with one
NULL element, so with your 3-element key, you have the potential to
have three useless reference records. It's one of those cases where
"just because you can does not mean you should".
Helen
1 - 100 of 563 matches
Mail list logo