[firebird-support] FB 3.0 SS WriteFile Error

2019-07-01 Thread trsk...@yahoo.com [firebird-support]
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

Re: [firebird-support] FB 3.0 Embedded

2019-04-11 Thread Tony Christiansen t...@adegroup.com.au [firebird-support]

Re: [firebird-support] FB 3.0 Embedded

2019-04-11 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
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

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

2017-09-12 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
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] FB 3.0 Replacing ICU libraries

2017-09-12 Thread Magnus Johansson mag...@nimajo.se [firebird-support]
ay, 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 lo

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

2017-09-12 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
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

[firebird-support] FB 3.0 Replacing ICU libraries

2017-09-12 Thread Magnus Johansson mag...@nimajo.se [firebird-support]
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

[firebird-support] FB 3.0 + ODBC

2016-09-16 Thread fabia...@itbizolutions.com.au [firebird-support]
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)

[firebird-support] FB 3.0, a few questions on a new future

2016-06-02 Thread trsk...@yahoo.com [firebird-support]
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

[firebird-support] FB 3.0, got problem when add field to Table with existing data

2016-06-01 Thread trsk...@yahoo.com [firebird-support]
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

2016-05-20 Thread michael.vilhelm...@microcom.dk [firebird-support]
Of course Firebird didn't know. And it seems to work. Thank you

Re: [firebird-support] FB 3.0, Dialect 1 and SQL Error

2016-05-20 Thread Svein Erling Tysvær setys...@gmail.com [firebird-support]
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

[firebird-support] FB 3.0, Dialect 1 and SQL Error

2016-05-20 Thread 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(

[firebird-support] FB 3.0 Linux Mint 17.3 (Debian)

2016-05-07 Thread mus...@die-optimisten.net [firebird-support]

Re: [firebird-support] FB 3.0, how to get IDENTITY of last inserted row

2016-04-27 Thread zoran...@yahoo.com [firebird-support]
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

2016-04-27 Thread zoran...@yahoo.com [firebird-support]
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

2016-04-27 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
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.

Re: [firebird-support] FB 3.0, how to get IDENTITY of last inserted row

2016-04-27 Thread Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
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

[firebird-support] FB 3.0, how to get IDENTITY of last inserted row

2016-04-27 Thread 'Zoran' zoran...@gmail.com [firebird-support]
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

R: Re: [firebird-support] FB 3.0 and PHP connection

2016-04-27 Thread 'palbe...@libero.it' palbe...@libero.it [firebird-support]
ta: 26/04/2016 17.36 A: <firebird-support@yahoogroups.com> 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 inten

Re: [firebird-support] FB 3.0 and PHP connection

2016-04-26 Thread 'Ismael L. Donis Garcia' sli...@citricos.co.cu [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

Re: [firebird-support] FB 3.0 and PHP connection

2016-04-26 Thread Kim Sandell sand...@celarius.com [firebird-support]
palbe...@libero.it' palbe...@libero.it [firebird-support]" <firebird-support@yahoogroups.com> To: <firebird-support@yahoogroups.com> Sent: 4/26/2016 4:47 PM Subject: [firebird-support] FB 3.0 and PHP connection   Hi all,  I'm wor

[firebird-support] FB 3.0 and PHP connection

2016-04-26 Thread 'palbe...@libero.it' palbe...@libero.it [firebird-support]
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() . "";

Re: RE: [firebird-support] FB 3.0

2016-04-20 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
  >>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

RE: [firebird-support] FB 3.0

2016-04-20 Thread tiberiu_horv...@yahoo.com [firebird-support]
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

2016-04-19 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
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

[firebird-support] FB 3.0

2016-04-19 Thread 'Tiberiu Horvath' tiberiu_horv...@yahoo.com [firebird-support]
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

Re: [firebird-support] FB 3.0

2015-11-10 Thread Alan J Davies alan.dav...@aldis-systems.co.uk [firebird-support]
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

Re: [firebird-support] FB 3.0

2015-11-10 Thread 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]

Re: [firebird-support] FB 3.0

2015-11-10 Thread 'Arno Brinkman' fbsupp...@abvisie.nl [firebird-support]
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

Re: [firebird-support] FB 3.0

2015-11-10 Thread tiberiu_horv...@yahoo.com [firebird-support]
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

2015-11-10 Thread tiberiu_horv...@yahoo.com [firebird-support]
Now it works fine here too ... Thank you , Tiberiu

[firebird-support] FB 3.0

2015-11-09 Thread 'Tiberiu Horvath' tiberiu_horv...@yahoo.com [firebird-support]
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

[firebird-support] FB 3.0 SQL Error.

2014-12-23 Thread Hugo Eyng hugoe...@msn.com [firebird-support]
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

Re: [firebird-support] FB 3.0 SQL Error.

2014-12-23 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
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

Re: [firebird-support] FB 3.0 SQL Error.

2014-12-23 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
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

Re: [firebird-support] FB 3.0 SQL Error.

2014-12-23 Thread Hugo Eyng hugoe...@msn.com [firebird-support]
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.

Re: [firebird-support] FB 3.0 SQL Error.

2014-12-23 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On Tue, 23 Dec 2014 17:06:08 -0200, Hugo Eyng hugoe...@msn.com [firebird-support] firebird-support@yahoogroups.com 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.

[firebird-support] FB 3.0 Multiuser Environment

2014-12-19 Thread Hugo Eyng hugoe...@msn.com [firebird-support]
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

[firebird-support] FB 3.0 Beta 1

2014-12-05 Thread Werner werner...@gmx.ch [firebird-support]
I would like to start testing FB 3. Does the installer allow installation side by side with FB 2.5? Werner

Re: [firebird-support] FB 3.0 Beta 1

2014-12-05 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
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)