[firebird-support] FB 3.0 SS WriteFile Error
Hi guys, I have installed FB 3.04 on Windows 7 64 bit. On Firebird configuration file, have set Temporary Directory to e:\;d:\temp. I got an error : I/O error during "WriteFile" operation for file "e:\fb_table_u9" Error while trying to write to file. There is enough space on the disk. I checked drive e, there a file fb_table_u9, the size is about 2 GB and drive e has about 3.3 GB free space. Database file size is about 8 GB. Drive e is a ram drive, size is 8 GB. How many space needed for temporary file? 3 GB is not enough? If it was not enough, why Firebird not switch to drive d? Thanks in advance. Anto
Re: [firebird-support] FB 3.0 Embedded
Re: [firebird-support] FB 3.0 Embedded
On 11-4-2019 01:51, Tony Christiansen t...@adegroup.com.au [firebird-support] wrote: > Hi > > As I read it FB 3.x embedded requires a dll in a plugins folder that > sits under the application folder. > > Is there any way to move the location of the plugins folder as I have a > legacy app that controls all the subfolders. As far as I'm aware there is no setting for this. Put fbclient.dll + plugins/* in a different location and put it on the path (either globally, or specifically for that app). Mark PS Please don't reply to existing threads with different topics to start a new but unrelated topic. Write a new message to create a new topic (or reply to your existing thread of the 30th of March). -- Mark Rotteveel
[firebird-support] FB 3.0 Embedded
Hi As I read it FB 3.x embedded requires a dll in a plugins folder that sits under the application folder. Is there any way to move the location of the plugins folder as I have a legacy app that controls all the subfolders. Thanks Tony
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 Chapter 9 of The Firebird Book Second Edition eBook. The same in hard copy is in Chapter 8 of TFB2e Volume 1 (Firebird Fundamentals). Helen
RE: [firebird-support] FB 3.0 Replacing ICU libraries
Mark, I wholeheartedly agree with you. I too tried it with 2.5 but didn't success so I gave up at that time. >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. Especially as README.intl.txt also mentions "you can replace ICU libraries by a complete one found in our site", but I don't remember ever having found anything like that on firebirdsql.org. Thanks for your input, Magnus From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Tuesday, September 12, 2017 10:34 AM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] FB 3.0 Replacing ICU libraries On 2017-09-12 10:15, Magnus Johansson mag...@nimajo.se [firebird-support] wrote: > Hi All, > > Perhaps my previous post about collation problem was too long so that > nobody cared to read it through, so let me start with a simpler > question. > > I need unicode collation for Swedish and therefore I have to replace > the ICU libraries. > > First I have downloaded the snapshot for FB 3.0.3 for Windows > (Firebird-3.0.3.32802-0_x64). > > Then I went to http://site.icu-project.org/download and downloaded > icu4c-52_1-Win64-msvc10.zip from where I got the icu*52.dll's and > extracted them to the FB3 folder, replacing the existing ones. > > No changes done in intl\fbintl.conf or anything else. > > I would appreciate if anyone could just answer if this is the correct > way to do this. I believe this is the correct approach, but I have only tried it once with Firebird 2.5 and ran into some compatibility issues at that time. Unfortunately this is - afaik - entirely undocumented. Personally I'd prefer if Firebird was just released with the full ICU library instead of the trimmed down version. Mark
Re: [firebird-support] FB 3.0 Replacing ICU libraries
On 2017-09-12 10:15, Magnus Johansson mag...@nimajo.se [firebird-support] wrote: > Hi All, > > Perhaps my previous post about collation problem was too long so that > nobody cared to read it through, so let me start with a simpler > question. > > I need unicode collation for Swedish and therefore I have to replace > the ICU libraries. > > First I have downloaded the snapshot for FB 3.0.3 for Windows > (Firebird-3.0.3.32802-0_x64). > > Then I went to http://site.icu-project.org/download and downloaded > icu4c-52_1-Win64-msvc10.zip from where I got the icu*52.dll's and > extracted them to the FB3 folder, replacing the existing ones. > > No changes done in intl\fbintl.conf or anything else. > > I would appreciate if anyone could just answer if this is the correct > way to do this. I believe this is the correct approach, but I have only tried it once with Firebird 2.5 and ran into some compatibility issues at that time. Unfortunately this is - afaik - entirely undocumented. Personally I'd prefer if Firebird was just released with the full ICU library instead of the trimmed down version. Mark
[firebird-support] FB 3.0 Replacing ICU libraries
Hi All, Perhaps my previous post about collation problem was too long so that nobody cared to read it through, so let me start with a simpler question. I need unicode collation for Swedish and therefore I have to replace the ICU libraries. First I have downloaded the snapshot for FB 3.0.3 for Windows (Firebird-3.0.3.32802-0_x64). Then I went to http://site.icu-project.org/download and downloaded icu4c-52_1-Win64-msvc10.zip from where I got the icu*52.dll's and extracted them to the FB3 folder, replacing the existing ones. No changes done in intl\fbintl.conf or anything else. I would appreciate if anyone could just answer if this is the correct way to do this. Regards, Magnus Johansson
[firebird-support] FB 3.0 + ODBC
This is a message to the development team, including all testers, documenters, project management, etc After almost 14 years using Firebird (from version 1 candidate release 3) until today, with FB 3 migration just finalized on Tuesday night this week, with 3 databases (100Mb, 7GB and 70Gb) serving multiple Apps (7+) with mutliple users (30+ concurrent); and after been warned against jumping on FB3, with some reasonable concerns, we are ABSOLUTELLY delighted to see the results on FB3, in production. We can only be gratefull to the FB development team, the product ROCKS! We have tried to "disturb" the server by runnning backup and restore of other databases in parallel while users are online, we have even started in parallel multiple restore of mutliple databases on the side while the system is being accessed by 20 users, and the performance and response is outstanding. For those who want to know our config is: DL 380 G7 Dual 12 core processor server, with 192 GB ram, 3.5 TB Raid 6; 512 cache on raid. Windows standard 2012 R2 64 bits. ODBC 2.04 (firebird) Firebird 3.0 64 bits (snapshot 9/9/16) All apps running compiled with Clarion 9.1 I would not consider MS SQL even if MS pays me to change. Well done Dev team Congrat Fabian
[firebird-support] FB 3.0, a few questions on a new future
Hi guys, I am building a new project using FB 3.0 - SS, I have a few questions : 1) Since FB 3.0 support WireCompression, should I still use Zebedee? 2) Is that possible to hide stored procedure/trigger codes in FB 3.0 ? Usually I used this statement : UPDATE RDB$TRIGGERS a set a.RDB$TRIGGER_SOURCE = NULL where a.RDB$TRIGGER_NAME in ('BD_1','BD_2') Thanks & Regards, Anto
[firebird-support] FB 3.0, got problem when add field to Table with existing data
Hi guys, I have a table with existing data & got a problem to add field that must have a value -> alter table Tbl1 add Fld1 int not null. If table doesn't have data, it is OK, but Firebird refused if table already have data. Any suggestion how to solve this problem? Thanks & regards, Anto
Re: [firebird-support] FB 3.0, Dialect 1 and SQL Error
Of course Firebird didn't know. And it seems to work. Thank you
Re: [firebird-support] FB 3.0, Dialect 1 and SQL Error
Have you tried (cast(:PAar as integer) * 100) + cast(:PMDR as integer)) I've never tried it the exact setting as you're using, but I've had to use cast when I've used a CTE to return a constant value (quite natural, there's no simple and general way for Firebird to guess what type your parameter is). 2016-05-20 12:59 GMT+02:00 michael.vilhelm...@microcom.dk [firebird-support] : > > > Hi > > I have installed Firebird 3.0. I'm testing our program up against this > one. > Our databases are in SQL dialect 1. > > I have a table like this: > > CREATE TABLE MYTABLE > ( > ID INTEGER NOT NULL, > NAME_ VARCHAR(30), > VALUEFLOAT NUMERIC( 18, 2) DEFAULT 0, > VALUEINTINTEGER DEFAULT 0, > AAR INTEGER DEFAULT 0, > MDR INTEGER DEFAULT 0, > CONSTRAINT PK_MYTABLE PRIMARY KEY (ID) > ); > > > If I do this SQL, I get an error: > > SELECT > MYTABLE.NAME_, > Sum(MYTABLE.VALUEFLOAT) AS SumFloat, > Sum(MYTABLE.VALUEINT) AS SumInteger > FROM > MYTABLE > WHERE > ((MYTABLE.AAR * 100) + MYTABLE.MDR) >= ((:PAar * 100) + :PMDR) > GROUP BY > NAME_ > > > ERROR: > Dynamic SQL Error expression evaluation not supported Invalid data type > for multiplication in dialect 1 > > It works if I replace the parameters with numbers like this: > > > SELECT > MYTABLE.NAME_, > Sum(MYTABLE.VALUEFLOAT) AS SumFloat, > Sum(MYTABLE.VALUEINT) AS SumInteger > FROM > MYTABLE > WHERE > ((MYTABLE.AAR * 100) + MYTABLE.MDR) >= ((2016 * 100) + 5) > GROUP BY > NAME_ > > > > > So my question is, if there is a simple workaround to avoid this? > > I have tried googling something on this, but havn't found anything so far. > > I have read the release notes, but either cant find anything on this or > I'm not looking good enough. > > > Michael > > > > > >
[firebird-support] FB 3.0, Dialect 1 and SQL Error
Hi I have installed Firebird 3.0. I'm testing our program up against this one. Our databases are in SQL dialect 1. I have a table like this: CREATE TABLE MYTABLE ( ID INTEGER NOT NULL, NAME_ VARCHAR(30), VALUEFLOAT NUMERIC( 18, 2) DEFAULT 0, VALUEINTINTEGER DEFAULT 0, AAR INTEGER DEFAULT 0, MDR INTEGER DEFAULT 0, CONSTRAINT PK_MYTABLE PRIMARY KEY (ID) ); If I do this SQL, I get an error: SELECT MYTABLE.NAME_, Sum(MYTABLE.VALUEFLOAT) AS SumFloat, Sum(MYTABLE.VALUEINT) AS SumInteger FROM MYTABLE WHERE ((MYTABLE.AAR * 100) + MYTABLE.MDR) >= ((:PAar * 100) + :PMDR) GROUP BY NAME_ ERROR: Dynamic SQL Error expression evaluation not supported Invalid data type for multiplication in dialect 1 It works if I replace the parameters with numbers like this: SELECT MYTABLE.NAME_, Sum(MYTABLE.VALUEFLOAT) AS SumFloat, Sum(MYTABLE.VALUEINT) AS SumInteger FROM MYTABLE WHERE ((MYTABLE.AAR * 100) + MYTABLE.MDR) >= ((2016 * 100) + 5) GROUP BY NAME_ So my question is, if there is a simple workaround to avoid this? I have tried googling something on this, but havn't found anything so far. I have read the release notes, but either cant find anything on this or I'm not looking good enough. Michael
[firebird-support] FB 3.0 Linux Mint 17.3 (Debian)
Re: [firebird-support] FB 3.0, how to get IDENTITY of last inserted row
You are right. I've tried the same with Database Workbench 5 and it works ok. Thank you, Dimitry :)
Re: [firebird-support] FB 3.0, how to get IDENTITY of last inserted row
Looks like Firebird Maestro has a bug. I've tried the same with Database Workbench 5 and all works as expected. Thank you guys... Zoran
Re: [firebird-support] FB 3.0, how to get IDENTITY of last inserted row
27.04.2016 21:04, 'Zoran' zoran...@gmail.com [firebird-support] wrote: > It doesn’t like “returning Id”. It displays this error: SQLDA error. Wrong > number of > parameters (expected 1, got 0) This is an application bug. Obviously, the application hasn't prepared place for returned Id. For me everything work with isql: > SQL> create table aaa(id integer generated by default as identity, col1 > integer, col2 varchar(10)); > SQL> insert into aaa (col1, col2) values (1,'abc') returning id; > > ID > >1 > > SQL> show version; > ISQL Version: WI-T4.0.0.86-dev Firebird 4.0 Unstable > Server version: > Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T4.0.0.86-dev > Firebird 4.0 Unstable" > on disk structure version 12.0 -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] FB 3.0, how to get IDENTITY of last inserted row
Hello Zoran, > > In FB 2.5 I am using > > insert into MyTable (col1, col2) values(val1, val2) returning Id > > where Id is autoinc column (sequence generator + before insert trigger). > > How do I do it in FB 3.0? It doesn’t like “returning Id”. It displays > this error: SQLDA error. Wrong number of parameters (expected 1, got 0) > > I have Id defined as IDENTITY. Can I get INDENTITY for the last inserted > row without using SELECT GEN_ID(generator-name, 0) AS ID FROM RDB$DATABASE ? > > I am trying this with Firebird Maestro 15.11.0.1 (supports FB 3) on Win > Server 2012 R2. With FB 2.5 all works as expected. The following works fine for me with FB3 (server + client library): create table t1 ( id integer generated by default as identity primary key , fname varchar(15) ); commit; In isql: C:\Firebird\Firebird_300_4050_x86>isql -user sysdba -password masterkey fb3test.fdb Database: fb3test.fdb, User: SYSDBA SQL> insert into t1 (fname) values ('hugo') returning id; ID 15 So, in general it works. ;-) -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
[firebird-support] FB 3.0, how to get IDENTITY of last inserted row
Hello In FB 2.5 I am using insert into MyTable (col1, col2) values(val1, val2) returning Id where Id is autoinc column (sequence generator + before insert trigger). How do I do it in FB 3.0? It doesn't like "returning Id". It displays this error: SQLDA error. Wrong number of parameters (expected 1, got 0) I have Id defined as IDENTITY. Can I get INDENTITY for the last inserted row without using SELECT GEN_ID(generator-name, 0) AS ID FROM RDB$DATABASE ? I am trying this with Firebird Maestro 15.11.0.1 (supports FB 3) on Win Server 2012 R2. With FB 2.5 all works as expected. Thank you. Zoran
R: Re: [firebird-support] FB 3.0 and PHP connection
Hi, I made a fresh installation about Firebird, with flag on gnerate gds32.dll library, and everythings works fine! Thanks for support.Best Regards Messaggio originale Da: 'Ismael L. Donis Garcia' sli...@citricos.co.cu [firebird-support] Data: 26/04/2016 17.36 A: Ogg: Re: [firebird-support] FB 3.0 and PHP connection which authentication method you are using on the server? Test with: Legacy Authentication If you do not intend to use SRP encrypted log-ins right away and want to use the security database—security3.fdb— as you have done in previous Firebird versions, proceed as follows: Using a text editor, open firebird.conf and find the entry for the parameter UserManager: #UserManager = Srp Delete the “#” symbol and change the value to: UserManager = Legacy_UserManager Find the entry for the WireCrypt parameter: #WireCrypt = Enabled (for client) / Required (for server) Delete the “#” symbol and change the value to: WireCrypt = Disabled Find the entry for the AuthServer parameter: #AuthServer = Srp, WinSspi, Legacy_Auth Delete the “#” symbol and change the order of the arguments: AuthServer = Legacy_Auth, Srp, WinSspi Find the entry for the AuthClient parameter: #AuthClient = Srp, WinSspi, Legacy_Auth Delete the “#” symbol and change the order of the arguments: AuthClient = Legacy_Auth, Srp, WinSspi Save the changes. Stop and restart Firebird for the changes to take effect. Legacy Passwords The old masterke password is available for your first login as SYSDBA. It is known to the whole world and should be changed as soon as possible. Reminder: Legacy authentication reads only the first 8 characters of any password. Best Regards | ISMAEL | - Original Message - From: 'palbe...@libero.it' palbe...@libero.it [firebird-support] To: firebird-support@yahoogroups.com Sent: Tuesday, April 26, 2016 9:47 AM Subject: [firebird-support] FB 3.0 and PHP connection Hi all, I'm working on the evaluation of Firebird SQL 3.0 and connection using PDO available in PHP. The database works fine and I'm able to connect it using FlameRobin but when I try to establish a connection using PHP I get a NULL as result of the follow: getMessage() . ""; } var_dump($dbh); ?> PHP load fine the PDO and PDO_Firebird, does anyone knows if I have to move some DLL somewhere? NOTE: Windows 2012 R2, PHP Version 5.2.12, Apache 2.2, Firebird 3.0 Thanks in advance. Alberto Posted by: "palbe...@libero.it" Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (1) Upgrade your account with the latest Yahoo Mail app Get organized with the fast and easy-to-use Yahoo Mail app. Upgrade today! ++ -->
Re: [firebird-support] FB 3.0 and PHP connection
which authentication method you are using on the server? Test with: Legacy Authentication If you do not intend to use SRP encrypted log-ins right away and want to use the security database—security3.fdb— as you have done in previous Firebird versions, proceed as follows: Using a text editor, open firebird.conf and find the entry for the parameter UserManager: #UserManager = Srp Delete the “#” symbol and change the value to: UserManager = Legacy_UserManager Find the entry for the WireCrypt parameter: #WireCrypt = Enabled (for client) / Required (for server) Delete the “#” symbol and change the value to: WireCrypt = Disabled Find the entry for the AuthServer parameter: #AuthServer = Srp, WinSspi, Legacy_Auth Delete the “#” symbol and change the order of the arguments: AuthServer = Legacy_Auth, Srp, WinSspi Find the entry for the AuthClient parameter: #AuthClient = Srp, WinSspi, Legacy_Auth Delete the “#” symbol and change the order of the arguments: AuthClient = Legacy_Auth, Srp, WinSspi Save the changes. Stop and restart Firebird for the changes to take effect. Legacy Passwords The old masterke password is available for your first login as SYSDBA. It is known to the whole world and should be changed as soon as possible. Reminder: Legacy authentication reads only the first 8 characters of any password. Best Regards | ISMAEL | - Original Message - From: 'palbe...@libero.it' palbe...@libero.it [firebird-support] To: firebird-support@yahoogroups.com Sent: Tuesday, April 26, 2016 9:47 AM Subject: [firebird-support] FB 3.0 and PHP connection Hi all, I'm working on the evaluation of Firebird SQL 3.0 and connection using PDO available in PHP. The database works fine and I'm able to connect it using FlameRobin but when I try to establish a connection using PHP I get a NULL as result of the follow: getMessage() . ""; } var_dump($dbh); ?> PHP load fine the PDO and PDO_Firebird, does anyone knows if I have to move some DLL somewhere? NOTE: Windows 2012 R2, PHP Version 5.2.12, Apache 2.2, Firebird 3.0 Thanks in advance. Alberto -- Posted by: "palbe...@libero.it" -- Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (1) -- Upgrade your account with the latest Yahoo Mail app Get organized with the fast and easy-to-use Yahoo Mail app. Upgrade today! -- ++
Re: [firebird-support] FB 3.0 and PHP connection
I had to copy the FBCLIENT.DLL from the Firebird installation directory to the Apache/bin directory for the PDO stuff to work. This however is dependent on your setup. Also remember to use correct 32bit or 64bit version of the DLL, depending on your Apache. Regards, Kim From: "'palbe...@libero.it' palbe...@libero.it [firebird-support]" To: Sent: 4/26/2016 4:47 PM Subject: [firebird-support] FB 3.0 and PHP connection Hi all, I'm working on the evaluation of Firebird SQL 3.0 and connection using PDO available in PHP. The database works fine and I'm able to connect it using FlameRobin but when I try to establish a connection using PHP I get a NULL as result of the follow: getMessage() . ""; } var_dump($dbh); ?> PHP load fine the PDO and PDO_Firebird, does anyone knows if I have to move some DLL somewhere? NOTE: Windows 2012 R2, PHP Version 5.2.12, Apache 2.2, Firebird 3.0 Thanks in advance. Alberto
[firebird-support] FB 3.0 and PHP connection
Hi all, I'm working on the evaluation of Firebird SQL 3.0 and connection using PDO available in PHP. The database works fine and I'm able to connect it using FlameRobin but when I try to establish a connection using PHP I get a NULL as result of the follow: getMessage() . ""; }var_dump($dbh);?> PHP load fine the PDO and PDO_Firebird, does anyone knows if I have to move some DLL somewhere? NOTE: Windows 2012 R2, PHP Version 5.2.12, Apache 2.2, Firebird 3.0 Thanks in advance.Alberto
Re: RE: [firebird-support] FB 3.0
>>I was not complaining about IBX nor about FB. I was just asking. >>Embarcadero / Idera stopped developing IBX, they now support FireDAC >>components, this is why I asked. >>By now, replacing FB 2.5.5 with 3.0 on my test machine seems to be ok. >>Tiberiu._,_.___ Boolean implemenatations are not compatibile between Interbase/Firebird. And IBX is native for Interbase and it can not use Boolean implementation from firebird. I tested this and also this not wqork good if you change source code of IBX changing boolean field id. Better not use it at all. Rest seems to work ok. But if you use delphi - remember that Count(*) now is Int64 And if you have result of count as Field in dfm then you must update that field info. regards, Karol Bieniaszewski
RE: [firebird-support] FB 3.0
I was not complaining about IBX nor about FB. I was just asking. Embarcadero / Idera stopped developing IBX, they now support FireDAC components, this is why I asked. By now, replacing FB 2.5.5 with 3.0 on my test machine seems to be ok. Tiberiu
RE: [firebird-support] FB 3.0
> 2. Anybody tested code with with FB 3.0 and Delphi and IBX ? Any problems ? > Can IBX properly access the boolean fields in FB 3.0 ? The IBX components are a third-party library, not produced by the Firebird project. Testing of components is the responsibility of the library developers/maintainers. There have been several alpha, beta and RC releases of v3.0 made available to provide plenty of time for third-parties to make the necessary changes to accommodate new features. Sean
Re: [firebird-support] FB 3.0
19.04.2016 18:39, 'Tiberiu Horvath' tiberiu_horv...@yahoo.com [firebird-support] wrote: > This means that (I have some 100+ databases in use at some of my clients) I > should wait for a way to access these ODS 11.2 databases from FB 3.0 ? No. Give up a hope. > Can IBX properly access the boolean fields in FB 3.0 ? No. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
[firebird-support] FB 3.0
Support for Users of Firebird ReleasesHi all, Currently using FB 2.5.5 but starting tests with the new FB 3.0 . A few questions : 1. The new ODS (12) is not compatible with older (<=11.2) so, according to http://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-apiods.html we have to do a manual backup on 2.5.5 and a restore on 3.0. It says that “A legacy provider for databases with ODS 8 to 11.2 is planned for a future sub-release.” This means that (I have some 100+ databases in use at some of my clients) I should wait for a way to access these ODS 11.2 databases from FB 3.0 ? It would be perfect ... 2. Anybody tested code with with FB 3.0 and Delphi and IBX ? Any problems ? Can IBX properly access the boolean fields in FB 3.0 ? Congratulations for this new release, Tiberiu
Re: [firebird-support] FB 3.0
Now it works fine here too ... Thank you , Tiberiu
Re: [firebird-support] FB 3.0
Perfect !!! Thank you very much, I replaced all fbclient.dll and gds32.dll -s (\windows\system32, etc) with the new FB 3.0 libraries and the app connected !!! Thank you, Tiberiu
Re: [firebird-support] FB 3.0
Thank you for your answer. I used FireDAC before for MySQL and SQLite databases. I wanted to know if there is a way that I could use IBX with FB 3.0 . It seems there is not ... Tiberiu
Re: [firebird-support] FB 3.0
Support for Users of Firebird ReleasesHi, Just quickly restored a FB2 DB in FB3 and connected with the Application (Build in Delphi 7 using IBX). I copied the fbclient.dll from the install directory into the application directory and renamed to gds32.dll No problems i ran into. Met vriendelijke groet, Arno Brinkman ABVisie a...@abvisie.nl http://www.abvisie.nl
Re: [firebird-support] FB 3.0
Re: [firebird-support] FB 3.0
Hi, this is really off-topic here but these pointers will help. IBX components will show with way red lines underneath - everything from IBDatabase to IBQuery to IBStoredProc. Use Firedac, it works very well and if you are careful you can change all your e.g. IBqry1, IBqry2 to FBqry1, FBqry2 do this by selecting View as Text in your datamodule and using search/replace. Unfortunately the supposed tool for automating this does not work so you could also drop an FBqry on the form and change the name to an exiting IBqry then delete the IBqry. You also need a Firedac TFDConnection, TFDtransaction, TFDPhysFBDriverLink and FDGUIxWaitCursor. You will need a FDConnectionDefs ini file in a path accessible to your program, try the exe folder. Copy the existing sample one and amend it. In there you need to set up this: [newtown_settings] // your own such as myaccounts_settings DriverID=FB VendorLib = 'C:\Program Files (x86)\Firebird\Firebird_2_5\bin\fbclient.dll' Database=192.168.1.104:c:\apps\newtown\orders.fdb User_Name=sysdba Password=*** There is a lot of work involved if you have numerous queries and sps. The Embarcadero docwikis are helpful but don't go far enough. Good luck. Alan J Davies Aldis On 10/11/2015 07:41, 'Tiberiu Horvath' tiberiu_horv...@yahoo.com [firebird-support] wrote: > Hi all, > We use FireBird since 1.0 and develop programs with Delphi (recently > upgraded to D10 Seattle). We use plain IBX components to connect to the > FB server in a few big accounting programs. Tried to play with FB3.0 RC1 > and installed it on port 3051 for testing, alongside FireBird 2.5.4 on > port 3050. > Our problem is that Delphi (the IDE) connects to the new server / ODS > database, also IBExpert connects to the new server / database but the > programs, on runtime, does not. Can we specify somewhere (params in > TIBDatabase / TIBTransaction) the path / file of the client dll for > Firebird / Interbase ? Probably the app cannot load the proper dll > (FB3.0) on statup. > Anybody using Delphi and IBX could connect to FB3.0 with their programs > ? Are these compatible ? Is there something we could do ? Upgrading to > FireDAC or IBO is our last option. > Thank you, > Tiberiu > PS backup and restore from ODS 11.x to OSD 12.0 is not a problem, since > we could install both versions (2.5.4 and 3.0) and automate the process. > > ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
[firebird-support] FB 3.0
Support for Users of Firebird ReleasesHi all, We use FireBird since 1.0 and develop programs with Delphi (recently upgraded to D10 Seattle). We use plain IBX components to connect to the FB server in a few big accounting programs. Tried to play with FB3.0 RC1 and installed it on port 3051 for testing, alongside FireBird 2.5.4 on port 3050. Our problem is that Delphi (the IDE) connects to the new server / ODS database, also IBExpert connects to the new server / database but the programs, on runtime, does not. Can we specify somewhere (params in TIBDatabase / TIBTransaction) the path / file of the client dll for Firebird / Interbase ? Probably the app cannot load the proper dll (FB3.0) on statup. Anybody using Delphi and IBX could connect to FB3.0 with their programs ? Are these compatible ? Is there something we could do ? Upgrading to FireDAC or IBO is our last option. Thank you, Tiberiu PS backup and restore from ODS 11.x to OSD 12.0 is not a problem, since we could install both versions (2.5.4 and 3.0) and automate the process.
Re: [firebird-support] FB 3.0 SQL Error.
On Tue, 23 Dec 2014 17:06:08 -0200, "Hugo Eyng hugoe...@msn.com [firebird-support]" wrote: > Thank you for your answer Mark. > > You are right, 31 characters. > > And I agree that is not a good idea truncating like FB 2.5. > > I tested under FB 2.5.2.26539 and IBExpert. > > In the sql: > > select cd_ent as id_column_name_larger_than_31_test1, tp_ent as > id_column_name_larger_than_31_test2 > from dm100 > > IbExpert returned: > > id_column_name_larger_than_31*_t* for the first columnand > id_column_name_larger_than_31*_1* for the second column I don't use IB Expert, but I tried with flamerobin which didn't show this, so I think it is IB Expert that applies an extra transformation to the alias when there are duplicates (eg after truncation by Firebird). Mark
Re: [firebird-support] FB 3.0 SQL Error.
Thank you for your answer Mark. You are right, 31 characters. And I agree that is not a good idea truncating like FB 2.5. I tested under FB 2.5.2.26539 and IBExpert. In the sql: select cd_ent as id_column_name_larger_than_31_test1, tp_ent as id_column_name_larger_than_31_test2 from dm100 IbExpert returned: id_column_name_larger_than_31*_t* for the first columnand id_column_name_larger_than_31*_1* for the second column Hugo Eyng On 23/12/2014 15:46, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: On 23-12-2014 18:25, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: In FB 3.0.0 I received the error message: Name longer than database column size. SELECT I.CD_TIPO_MOVIMENTO_ESTOQUE *AS* CD_TIPO_MOVIMENTO_ESTOQUE_COMPRA FROM MyTable CD_TIPO_MOVIMENTO_ESTOQUE_COMPRA (31 characters large) 32 characters Ok. I Understood the message. My column has more than 30 characters. More than 31 But, in FB 2.5 , a column larger than 30 characters was truncated or replaced by a number at the end of the column name. CD_TIPO_MOVIMENTO_ESTOQUE_COMPRA ->CD_TIPO_MOVIMENTO_ESTOQUE_COMPR or CD_TIPO_MOVIMENTO_ESTOQUE_COMPRA -> CD_TIPO_MOVIMENTO_ESTOQUE_COMP1 to avoid duplication field. Firebird 2.5 silently **truncates** the column name to the first 31 characters (tested with 2.5.3 Update 1). It doesn't apply a numbered alias if there are multiple columns that truncate to the same name: you simply get multiple columns with the same alias. I would consider that a really big bug. A lot of applications expect that the alias that is used in the query is also the alias that is to be used for obtaining the value from the result set. Renaming columns breaks those applications (either hard because of errors, or worse silently because you get the wrong value (from the wrong column)). Is there some kind of setting that cause FB 3.0.0 acting like FB 2.5 in this situation? Not that I know of. Mark -- Atenciosamente, Hugo Eyng
Re: [firebird-support] FB 3.0 SQL Error.
Hi Helen. I am testing FB 3.0.0 but I use FB 2.5.3, that is why some question are about 2.5.3. Thanks. On 23/12/2014 16:36, Helen Borrie hele...@iinet.net.au [firebird-support] wrote: Hugo, At 06:25 a.m. 24/12/2014, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: >Hello Friends. > >In FB 3.0.0 I received the error message: Name longer than database column size. Would you please use the firebird-devel or firebird-test list for questions about Fb 3? This support list is for released versions only. Thanks, ^heLen^ -- Atenciosamente, Hugo Eyng
Re: [firebird-support] FB 3.0 SQL Error.
Hugo, At 06:25 a.m. 24/12/2014, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: >Hello Friends. > >In FB 3.0.0 I received the error message: Name longer than database column >size. Would you please use the firebird-devel or firebird-test list for questions about Fb 3? This support list is for released versions only. Thanks, ^heLen^
Re: [firebird-support] FB 3.0 SQL Error.
On 23-12-2014 18:25, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: > In FB 3.0.0 I received the error message: Name longer than database > column size. > > SELECT I.CD_TIPO_MOVIMENTO_ESTOQUE *AS* CD_TIPO_MOVIMENTO_ESTOQUE_COMPRA > FROM MyTable > > CD_TIPO_MOVIMENTO_ESTOQUE_COMPRA (31 characters large) 32 characters > Ok. I Understood the message. My column has more than 30 characters. More than 31 > But, in FB 2.5 , a column larger than 30 characters was truncated or > replaced by a number > at the end of the column name. > CD_TIPO_MOVIMENTO_ESTOQUE_COMPRA ->CD_TIPO_MOVIMENTO_ESTOQUE_COMPR > or > CD_TIPO_MOVIMENTO_ESTOQUE_COMPRA -> CD_TIPO_MOVIMENTO_ESTOQUE_COMP1 > to avoid duplication field. Firebird 2.5 silently **truncates** the column name to the first 31 characters (tested with 2.5.3 Update 1). It doesn't apply a numbered alias if there are multiple columns that truncate to the same name: you simply get multiple columns with the same alias. I would consider that a really big bug. A lot of applications expect that the alias that is used in the query is also the alias that is to be used for obtaining the value from the result set. Renaming columns breaks those applications (either hard because of errors, or worse silently because you get the wrong value (from the wrong column)). > Is there some kind of setting that cause FB 3.0.0 acting like FB 2.5 in > this situation? Not that I know of. Mark -- Mark Rotteveel ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
[firebird-support] FB 3.0 SQL Error.
Hello Friends. In FB 3.0.0 I received the error message: Name longer than database column size. SELECT I.CD_TIPO_MOVIMENTO_ESTOQUE *AS* CD_TIPO_MOVIMENTO_ESTOQUE_COMPRA FROM MyTable CD_TIPO_MOVIMENTO_ESTOQUE_COMPRA (31 characters large) Ok. I Understood the message. My column has more than 30 characters. But, in FB 2.5 , a column larger than 30 characters was truncated or replaced by a number at the end of the column name. CD_TIPO_MOVIMENTO_ESTOQUE_COMPRA ->CD_TIPO_MOVIMENTO_ESTOQUE_COMPR or CD_TIPO_MOVIMENTO_ESTOQUE_COMPRA -> CD_TIPO_MOVIMENTO_ESTOQUE_COMP1 to avoid duplication field. Is there some kind of setting that cause FB 3.0.0 acting like FB 2.5 in this situation? -- Atenciosamente, Hugo Eyng
[firebird-support] FB 3.0 Multiuser Environment
Hello. I am testing FB 3.0.0.31374 BETA. Instalation Classic Database size 4 gigabytes Delphi 2007 Windows 2008 Server Enterprise Edition 32 bits 16 gigabytes RAM 800 gigabytes HD Raid 10 When I try to open the database in a second session I get the error message: Servidor de banco de dados não foi encontrado! *(Database server not found)* I/O error during "CreateFile (open)" operation for file "C:\TEXTIL\DADOS\DM\SGBT\DADOS\DATAMAIS.FDB" *(Entire path for my database)* Error while trying to open file O arquivo já está sendo usado por outro processo. *(File is in use by another process) * So my application cannot be opened by two or more users. Even using IBExpert, I cannot open the same database more than one time. Did anybody faced this situation? -- Atenciosamente, Hugo Eyng
Re: [firebird-support] FB 3.0 Beta 1
At 10:10 p.m. 5/12/2014, Werner werner...@gmx.ch [firebird-support] wrote: >I would like to start testing FB 3. > >Does the installer allow installation side by side with FB 2.5? Please take your Fb 3 Beta questions to the firebird-devel list. ^heLen^ (Moderator)
[firebird-support] FB 3.0 Beta 1
I would like to start testing FB 3. Does the installer allow installation side by side with FB 2.5? Werner