[firebird-support] FB 3.0 SS WriteFile Error

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

[Tony Christiansen t...@adegroup.com.au [firebird-support]]

Re: [firebird-support] FB 3.0 Embedded

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

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

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

[Magnus Johansson mag...@nimajo.se [firebird-support]]

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

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

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

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

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

[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

[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

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

[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 Linux Mint 17.3 (Debian)

[mus...@die-optimisten.net [firebird-support]]

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

[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

[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

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

   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

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

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

['palbe...@libero.it' palbe...@libero.it [firebird-support]]

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] 
<firebird-support@yahoogroups.com>

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

['Ismael L. Donis Garcia' sli...@citricos.co.cu [firebird-support]]

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

[Kim Sandell sand...@celarius.com [firebird-support]]

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

['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() . "";   }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

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

[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

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

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

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

Re: [firebird-support] FB 3.0

['Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]]

Re: [firebird-support] FB 3.0

['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 vriendelijke groet,
Arno Brinkman
ABVisie
a...@abvisie.nl
http://www.abvisie.nl

Re: [firebird-support] FB 3.0

[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

[tiberiu_horv...@yahoo.com [firebird-support]]

Now it works fine here too ...  

 

 Thank you , 
 

 Tiberiu

[firebird-support] FB 3.0

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

[firebird-support] FB 3.0 SQL Error.

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

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

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

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

[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 for released versions only.

Thanks,
^heLen^

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

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

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.

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

[firebird-support] FB 3.0 Multiuser Environment

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

[firebird-support] FB 3.0 Beta 1

[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

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