Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

2016-01-01 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
31.12.2015 23:05, Eduardo guse...@gmail.com [firebird-support] wrote: > Disk caching should be disabled in order to use the drive with SQL Server. Anybody can mix up disk cache and OS cache. -- WBR, SD.

Re: [firebird-support] How to test performance of 3.0?

2016-06-03 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
03.06.2016 9:18, Gabor Boros gaborbo...@yahoo.com [firebird-support] wrote: > I would like to know how it performs with Debian 8, Ubuntu 16.04 and > CentOS 7. Any easy and free solution exist for this test? For example: http://svn.code.sf.net/p/firebird/code/qa/oltp-emul/ -- WBR, SD.

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

2016-06-03 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
03.06.2016 7:23, Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] wrote: >> 1) Since FB 3.0 support WireCompression, should I still use Zebedee? > > No point anymore. ZeeBeeDee can restrict access by key, not only do encryption and compression of channel. -- WBR, SD.

Re: [firebird-support] Engine12 mistery

2016-06-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.06.2016 19:56, 'Mark Rotteveel' m...@lawinegevaar.nl [firebird-support] wrote: > Is there a reason why the FB 3 server configured as follows would require > Engine12 as a > provider? Because it is server. The configuration is enough for Firebird client, but server needs engine to work

Re: [firebird-support] Engine12 mistery

2016-06-15 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.06.2016 22:46, fabia...@itbizolutions.com.au [firebird-support] wrote: > It seems Engine12 is not the same "type of component" as the other Providers. > In the > documentation it is refered as a Y valve, if I understand it correctly > Engine12 is the > base of the Y, while the other providers

Re: [firebird-support] Engine12 mistery

2016-06-15 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
15.06.2016 14:19, fabia...@itbizolutions.com.au [firebird-support] wrote: > When I omit Engine12 from the provider's list at the server's config, to > ensure the server > always acts as a super server This way you ensured that server cannot work with databases at all. I.e. it cannot work as

Re: [firebird-support] How does one connect to Firebird 2.5.4 that is on a windows server from a linux client?

2016-06-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.06.2016 20:37, 'stwizard' stwiz...@att.net [firebird-support] wrote: > Can anyone share information or a link on how that can be done? Have you read Fireburd Quick Start Guide? -- WBR, SD.

Re: [firebird-support] Is Firebird 3 ready for Production?

2016-05-27 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
27.05.2016 15:26, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] wrote: > Avalerion??? Yes. -- WBR, SD. ++ Visit

Re: [firebird-support] Is Firebird 3 ready for Production?

2016-05-27 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
27.05.2016 15:30, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] wrote: > what is Avalerion??? This is a bird that die having lied two eggs. And also a name of experimental Firebird fork that supports replication plugins. -- WBR, SD.

Re: [firebird-support] Is Firebird 3 ready for Production?

2016-05-27 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.05.2016 18:38, Fabian Ernesto Chocron fabia...@itbizolutions.com.au [firebird-support] wrote: > And regarding the replication, any advise on what product may be the right > choice? I would recommend to look at IBPhoenix Replicator.

Re: [firebird-support] FB 3 - SMP switched off ?

2016-05-26 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
26.05.2016 14:42, fabia...@itbizolutions.com.au [firebird-support] wrote: > Do you know if it is planned for Firebird to distribute each client request > across all > CPUs? When? Parallel execution of a single request is not planned at all yet. -- WBR, SD.

Re: [firebird-support] FB 3 - SMP switched off ?

2016-05-26 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
25.05.2016 19:34, fabia...@itbizolutions.com.au [firebird-support] wrote: > Any ideas why the SMP is not activated? Single connection uses only one execution thread. -- WBR, SD.

Re: [firebird-support] Re: Searching for FB3 backup suggestions

2016-05-26 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
26.05.2016 21:33, hv...@users.sourceforge.net [firebird-support] wrote: >Specify remote (network) access explicitly (else it tries to open database > using > embedded engine and fails) Shouldn't the next provider to be tried in this case? -- WBR, SD.

