Myles Wakeham wrote:
> The issue is with one very large table that contains about 900,000
> rows. This table is used as a temporary stora ge of data that is
> loaded every 24 hours from a CSV file, via an external program. The
> loading takes about an hour to run, but works reliably. We are no
Steve Naidamast wrote:
> However, could you clarify what you mean between a session or a transaction?
Session == connection
I guess you know what a transaction is.
You can define a GTT with a life that lasts as long as the transaction
in which it is instantiated, i.e.,
CREATE GLOBAL TEMPORARY T
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
luisalej...@hotmail.com,
> how can I change a trigger that I create with RDB $ SYSTEM_FLAG = 1.
You can't. RDB$SYSTEM_FLAG is an internal setting and, as you have
discovered, trying to set it yourself by modifying the metadata table
has corrupted the metadata.
> He believes it in this way so as
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
Michael Fox wrote:
> It’s the default package of firebird-dev 3.0.1.32609.ds4-14 on
> Stretch which doesn’t work.
Ancient. Current sub-release is 3.0.4. Given that there were some
humps and bumps in the early releases, you might well be encountering
bugs that have since been fixed.
> The previo
Thursday, January 10, 2019, 2:10:46 PM, John Frankland wrote:
> Hello Firebird support,
> Are there any plans on the horizon to digitally sign Firebird
> executables, installers etc.?
This is the wrong list to ask this question - do it in
firebird-de...@lists.sourceforge.net.
> If not can I rais
Bryan,
Maybe something in here will provide that ah-haa moment. ;-)
C:\Programs64\Firebird_3_0_embedded>isql employee -user sysdba
Database: employee, User: SYSDBA
SQL> show version;
ISQL Version: WI-V3.0.4.33054 Firebird 3.0
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version
Rudi Feijó wrote:
> We have been trying to optimize one of our largest databases (firebird
> 3.0.4) , and in doing so, we managed to greatly improve the execution of one
> specific query by manually changing the PLAN.
>
> I am wondering if the firebird team is interested in receiving detailed
i...@synapsesoftware.co.uk wrote:
>I use Firebird primarily with Delphi and have had no problems with
>using and displaying dates (suitable for my country - UK.)
First thing to understand is that Firebird does not store dates
as strings. It can recognise string inputs for dates according
All,
Please be reminded that the firebird-support list is for topics that
are about your questions or problems concerning your work with
released versions of Firebird.
The recent thread "Firebird vs. PostgreSQL" should have been launched
in firebird-general. It's too late to divert it now, but
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
Steve Boyd wrote:
> I have a database that is configured with CharSet = None.
> My clients access it with CharSet = UTF8. I would not actually have
> know this if I hadn't started digging into this problem. My
> assumption was always that the clients were CharSet = None but
> something in the
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
Antonio,
> I don't understand as you have been able to believe that I have treated
> a database as was a spreadsheet!!! I know what is a table, a database
> (database as "set of tables", database as "file of type database"), a
> relation, a key, an inedex, a... I've studied on your book.
> When
Antonio,
> I'm agree with you: all tables in a unique firebird file is the best choice.
> My problem is that I've numerous programs that utilize one firebird file
> each.
That problem is easy to solve. Place all of the tables in one
database and use an alias for that database in every applicati
Lester wrote:
> On 03/09/18 07:29, 'Christian Giesen' ch...@xt.co.za [firebird-support]
> wrote:
>> NextInvNo = (SELECT MAX(INVOICE_NO) FROM INVOICE) + 1;
> Christian ... there was many years ago a very nice article on this very
> problem.
I think this is the article Lester was referring to:
karen_den...@ymail.com wrote:
> Following the Quick Start Guide's instructions on pg. 26, I typed the
> following into isql:
>
SQL>> connect xnet://employee user sysdba password mynewpassword;
> And it responded, thus:
> Statement failed, SQLSTATE = 08006
> Unable to complete network request
kam3...@gmail.com wrote:
> I downloaded Firebird 3.0.3 and installed it on my Mac. In Library
> > Frameworks, I do see Firebird.framework and it has many folders inside.
That's the Firebird root on MacOSX.
> I read the Quick Start Guide, but all the instructions pertain to
> Windows and Unix us
Doug wrote:
> In any event, the admins have made it clear they are not looking to
> move so we can drop it for the moment.
Actually, I'm the admin and I haven't said a lot about the current
glitches so far. ;-) And you're an occasional moderator of this list
too, so it's fair you should have yo
Tomasz wrote:
> I know it's off-topic, but does anyone else experience receiving
> multiple copies of some posts on this list, or is it just me?
> Sometimes I have 2, 3 or 4 identical copies in my inbox (like Hugo's
> from yesterday - 2 copies). They seem identical except for their X-UIDL,
> but
Lee,
> I’m struggling to grant any privileges on a .fdb file database.
> I have created a separate user as the SYSDBA reported “Your login
> SYSDBA is same as one of the SQL role name. Ask your database
> administrator to set up a valid Firebird Login”.
The SYSDBA user exists already. The passw
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
Ian wrote:
> We got the idea from The Firebird Book, and after that I can't find
> mention of it being deprecated in 2.0 release notes or later.
Not deprecated but abolished. If something is "deprecated", it is
still valid but likely to be dropped in a subsequent release. From Fb
2 onward, Fb wa
> 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
wobble...@yahoo.co.uk wrote:
> I've just tried
> TempDirectories = /location1 5000 ;/location2 ; /location3
> And location1 is ignored, but 2 and 3 used!
Which tells you something. ;-)
The engine doesn't recognise the format of the first member of the
list but it's OK with the second a
Issam Boughanmi wrote:
> hi,
> i have some issues related to character sets in an asp.net core
> application using 6.1 provider and EF .
> special characters like 'µ' or french characters for example don't show up
> correctly .
> i have another web application using 4.10 provider and ef with th
Taylor Stewart wrote:
> Installed firebird 3.0.3.32900 on windows xp with ipv6 enabled. and it will
> only listen on :: ipv6
> if i manually adjust RemoteBindAddress to 0.0.0.0 it listens on ipv4 fine.
Looks as if you have discovered a workaround for behaviour on an
obsolete operating syste
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
Javier wrote:
>
> Ok, but how do I restore the statistics? Using "update" statements?
You do not "restore the statistics". The statistic that gets updated
by a SET STATISTICS call is the selectivity of the index. Low value =
high selectivity = Good; high value = low selectivity = bad. The
val
Steve Naidamast wrote:
> I am currently using Firebird Embedded edition for a military
> simulation I have been working on.
> I have seen recently that Firebird 3.0 has just been released with
> a brand new User-Guide.
Actually, Firebird 3.0 was released two years ago. The latest
sub-release is
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
> 16.03.2018 14:47, shg_siste...@yahoo.com.ar [firebird-support] wrote:
>> Since some days ago I'm getting (it seems very occasionally and randomly) a
>> "blob not
>> found" error.
>> As far as I remember the problem happens during read operations: with
>> "locate" commands or
>> inside a "whil
Saturday, March 10 alansbr...@gmail.com wrote:
> I'm trying to create an external table with a normal user and I'm getting
> this error:
> This operation is not defined for system tables.
> unsuccessful metadata update.
> CREATE TABLE EXT_CTB_LANCAMENTO failed.
> There is no privilege for thi
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
Hello Aldo,
> My questions are the following:
> 1) Is the intended effect to fill behind the scenes a newly created
> field with its default value when there is a not null constraint ?
No. Only inserts subsequent to the commit of the DDL for the new
field will use the default in the case where
Salim Naufal wrote:
> I have noticed the following inconsistencies in Firebird 3.02:
[..]
> I then tried:
> SELECT CAST(1 AS NUMERIC(18,2)) * (1.00 - (1.00/1.11)) FROM
> RDB$DATABASE and got a much better result of 991.0
> Finally, the correct result is retrieved using:
> SELECT CAST(1
Hello Nico,
Friday, December 22, 2017, 10:29:05 PM, you wrote:
> Hello,
> I have a problem with inserting a row in table
> OrderTypeDescriptions. Here you can find the sql script for the
> tables OrderTypes and OrderTypeDescriptions.
> CREATE TABLE ORDERTYPES (
> ID INTEGER GENERAT
Hello Nico,
Wednesday, December 20, 2017, 4:34:09 AM, you wrote:
> CREATE TABLE ADDRESSES (
> IDINTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL,
> ADDRESSNAME VARCHAR(100) COLLATE UNICODE_CI_AI,
> Id = 1 / AddressName = Test / ..
> Id = 2 / Ad
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
alauren...@gmail.com wrote:
> I use Firebird with Excel VBA and I manage to make SELECT, INSERT, DELETE..
> etc BUT...
> I didn't find anywhere how to run a stored procedure
{[? =] Call MyProc (?,?)}
The ODBC driver knows to EXECUTE an executable procedure and to SELECT
from a selectable one.
Wednesday, November 15, 2017, 5:54:05 AM, m_brahi...@yahoo.fr wrote:
> I would like to know please, if we can use a DB in win64 but built
> under win32 . The client app is built with delphi 32 bits so the
> clients will connect to that DB in 64 bits. Is it possible ? Thanks
>
1. Your databa
Friday, November 3, 2017, 3:12:37 AM, Rustam wrote:
> I got an error executing SELECT query with LIKE predicate in case of UTF8
> database,
> non-UTF8 connection charset and national characters in LIKE
> argument without mask symbols '%' and '_'
> Error is
> "arithmetic exception, numeric overf
Tuesday, October 24, 2017, 1:37:01 AM, j...@acousticdesign.co.uk wrote:
> I have a stored procedure along the lines of
> SELECT ID, Amount1, Amount2 ..
> FROM Table1.
> UNION
> SELECT ID, Amount1, Amount2...
> FROM Table2
> ORDER BY 1
> Is it possible to construct a conditional ORDER By
I wrote:
>> The Firebird 3 installer script didn't put it there but possibly
>> FlameRobin or Jaybird did. Some client interfaces need to read
>> firebird.conf. It won't conflict with the server's firebird.conf, per
>> se, but it would pay to keep the one used by the client app consistent
>> wit
Wednesday, October 18, 2017, 9:52:36 AM, dferg...@gmail.com wrote:
> I am a newbie, like a total newbie just exploring databases for the
> first time. I am using Lazarus and they all seem to prefer Firebird
> and lot of the documentation is geared that way. I have
> successfully downloaded and i
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/
Tuesday, October 3, 2017, 5:02:21 AM, Pierre wrote:
> I want to add readonly user creation/granting after database initialisation.
> I create the database using a bunch of SQL scripts. After the last
> script runs, I create a user using "create user MYUSER password
> 'myPassword'" the I grant this
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
Thursday, September 21, 2017, 12:24:52 AM, "Sabbagh, Nariman"
wrote:
> I am using Ames application which is using firebird, Ames keeps
> hanging and it is because of firebird giving error 10054. Could you please
> advise , thank you
>
Well, that is a network error, not coming from Fire
Hello shg_siste...@yahoo.com.ar,
Friday, September 15, 2017, 2:53:19 AM, you wrote:
> I read somewhere that the "read only" transactions are absolutelly
> harmless to the GC and sweeping. Is that so?
It is true for READ ONLY transactions that are started in READ
COMMITTED isolation mode. In oth
Hello shg_siste...@yahoo.com.ar,
Thursday, September 14, 2017, 2:10:23 AM, you wrote:
> Hello! I'm noticing a small increase of my database size. Now it
> has 566,992 KB. After a backup/restore the size goes to 533,640 KB.
> I don't have long running read/write transactions (well... I think)
The
Hello Magnus,
Tuesday, September 12, 2017, 9:53:47 PM, you wrote:
> From what I have been able to read, the documentation that exists
> seems to be a mix on both 3.0, 2.x and even 1.5 making it a little unclear.
If you have the IBPhoenix DVD, you will find it documented in some
detail in Chapter
> 10.09.2017 02:13, Daniel Miller wrote:
>> The misunderstanding is probably mine - but I've never heard of 34-bit
>> values/precision before. Is that a typo for either 32 or 64? Or "34"
>> is correct?
DY replied:
> 34 *digit* precision. If "34-bit" is mentioned there, then it's a mistake.
It
Friday, September 8, 2017, 9:08:00 PM, ke...@dojitraders.com wrote:
> Thank you for your reply. I mentioned that this problem was
> reported in the Tracker system (Bug CORE-5306) and my problem is just the
> same.
>From that discussion, Mr da Costa and you are encountering the same
symptoms. He
Friday, September 8, 2017, 9:31:43 PM, Adriano Novelli wrote:
> i use a odbc connection to connect to the database.
> on every pc I have configured a odbc connection with the same name
> and configured the database path by specifying the IP address of the server
> as I said before, if I do the
Hello ke...@dojitraders.com,
Friday, September 8, 2017, 11:10:39 AM, you wrote:
> I am thinking FreeAdhocUDF is a dead project. It has not been updated for
> many years.
> The main thing though is that these UDFs work ok in Firebird 2.5. I
> have also developed a UDF (DLL) in Delphi, and tha
Saturday, September 2, 2017, 9:35:20 AM, Neagu wrote:
> In databases.conf I can put the lists of alias of Known databases, but I
> look for a way to specify only the alias of path where the databases are
> store.
> Now, If I not specify a path in connect string, the databases is search
> in C:\W
Friday, August 25, 2017, 3:36:51 AM, Ismael wrote:
> Sorry for the off topic, but I have a doubt that maybe some of you can
> clarify
> I was reading Firebird 4.0 Release Notes and I found the following note:
Yes, any questions about alphas, betas, snapshots, pre-release
versions are right o
> Ive been having quite a few crashes on a new server with not much databases
> or requests. terminated abnormally (4294967295)
> It seems to be very random, there are not many different operations going
> on.
>
> Its a google cloud Windows vm, Ive checked for hardware / driver problems
> b
>> Let's create two unites from one lot:
>>
>> INSERT INTO UNITES (CODE, LOT, SITE, DESCRIPTION) VALUES ('A1', 'L1', 'S1',
>> 'abc'); INSERT INTO UNITES (CODE, LOT, SITE, DESCRIPTION) VALUES ('A2',
>> 'L1', 'S1', 'bcd');
>>
>> I expected that the following instruction will not be exectued:
>> IN
Monday, August 7, 2017, 5:54:06 AM, you wrote:
>>
>> Did you actually replace the client lib on the remote box with the
>> appropriate-bitness one from the installation?
> System is x64 but x86 version of firebird is required due to legacy UDF.
> I have tried deleting the DLLs from System32 and
Sunday, August 6, 2017, 7:07:02 PM, you wrote:
> Hi all.
> On a brand new install for Firebird 2.5.7 (x86) I am having issues
> connecting to the server via TCP/IP.
> The error message is always the same "Connection rejected by remote
> interface" however I have tried several DB utilities and I c
Friday, July 28, 2017, 9:03:19 PM, robert rottermann wrote:
> I proceeded as Helene suggested
> I executed gbak.
> However this produced zillions of warnings of the form
> gback: do not recognize table attribute 0 -- continuing
> this goes on now for some 15 minutes.
> A database VAS.FDB was c
Thursday, July 27, 2017, 7:33:43 AM, prosse...@yahoo.com wrote:
> I want to get a delphi7 program that works with the full server to
> work with embeded... I am a getting 'database unavailable' whatever I try
> I have followed the instructions to the diligently - copying and
> renaming the files
Hello robert,
Tuesday, July 25, 2017, 4:32:12 PM, you wrote:
> When I try to unpack it using the following command:
> c:\Program Files\Firebird..\bin\gback.exe -c VAS.bak VAS.fdb
1. Make sure the server is running.
2. You need the file path and, if using Classic mode, the hostname.
> This prod
Hello Lee,
Sunday, July 23, 2017, 5:28:05 AM, you wrote:
> Am working on an old VB6 project and need to connect to some Firebird Data.
> Having problem Connecting to database when it's a network address.
[..]
That's because Firebird (by design) does not connect to databases on
network drives.
Friday, April 21, 2017, 10:29:01 PM, blumy2...@yahoo.com wrote:
> I install Firebird 1.5.6 with administrator rights, WIn 10, x64, but i have
> a problem
> I can not use local protocol on my PC!
> All my firebird's application connect with FDB database, only i use
> run as administrator for my
Sunday, March 5, 2017, 12:27:11 AM, soimah.r...@yahoo.com wrote:
> Firebird 2.1 and 2.5 i have installed as normal.Then when i open my
> entrypass( software for access card reading and programing) software
> ( this software im using requires firebird server and client) it say
> firebird database e
Hello Sandris,
Thursday, March 2, 2017, 5:24:03 AM, you wrote:
> Hello!
> Error occurs if i am trying to register database events using 3.0.2.
> fbclient.dll to firebird 3.0.2. on linux.
> "Failed to establish a secondary connection for event processing."
> No error if server is on windows
Tuesday, February 7, 2017, 9:35:55 AM, I wrote:
> 1. 'SQLSTATE = m' is not a valid error message in Firebird. You should
> be seeing a 5-character alphanumeric code where the 'm' is. Other
> DBMS's use the same name for their SQL command-line apps so make sure
> you are running isql from the same
> So currently I have firebird 2.5 installed and running on Windows,
> working fine but performance is a bit slow.
> I have installed 2.5 on Ubuntu, and I can connect to the current database
> with ISQL easily:
> connect "192.168.155.112:C:\database\database.FDB" user 'SYSDBA' password
> 'admin
Thursday, February 2, 2017, 12:07:37 PM, I wrote:
> Using Firebird's command-line tools:
> gstat -h path\to\database will return the first two.
> isql path\to\database -user sysdba -password masterkey
> will return the default character set.
I omitted to add that you will get the default chara
Thursday, February 2, 2017, 3:20:10 AM, d.picciotto wrote:
> I have some Trouble with the Migration of Firebird vers. 1.5 to Firebird
> vers. 2.1
> First of all I made a Backup of my Database File *.gdb with the function gbak
> using isql
No, you didn't. Isql is an SQL language support progr
Hello ,
Monday, January 23, 2017, 11:08:40 PM, kragh.tho...@yahoo.com wrote:
> On a product of ours we use continuous deployment where code and
> database schema changes is deployed quite often. Sometimes we would
> like to make a new release during database backup. So my questions are:
> 1) Ho
> Thanks for your answer. I think I got help from you also during last time
> migration test. :-)
> I tested it with your advice but it still doesn't work.
I am not convinced you have that authentication configured properly
nor that your application is really loading the Fb3 client library.
Som
Saturday, January 7, 2017, 3:02:03 PM, James wrote:
> I am trying to migrate my database from 2.5 to 3.0 now.
> Now I show all my steps&nbs p;I have done for migration procedure.
> 1. Use gbak (FB 2.5) to backup Firebird 2.5 database file.
> 2. Use gbak (FB 3.0) to restore backuped FBK file to
Hello Dmitry,
Friday, December 30, 2016, 10:20:11 AM, DY wrote:
> 29.12.2016 23:05, Helen Borrie hele...@iinet.net.au wrote:
>>
>>> On windows systems, if you create a database without path specification,
>>> firebird tries to create it in the windows/system32 directory.
>>
>> No; it will use the
Wednesday, December 28, 2016, 11:19:24 PM, you wrote:
> On windows systems, if you create a database without path specification,
> firebird tries to create it in the windows/system32 directory.
No; it will use the current directory, e.g.,
C:\windows\Programs64\Firebird\Firebird_2_5\bin
in my setu
Hello Roland,
Wednesday, December 21, 2016, 10:39:50 PM, Roland Turcan wrote:
> But still, why this problem occurred? Why didn't some generators have
> it =1?
A generator that has never been triggered has a value of 0, not 1.
In the context of your complaint that NEXT VALUE FOR seemed to retu
1 - 100 of 255 matches
Mail list logo