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
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
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
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
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
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),
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
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
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
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
>
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
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.
>
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
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
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
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
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
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
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
> 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 specific sp
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
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
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
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
> 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
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
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 :
>
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
>
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
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
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
>
> 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
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
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
> 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
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
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
> 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
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
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
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
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 /
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
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
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
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
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
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
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
>>
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
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
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
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
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
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)
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
> 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.
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.
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
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
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
> 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
>
>> 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:
>>
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
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
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
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
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
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
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
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
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)
> 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.
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 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 a
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
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
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
Hello Roland,
Wednesday, December 21, 2016, 9:11:36 PM, Roland Turcan wrote:
> But I cannot call this:
> update RDB$GENERATORS set rdb$generator_increment = 1 where
> rdb$generator_name not starting 'RDB$';
System Tables are read-only in Fb 3.
> how can I set the value to 1?
Read the release
Hello Aleksa,
Thursday, December 15, 2016, 7:39:49 AM, you wrote:
> Last week I am trying to set up my new computer for Visual Studio
> programming with Firebird databases. Problem is I tried everything
> in my power but when i try to connect to Firebird database via
> Server Explorer in VS,
i have a database created and access on Firebird for years.
i've always used the id/pw sysdba/masterkey
all i want to do is:
change my delphi IBO Objects tIBConnection.username to 'mynewuser'
and .password to 'mynewpassword'
i am not sure what to use in .SQLROLE? i've tried 'RDB$ADMIN' and
Hello ,
LtColRDSChauhan wrote:
> In Firebird 3.0 I'm not able to update Description of Table /
> Stored Procedure through flamerobin.
WHEN you read the Fb 3 release notes, did you notice how often it was
mentioned that the system tables are now read-only?
To populate rdb$description in any
Nico Speleers wrote:
> How can I reset an autoincrement field in firebird 3 ? I used
> identity to make an autoincrement field.
In your Fb 3 installation is the /doc/ directory, where you will find
the release notes in PDF form. IDENTITY is documented on page 69
(page 79 by the PDF numbering),
Tuesday, November 22, 2016, 8:48:05 AM, ratdog1...@msn.com wrote:
> I am new to Firebird. I have downloaded Firebird 2.5.6 (Client,
> Classic Server and SuperServer versions) but when I install them on
> my MAC, I cannot find any files even though my MAC tells me that the
> programs have been
Monday, November 21, 2016, 8:37:50 PM, tiberiu_horv...@yahoo.com wrote:
> This is how I create my temporary tables :
> create global temporary table TEMP_112233
> (
> id : INTEGER,
> name : CHAR(20)
> )
> on commit preserve rows
You should create your GTT only once in your life, not
1 - 100 of 236 matches
Mail list logo