Re: [firebird-support] Searching for FB3 backup suggestions

2016-05-26 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
26.05.2016 13:50, dondondonje...@yahoo.com [firebird-support] wrote: > "C:\Program Files\Firebird\Firebird_3_0\gbak.exe" -b -v -t -se service_mgr > employee > e:\xxx.bak -user SYSDBA > works if no one is connected else i always get error "file is used by anot > her process". Use "-se

Re: [firebird-support] Finding a single row

2016-05-26 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
26.05.2016 12:48, Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr [firebird-support] wrote: > Below didn't work for me because complete card number is longer, and I do > lack SQL knowledge: > select * from FIYATKODLARI where Kodu like 'SB1%' select * from FIYATKODLARI where 'FullCardNumber'

Re: [firebird-support] gbak with -se switch?

2016-06-22 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
22.06.2016 10:25, 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support] wrote: > any clue? Move "MARTIJN-WS-DEV/3054" from database path to service_mgr path. -- WBR, SD.

Re: [firebird-support] Re: gbak with -se switch?

2016-06-22 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
22.06.2016 12:14, 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support] wrote: > When connected to the database from another application, here: > C:\Program Files\Firebird\Firebird_3_0>gbak -b -m -t -v > -user sysdba -pas masterkey > "e:\temp\2014 FB Conference.fdb"

Re: [firebird-support] Case and Accent insensitive compares

2016-06-16 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
16.06.2016 11:33, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > unless Tomas need to keep words Oops, it was Stefan, of course. I'm sorry. -- WBR,

Re: [firebird-support] Schema pluses?

2016-06-15 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
15.06.2016 21:49, 'livius' liviusliv...@poczta.onet.pl [firebird-support] wrote: > i need to know why this is important feature.. It is good from marketing POV. Biggest competitors have them, no matter what for. -- WBR, SD.

Re: [firebird-support] Case and Accent insensitive compares

2016-06-16 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
16.06.2016 15:30, Stefan Heymann li...@stefanheymann.de [firebird-support] wrote: > How can I work with that DE_DE_AI collation you mention? Firebird > doesn't seem to know it. According to README.intl you must create it in database using CREATE COLLATION query. I hope Adriano can shed more

Re: [firebird-support] Case and Accent insensitive compares

2016-06-16 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
16.06.2016 11:03, Paul Vinkenoog p...@vinkenoog.nl [firebird-support] wrote: > That's right. I can't think of any circumstances where you would want > to consider 'hatten' and 'hätten' the same, for instance. Or Mutter and > Mütter. Actually, I couldn't think of any German word where this would >

Re: [firebird-support] It works on FB 2.5 but does not work in FB 1.5

2016-06-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.06.2016 8:21, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > Please use English on this list Better yet: use list at http://www.firebase.com.br/ -- WBR, SD.

Re: [firebird-support] Column Name Size

2016-06-17 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
17.06.2016 0:01, Helen Borrie hele...@iinet.net.au [firebird-support] wrote: >> Is there the limitation of 31 bytes for column names in the new FB 3? > > 31 CHARACTERS - as before No, it is 31 byte. And in 3.0 the limitation is more restrictive than before, look at CORE-5282 for example.

Re: [firebird-support] Re: Firebird 3.0 - invalid transaction handle (expecting explicit transaction start).

2016-06-17 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
17.06.2016 13:17, Roland Turcan k...@rotursoft.sk [firebird-support] wrote: > I don't want to post this issue into DEVEL, because it is a support > question, but where are the guys able to answer or at least to point > us to some hints. Every time I saw this error, it was a bug in my

Re: [firebird-support] Re: Firebird 3.0 - invalid transaction handle (expecting explicit transaction start).

2016-06-17 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
17.06.2016 13:22, Roland Turcan k...@rotursoft.sk [firebird-support] wrote: > Dmitry, thanks for your reply, could you please tell me what was the > problem in your case? Bad synchronization, global variables, garbage values and so on. -- WBR, SD.

