Re: [firebird-support] Strange behavior on very large table

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

Re: ODP: [firebird-support] Query optimization on FB3

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

Re: ODP: [firebird-support] Query optimization on FB3

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

Re: [firebird-support] change a trigger that I create with RDB $ SYSTEM_FLAG = 1.

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

Re: [firebird-support] Firebird 3.0 client does not work with remote Firebird 2.5 database

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

Re: [firebird-support] Firebird 3.0 client does not work with remote Firebird 2.5 database

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

Re: [firebird-support] Problems with creating new users (no permission for INSERT access to TABLE PLG$VIEW_USERS)

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),

Re: [firebird-support] Informing the devs about optimizer issues / alternative plans

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

Re: [firebird-support] Converting dates and the ISO-8601 format

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

[firebird-support] Off-topic discussions

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

Re: [firebird-support] Possible bug in 2.5.1.26351

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

Re: [firebird-support] Firebird 2.5: first insert into table takes ages to complete

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

Re: [firebird-support] Custom error message from procedure/trigger code in Firebird 3.x dialect 3

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 >

Re: [firebird-support] Very slow response after massive delete on table. (FB3 on Win 64)

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

Re: [firebird-support] Firebird - GRANT edit/recreate access to specific users and block some users from editing/recreating the procedure

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

Re: [firebird-support] Firebird - GRANT edit/recreate access to specific users and block some users from editing/recreating the procedure

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

Re: ODP: [firebird-support] Using Union and Join (of two tables residing in different databases)in a Query

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. >

Re: ODP: [firebird-support] Using Union and Join (of two tables residing in different databases)in a Query

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

Re: [firebird-support] Re: Sequential auto incremental numbering

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:

Re: [firebird-support] Unable to connect to the employee database

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

Re: [firebird-support] How does a Mac OS user get started?

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

Re: [firebird-support] Re: Mailing list change?

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

Re: [firebird-support] Multiple copies of the same post

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

Re: [firebird-support] GRANT Privileges

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

Re: [firebird-support] Re: tempdirectories

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

Re: [firebird-support] Re: tempdirectories

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

Re: [firebird-support] Re: tempdirectories

> 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

Re: [firebird-support] Re: tempdirectories

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

Re: [firebird-support] characterset issue in asp.net core

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

Re: [firebird-support] firebird 3.0 Not binding on ipv4 on windows xp machine

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

Re: [firebird-support] URGENT - Database performance is very slow

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

Re: [firebird-support] Re: Firebird 3: Not able to UPDATE RDB$Procedures

> 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,

Re: [firebird-support] Error -902 after Update Windows 10

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

Re: [firebird-support] Error -902 after Update Windows 10

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

Re: [firebird-support] FB3 alter domain colltion

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 : >

Re: [firebird-support] Firebird ADO.NET: ExecuteNonQuery Returns -1 On Successful Insert

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 >

Re: [firebird-support] Doubts regarding statistics of indexes and tables...

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

Re: [firebird-support] Re: Firebird Embedded - Will a 3.0 version be released???

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

Re: [firebird-support] order by 1, 2 - fb 32990

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)

Re: [firebird-support] no permission for INSERT access to TABLE PLG$SRP_VIEW

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 >

Re: [firebird-support] BLOB Not Found error

> 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

Re: [firebird-support] External Tables

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

Re: [firebird-support] Firebird 3 Developer's Guide released

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

[firebird-support] Firebird 3 Developer's Guide released

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

Re: [firebird-support] Cannot open database file in local hard disk

> 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

Re: [firebird-support] Firebird 3 - Auto Garbage collection with Sweep interval = 0

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

Re: [firebird-support] Re: Running with two different embedded versions of Firebird DB

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

Re: [firebird-support] Adding a field with NOT NULL constraint

>   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

Re: [firebird-support] Adding a field with NOT NULL constraint

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

Re: [firebird-support] Miscalculation of floating points in Firebird

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

Re: [firebird-support]Engine Error - Partner Index

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

Re: [firebird-support] Info

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 /

Re: [firebird-support] Re: Deadlock error from firebird during midnight

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

Re: [firebird-support] Trouble establishing a connection to Firebird database files.

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

Re: [firebird-support] Trouble establishing a connection to Firebird database files.

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

Re: [firebird-support] Moving DB from 32 bits to 64 bits

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

Re: [firebird-support] string right truncation error with LIKE predicate and UTF8 DB

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

Re: [firebird-support] Creating a conditional "order by" statement

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

Re: [firebird-support] Wirecrypt

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 >>

Re: [firebird-support] Wirecrypt

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

Re: [firebird-support] embedded database with Chinese path

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/

Re: [firebird-support] Cannot grant user by code

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

Re: [firebird-support] Re: Installing Firebird on Fedora 26

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

Re: [firebird-support] error 10054

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

Re: [firebird-support] file size and transactions

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

Re: [firebird-support] file size and transactions

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)

Re: [firebird-support] FB 3.0 Replacing ICU libraries

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

Re: [firebird-support] Re: Firebird Alpha 4 Release Notes

> 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.

Re: [firebird-support] FreeAdhocUDF and Firebird 3 not working

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.

Re: [firebird-support] Re: Problem with linked table

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

Re: [firebird-support] FreeAdhocUDF and Firebird 3 not working

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

Re: [firebird-support] Implicit path for Database

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

Re: [firebird-support] OT: Firebird 4.0 xinetd Support on Linux Replaced

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

Re: [firebird-support] Firebird 3 crashes ( terminated abnormally (4294967295) )

> I’ve 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. > > It’s a google cloud Windows vm, I’ve checked for hardware / driver problems >

Re: [firebird-support] Multi-column Foreign key

>> 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: >>

Re: [firebird-support] Firebird 2.5 rejecting connections

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

Re: [firebird-support] Firebird 2.5 rejecting connections

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

Re: [firebird-support] unpacking backup with firebird version 1.5 (windows 7)

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

Re: [firebird-support] using embedded

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

Re: [firebird-support] unpacking backup with firebird version 1.5 (windows 7)

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

Re: [firebird-support] Firebird Connection String

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.

Re: [firebird-support] Firebird 1.5.6 not work with locla protocol

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

Re: [firebird-support] Firebird issue.

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

Re: [firebird-support] Problems with database events

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

Re: [firebird-support] Migrating a 2.5 server

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

Re: [firebird-support] Firebird Migration from version 1.5 to version 2.1 help please !!!!

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

Re: [firebird-support] Firebird Migration from version 1.5 to version 2.1 help please !!!!

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

Re: [firebird-support] firebird schema changes during backup

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)

Re: [firebird-support] FB 2.5 migrate to 3.0

> 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.

Re: [firebird-support] FB 2.5 migrate to 3.0

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

Re: [firebird-support] Re: FB3: Default create database location

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

Re: [firebird-support] FB3: Default create database location

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

Re: [firebird-support] Re: NEXT VALUE FOR on Firebird 3.0.1 32bit Windows 7 32bit

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

Re: [firebird-support] Re: NEXT VALUE FOR on Firebird 3.0.1 32bit Windows 7 32bit

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

Re: [firebird-support] Re: Setting up firebird for visual studio

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,

Re: [firebird-support] connecting to an existing firebird database using new user id/pw

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

Re: [firebird-support] Update Description

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

Re: [firebird-support] reset autoincrement field

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),

Re: [firebird-support] Firebird 2.5.6 Newbee question

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

Re: [firebird-support] Digest Number 9396

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   2   3   >