Re: [firebird-support] Foreign Key on update and after update trigger

2016-02-09 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
09.02.2016 13:16, Svein Erling Tysvær setys...@gmail.com [firebird-support] wrote: > Then you should have a separate process that at set times (e.g. once every > hour, day or > week), does something like: > > for select DistinctField, sum(MySummationField) from twarehouse_sum group by 1 >

Re: [firebird-support] How do find duplicates in a table?

2016-02-04 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
04.02.2016 20:09, 'stwizard' stwiz...@att.net [firebird-support] wrote: > How do I form a SQL Select statement that will return which records in my > PERSON table > have duplicate SOC_SEC_NO. RTFM GROUP BY, HAVING, COUNT(). -- WBR, SD.

Re: [firebird-support] Querying between databases

2016-01-30 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
30.01.2016 15:35, craig_...@coxcolvin.com [firebird-support] wrote: > When I need to update a valid value in one, I have to make that same change > in all the > other databases. It is very easy if you use isql. -- WBR, SD.

Re: [firebird-support] SUM(DC.I) / SUM(DC.Q) vs SUM(DC.I / DC.Q) why result is different?

2016-02-29 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
29.02.2016 15:19, Luigi Siciliano luigi...@tiscalinet.it [firebird-support] wrote: > What is the difference from "SUM(DC.I) / SUM(DC.Q)" > and "SUM(DC.I / DC.Q)" 1/2 + 1/4 <> 2/6. -- WBR, SD.

Re: [firebird-support] firebird and transaction behaviour questions

2016-02-23 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
23.02.2016 15:02, heineferre...@yahoo.com [firebird-support] wrote: > A friend of mine said that everything in firebird MUST be done inside a > transaction. That's true, but according to ODBC specs driver should start transaction automatically as needed. > Is this the case if you are doing

Re: [firebird-support] Restoring Backup

2016-02-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.02.2016 21:30, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: > I am not sure that is the best way Yes, gfix is better. At least faster. -- WBR, SD.

Re: [firebird-support] Restoring Backup

2016-02-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.02.2016 20:37, Ann Harrison aharri...@ibphoenix.com [firebird-support] wrote: > When it is restoring data, it > fills a data page and goes on to the next one. A large cache will fill with > pages that will not be referenced again until the indexes are built. To > build indexes, Firebird reads

Re: [firebird-support] cannot transliterate Firebird 1.5

2016-01-27 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
27.01.2016 14:15, blumy2...@yahoo.com [firebird-support] wrote: > Field STRADA in table is define WIN1251 Win1251 is a Cyrillic character set, it dos not include Romanian letters. -- WBR, SD.

Re: [firebird-support] Problem Firebird 2.5

2016-02-17 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
17.02.2016 15:14, 'Checkmail' check_m...@satron.de [firebird-support] wrote: > .it is not the gbak from firebird 2.1 The error shows that the backup was created with gbak 2.1 but from server 2.5. Nothing you can do but create database from scratch and pump data. > Now, gfix shows me „single

Re: [firebird-support] Trace API with "*_finish" = true

2016-02-11 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
11.02.2016 19:32, Jaume Llunell Gómez jaumellun...@gmail.com [firebird-support] wrote: > The practical use for this is when a statement is too slow that makes the > user to kill the > application. Just set query time threshold to an insane time like 60 seconds. This way you'll find slow

Re: [firebird-support] AW: different behavior firebird 3.0 RC2

2016-03-09 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
09.03.2016 12:18, 'Checkmail' check_m...@satron.de [firebird-support] wrote: > the trigger is required because the user can delete the one record, in this > case the > trigger deletes the referenced too. But if I delete the entire Order, the > record will be > delete twice. How can I solve this

Re: [firebird-support] timestamp of the firebird database (modified date) does not change in fb 3.0 RC2

2016-03-11 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
11.03.2016 12:59, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > i can confirm this - database modified datatime is frozen when first > connection has started. > i suppose that you should raport ticket into the firebird tracker. This ticket rather belongs to Windows

Re: [firebird-support] timestamp of the firebird database (modified date) does not change in fb 3.0 RC2

2016-03-11 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
11.03.2016 13:40, 'Checkmail' check_m...@satron.de [firebird-support] wrote: > What should I do, windows ticket? E-Mail an microsoft? ;) Yep. That was their decision to save your HDD by not writing modification time until the file is closed. -- WBR, SD.

Re: [firebird-support] VIEW optimization

2016-04-07 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
07.04.2016 18:34, Gabor Boros gaborbo...@yahoo.com [firebird-support] wrote: > Plan contains the JOIN but that not needed for the selected field. But it is needed to find out how many records with this value you'll get. -- WBR, SD.

Re: [firebird-support] Re: Cannot restore 32GB DB - fails at end, unusable. Any ideas please.

2016-04-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.04.2016 23:04, tomconl...@gmail.com [firebird-support] wrote: > It's a production database but this restore is for a side-project (email > logging). I > clearly need to get to the root of the problem. You run out of temp space. Buy new HDD. -- WBR, SD.

Re: [firebird-support] How can I prevent that my database can be opened with another security.fdb.

2016-04-08 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
08.04.2016 10:12, 'Mueller, Roland (GE87)' roland.muel...@honeywell.com [firebird-support] wrote: > Is there any way to prevent this and only use our authentication ? No. -- WBR, SD.

Re: [firebird-support] FB on LAN

2016-04-08 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
08.04.2016 15:17, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: > Do you know where could I find information about string connections and > protocols? In "The Firebird Book: a Reference for Database Developers", for example. -- WBR, SD.

Re: [firebird-support] How can I prevent that my database can be opened with another security.fdb.

2016-04-08 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
08.04.2016 11:32, Elmar Haneke el...@haneke.de [firebird-support] wrote: > You can use database encryption for that purpose No. Encryption can protect "cold" database on HDD in garbage collector, for example, but not an active one. -- WBR, SD.

Re: [firebird-support] String function extract last word from a string

2016-04-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.04.2016 17:00, 'Checkmail' check_m...@satron.de [firebird-support] wrote: > is it possible to extract the last complete word from a string until the last > blank? For > example “I would like to eat a bacon” In this case I would like to have the > “bacon” as result. RIGHT(string,

Re: [firebird-support] Firebird embedded on ISAPI

2016-03-22 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
22.03.2016 12:28, allan_fernan...@yahoo.co.uk [firebird-support] wrote: > Seems like I cannot use Firebird embedded on an IIS webserver via ISAPI. Yes, you'd better to use ordinary Firebird server. Embedded is almost no-go in this case. -- WBR, SD.

Re: [firebird-support] Disable cache at all - future question

2016-03-25 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
25.03.2016 18:48, liviusliv...@poczta.onet.pl [firebird-support] wrote: > I am talking about totally remove usage of cache(RAM) – like future HP > computer without > RAM – only fast “HDD”. It is completely impossible from technical POV. -- WBR, SD.

Re: [firebird-support] How write a query with a progressive sum field

2016-03-07 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
07.03.2016 11:16, Luigi Siciliano luigi...@tiscalinet.it [firebird-support] wrote: > How I do? sum(saldo) over (order by data) -- WBR, SD. ++

Re: [firebird-support] How write a query with a progressive sum field

2016-03-07 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
07.03.2016 12:29, Luigi Siciliano luigi...@tiscalinet.it [firebird-support] wrote: > Ok, I understand but, "over" is unknow in firebird 2.5.5. Upgrade to 3.0. -- WBR, SD.

Re: [firebird-support] How write a query with a progressive sum field

2016-03-07 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
07.03.2016 12:53, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > > Not so hurry.. FB3 is on RC2 stage not final. According to the announce it is stable enough for reporting/OLAP server. -- WBR, SD.

Re: [firebird-support] How write a query with a progressive sum field

2016-03-07 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
07.03.2016 11:51, Luigi Siciliano luigi...@tiscalinet.it [firebird-support] wrote: > I need add SALDO fields in the result of the query to get a progressive > sum of CARICO - SCARICO. sum(carcio-scarcio) over () as SALDO. -- WBR, SD.

Re: [firebird-support] How write a query with a progressive sum field

2016-03-07 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
07.03.2016 12:55, 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] wrote: > Needless to say, 3.0 is in release candidate state. Not sure if Luigi wants > to run 3.0 in > production yet. ;-) Nothing prevents him from installing of an additional server for report purposes and

Re: [firebird-support] When do I need the FB 3 client libs?

2016-03-04 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
04.03.2016 19:54, galdari...@yahoo.com.br [firebird-support] wrote: > 1- Encrypted database can be delivered with my application without any > configuration? > (same question for personal user and password, different from > SYSDBA/masterkey) Just > install, easy as older versions? > > 2- How to

Re: [firebird-support] How write a query with a progressive sum field

2016-03-07 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
07.03.2016 16:57, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] wrote: > You think that users can spin up servers/replication on a whim to solve a > problem in a > deployed system??? A lot of them does so. -- WBR, SD.

Re: [firebird-support] How write a query with a progressive sum field

2016-03-07 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
07.03.2016 17:21, Thomas Steinmaurer t...@iblogmanager.com [firebird-support] wrote: >> > Nothing prevents him from installing of an additional server for >> > report purposes and >> >setting up replication to it from production one. > > Yeah. Sure. ;-) > Well, if setting up standby

Re: [firebird-support] Firebird odbc 2.0.0.150 vs 2.0.3.154

2016-03-01 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
01.03.2016 13:58, 'Checkmail' check_m...@satron.de [firebird-support] wrote: > Unfortunatelyuntil todayI have no answer. What can I do? Use trace services to find out plans and stats for the queries. It will give you a key what was changed. -- WBR, SD.

Re: [firebird-support] Delete global temporary table

2016-04-03 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
03.04.2016 21:18, michael.vilhelm...@microcom.dk [firebird-support] wrote: > Sugestions? http://ibphoenix.com/services/repair Stop update metadata on-the-fly. There is no sense to create temporary tables for every user with the same structure. -- WBR, SD.

Re: [firebird-support] Update big table and nbackup benefit or not?

2016-04-05 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
05.04.2016 10:21, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > what is the answer for this A or B? None of them. Full pages are written to delta file, so you'll have database in exactly the same state as per scenario 1. -- WBR, SD.

Re: [firebird-support] Update big table and nbackup benefit or not?

2016-04-05 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
05.04.2016 12:43, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > but what happens at merge stage (delta merging) when i unlock database? > page will be overriden or new one will be created and old will be marked as > empty? Old pages will be overwritten, new ones will

Re: [firebird-support] How to add previous column value to current value?

2016-03-29 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
29.03.2016 11:40, 'Piotr Olszewski' piotr.olszew...@eskrzynka.pl [firebird-support] wrote: > I need to get a date difference (days between) between rows. With Firebird 3.0 you can use window function LAG. -- WBR, SD.

Re: [firebird-support] How to skip a trigger in the same trigger?

2016-04-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.04.2016 13:24, Gabor Boros gaborbo...@yahoo.com [firebird-support] wrote: > The table have many fields and a UNIQUE constraint with four fields, one > the ISDEFAULT from it (only one default accepted for groups of rows > depend on the other three fields (which included also in the UNIQUE) >

Re: [firebird-support] How to skip a trigger in the same trigger?

2016-04-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.04.2016 13:57, Gabor Boros gaborbo...@yahoo.com [firebird-support] wrote: > I have TBL_MASTER, TBL_DETAIL(this contains ISDEFAULT). You suggest a > TBL_DETAIL_DEFAULTS table? No, I suggest to add DefaultDetail field into TBL_MASTER referencing default record in TBL_DETAIL. -- WBR,

Re: [firebird-support] Re: User access by database level in 3.0?

2016-04-25 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
25.04.2016 10:30, Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] wrote: > Usre/password cannot protect a > publicly distributed database, but an encryption key can. Yeah. As long as you don't provide the key with them. -- WBR, SD.

Re: [firebird-support] remote installation configuration

2016-04-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.04.2016 11:15, Jonathan Mason jonno.ma...@googlemail.com [firebird-support] wrote: > is possible to use the new firebird 3 in a configuration where the database > is stored on a > google drive? No. > Is this config supported now or in the future? Never ever. -- WBR, SD.

Re: [firebird-support] Re: FB 3.0

2016-04-25 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
25.04.2016 12:02, david.edi...@yahoo.com [firebird-support] wrote: > How to I migrate our FB2 database to using FB3?? Create a new database on FB3 from scratch and pump data from old one. -- WBR, SD.

Re: [firebird-support] Backup with admin rights is prohibited?

2016-04-22 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
22.04.2016 15:34, Gabor Boros gaborbo...@yahoo.com [firebird-support] wrote: > Now tried to do a backup (gbak -B -T > -USER MYADMIN MYDB /home/user/MYDB.bak) and gbak say "You must be either > SYSDBA or owner of the database". You forgot to mention role ADMIN in the command line. -- WBR,

Re: [firebird-support] General: connect firebird server from local network

2016-04-21 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
21.04.2016 14:57, InField.au infield...@outlook.com [firebird-support] wrote: > As my understand, my application should work like this: No. Read Quick Start Guide about connection strings. -- WBR, SD.

Re: [firebird-support] SELECT WITH LOCK, WAIT transaction, deadlock

2016-04-28 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
28.04.2016 13:30, Gabor Boros gaborbo...@yahoo.com [firebird-support] wrote: > Now 3 instances enough to got deadlock after some time. Are you sure that error you got is "deadlock" and not "update conflict"? -- WBR, SD.

Re: [firebird-support] SELECT WITH LOCK, WAIT transaction, deadlock

2016-04-29 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
29.04.2016 11:26, Gabor Boros gaborbo...@yahoo.com [firebird-support] wrote: > The transaction do other work before grab the number and after grab the > number. The whole thing is in a (one) stored procedure. (Works like a > charm except deadlocks.) You need transaction with explicit exclusive

Re: [firebird-support] SELECT WITH LOCK, WAIT transaction, deadlock

2016-04-28 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
28.04.2016 13:41, Gabor Boros gaborbo...@yahoo.com [firebird-support] wrote: > The message is: > deadlock > update conflicts with concurrent update > concurrent transaction number is ... That's an expected behavior. -- WBR, SD.

Re: [firebird-support] Changing non-nullable column to nullable in FB 3

2016-04-29 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
29.04.2016 18:19, Ralf Jansen ralf.jan...@mailstore.com [firebird-support] wrote: > What would be the way to do it now? Read Release Notes about changes in DDL. -- WBR, SD.

Re: [firebird-support] Another Error When Backup

2016-04-26 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
26.04.2016 11:51, whitebu...@gmail.com [firebird-support] wrote: > Any other solution so I wont missing 1 day data ? If you a lucky, disable garbage collection during backup. Otherwise you can use tools from www.ib-aid.com. Best of all - find reason of database corruption or reproducible

Re: [firebird-support] How to get FB 3.0 x64 work as embeded version?

2016-04-26 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
26.04.2016 11:17, InField.au infield...@outlook.com [firebird-support] wrote: > But for x64 package, I got error like thi As a programmer you must know that bitness of a library has to match bitness of an application which address space it is loaded to. No exceptions from this rule. --

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] General: connect firebird server from local network

2016-04-23 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
23.04.2016 11:33, Helen Borrie hele...@iinet.net.au [firebird-support] wrote: > But that is not to say that the client reads firebird.conf, is it? It is. fbclient.dll does read firebird.conf and use some parameters from that. -- WBR, SD.

Re: [firebird-support] Question about few Firebird details

2016-05-23 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
23.05.2016 21:05, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > 44. Use NO_AUTO_UNDO - what happend when i do rollback? You will get hard rollback, frozen OAT counter and unavoidable run of sweep. -- WBR, SD.

Re: [firebird-support] Backup in embedded mode using C API - authentication problem

2016-05-23 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
23.05.2016 22:08, Bunth Tamás btom...@gmail.com [firebird-support] wrote: > It seems to me that firebird looks for the user name in the security2.fdb > file, which shouldn't be used in an embedded server. What am I missing? There is no embedded server on Linux. You are trying to use Classic

Re: [firebird-support] Backup in embedded mode using C API - authentication problem

2016-05-23 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
23.05.2016 20:37, Bunth Tamás btom...@gmail.com [firebird-support] wrote: > As far as I know, > I shouldn't pass username/password in the spb to isc_service_attach() in > embedded mode. You don't need password, but user name must be. -- WBR, SD.

Re: [firebird-support] Database Unavailable

2016-05-11 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
11.05.2016 22:38, 'Bill Skelton' b...@landmarkdata.com [firebird-support] wrote: > I've run out of things to try. Try to read Firebird Quick Start Guide from documentation folder or web-site. -- WBR, SD.

Re: [firebird-support] Checking Ods version (2.5 <-> 3.0)

2016-05-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.05.2016 16:02, Ralf Jansen ralf.jan...@mailstore.com [firebird-support] wrote: > is there an easy/official way to check the ODS versions? No. http://tracker.firebirdsql.org/browse/CORE-4679 -- WBR, SD.

Re: [firebird-support] Database Unavailable

2016-05-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.05.2016 16:34, 'Bill Skelton' b...@landmarkdata.com [firebird-support] wrote: > I was trying to use a mapped drive to a shared folder Just out of curiosity: does Sybase SQL Anywhere allow such database usage? -- WBR, SD.

Re: [firebird-support] Using LocalHost in FB 3.0

2016-05-17 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
17.05.2016 20:05, p...@royston.com [firebird-support] wrote: >We just recently discovered that our GBAK restore time went from 5 hours > down to 35 > minutes if we removed LocalHost from the database name on GBAK. It can be even better if you use switch -se. -- WBR, SD.

Re: [firebird-support] Full outer join poor performance.

2016-05-17 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
17.05.2016 12:20, agharta aghart...@gmail.com [firebird-support] wrote: > Any ideas about why fb take too long time to execute the query (and > scans so mutch rows)? PG can do hash full outer join, FB cannot. That's all. -- WBR, SD.

Re: [firebird-support] IN OUT PARAMETERS

2016-05-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.05.2016 9:49, 'Mihalache Bogdan' bogdan.mihala...@soter.ro [firebird-support] wrote: > In firebird is there an option to declare a parameter in a stored procedure > as an IN/OUT. No. Read Language Reference. IN parameters are completely separated from OUT parameters. -- WBR, SD.

Re: [firebird-support] Temporary Table In Memory

2016-05-03 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
03.05.2016 14:07, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote: > 1. I need to run several queries having different fields and conditions on > exactly same > join of tables. > > 2. How can i first create such a join of tables in memory and run the queries > without > re-creating

Re: [firebird-support] Re: Create or Alter Procedure: Token Unknown doing a Replace...

2016-05-02 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
02.05.2016 19:06, ho...@agencybusys.com [firebird-support] wrote: > *Error Message:* > Project ABS3.exe raised exception class EIBCError with message ' > Dynamic SQL Error > SQL error code = -104 > Token unknown - line 57, column 19 > BB'. You most likely used a double quote instead of two

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

Re: [firebird-support] Embedded FB3 was killed?

2016-04-19 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
19.04.2016 19:56, galdari...@yahoo.com.br [firebird-support] wrote: > Release Notes says nothing about it. Read carefully "Remodelled Architecture" part. -- WBR, SD.

Re: [firebird-support] download link for fb 3 embedded?

2016-05-25 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
25.05.2016 12:23, korkl...@yahoo.it [firebird-support] wrote: > where are the embedded packages for fb3? Not exists anymore. Read Release Notes about changes in server architecture. -- WBR, SD.

Re: [firebird-support] Re: download link for fb 3 embedded?

2016-05-25 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
25.05.2016 13:03, korkl...@yahoo.it [firebird-support] wrote: > do you think that is a normal way to get them? No. All you need is to download and unpack zip package of corresponding bitness. For example,

Re: [firebird-support] Occasionally need to specify port number in connectiong string to connect over network

2016-07-26 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
26.07.2016 12:35, Rodney Tapit rodta...@gmail.com [firebird-support] wrote: > Can you please advise what factors govern whether the port number needs to be > included > given that the RemoteServicePort is defined in the firebird.conf? In such cases your application, probably, uses different

Re: [firebird-support] Re: Triggers on table MON$ATTACHMENTS

2016-07-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.07.2016 15:39, 'Ismael L. Donis Garcia' sli...@citricos.co.cu [firebird-support] wrote: > Unexpected end of command - line 6, column 35 If you execute this in isql, RTFM Language Reference for "SET TERM" command. -- WBR, SD.

Re: [firebird-support] php transactions

2016-07-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.07.2016 22:28, 'Daniel Miller' dmil...@amfes.com [firebird-support] wrote: > Could my problem be that I need to use explicit transactions for the selects > as well? Yes. -- WBR, SD.

Re: [firebird-support] Incorrect values within SQLDA structure SQLDA version expected between 1 and 1, found 0 when using Firebird 3.0 client with older (BDE) programa

2016-07-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.07.2016 13:33, jonatan.laurit...@yahoo.dk [firebird-support] wrote: > Is this bug in Firebird 3.0 client and is there workaround? This is a bug in BDE and you must ask for workaround at Embarcadero support. -- WBR, SD.

Re: [firebird-support] Incorrect values within SQLDA structure SQLDA version expected between 1 and 1, found 0 when using Firebird 3.0 client with older (BDE) programa

2016-07-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.07.2016 16:29, Marsupilami79 marsupilam...@gmx.de [firebird-support] wrote: > The problem there would be that the BDE has reached its end of life for > some years now... It is not Firebird's problem as well. -- WBR, SD.

Re: [firebird-support] Cannot create simple table

2016-07-21 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
21.07.2016 22:40, 'stwizard' stwiz...@att.net [firebird-support] wrote: > Any ideas? Shorten name of the PK_CUR_CASE_INV_NON_JUD_CNT constraint. -- WBR, SD.

Re: [firebird-support] Cannot create simple table

2016-07-21 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
21.07.2016 23:02, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] wrote: > Why? Just a shoot to darkness. > It is only 27 characters in length! Exactly. This is a magic number. -- WBR, SD.

Re: [firebird-support] Firebird 3 encryption in the background

2016-08-02 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
02.08.2016 13:03, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > i agree that will be good to see possibility to check finished state gstat and monitoring tables are for that. -- WBR, SD.

Re: WG: [firebird-support] Firebird 3 encryption in the background

2016-08-02 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
02.08.2016 15:39, Ralf Jansen ralf.jan...@mailstore.com [firebird-support] wrote: > But what about stopping/resuming the progress? Encryption is stopped when database unloaded for superserver or at disconnect for classic. Encryption is resumed on any next attach. -- WBR, SD.

Re: [firebird-support] Re: Error while parsing procedure procname's BLR

2016-07-15 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
15.07.2016 10:49, Norbert Saint Georges n...@tetrasys.eu [firebird-support] wrote: > I renamed fbclient in myfbclient That's a very bad idea. Whole server rely on fbclient.dll with exactly that name. -- WBR, SD.

Re: [firebird-support] Server reboot during Windows exe setup?

2016-07-15 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
15.07.2016 9:56, Stefan Heymann li...@stefanheymann.de [firebird-support] wrote: > Is there a remote chance that this reboot has anything to do with the > Firebird installation then went on at that very second? Can it be > related to the installation of the Win32 runtimes that was going on at >

  1   2   3   4   5   6   7   8   >