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

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 que

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] 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] firebird and transaction behaviour questions

2016-02-23 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
23.02.2016 16:03, 'Zoran' zoran...@gmail.com [firebird-support] wrote: > Why would you use transaction for select statements? For data consistency. People like consistent data in reports. > No. For ONE row at the time you don't need a transaction. If you are > changing multiple rows, then you

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

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

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

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

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 i

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 trac

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] Re: UDF install in FB3.0 RC2

2016-03-19 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
18.03.2016 3:55, russ...@belding.co.nz [firebird-support] wrote: > So there is some requirement for UDF dlls in FB3RC2 which the dlls in FB2.x, > at least the > ones I have used, do not meet and they fail to work with FB3RC2. RFunc is known by bugs inside and dependency on gds32.dll. You must

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 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] Compiling clients with MinGW-W64 ibase.h, STATUS and __x86_64__

2016-03-30 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
30.03.2016 20:53, Mike Ro miker...@gmail.com [firebird-support] wrote: > But MinGW-W64 does not define _WIN64, so intptr_t is not typedef'd > correctly. But it defines __GNUC__ that cause inttypes.h to be included and _INTPTR_T_DEFINED defined. -- 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 be

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] 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] 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] 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] 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, POSITION('

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

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

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 bool

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

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] 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: 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] 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] 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. -- W

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

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

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 th

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] 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] 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] 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] Merge in Fb3 fails

2016-05-15 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.05.2016 22:04, kyle...@yahoo.com [firebird-support] wrote: > Above works. Merge below fails: > > merge into ZipCodeRef T1 > using ZipCodeDataBus T2 > on T2.ZipCode = T1.ZipCode > when not matched then > insert (ZipCode, Longitude, Latitude) values (T2.ZipCode, T2.Longitude, > T2.Latitude);

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

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, https://sourceforge.net/projects/firebird/files/firebird-win32/3.0-Release/Firebird-3.0

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] 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' starti

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

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. http://www.ibphoenix.com/products/software/ibreplicato

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 http://www.firebirds

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] Re: Max RAM for Database Cache in SS FB 3.0 64bit is to small?

2016-06-02 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
02.06.2016 15:12, fabia...@itbizolutions.com.au [firebird-support] wrote: > the limit remains as in FB 2.5, meaning you cannot enter a value above 131071 > pages , now > I don't know if the bug is on IBExpert, or if Firebird 3.0 rejects the value. Try gfix and you'll see. -- 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] 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] 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] 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 wi

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

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

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

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] Strange Behavior

2016-06-22 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
22.06.2016 8:44, 'Mihalache Bogdan' bogdan.mihala...@soter.ro [firebird-support] wrote: > - On the machines where the new values was not visible, i have > restarted the > connection (Close the App and ReOpend it), but still the old value was there, > not the new one. Most likely the

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" "e:\te

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] FDR file in Firebird folder

2016-06-28 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
28.06.2016 19:46, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > I've never heard of such a file, does anyone have an idea what it could be? I would bet on a database. -- WBR, SD. ++

Re: [firebird-support] FDR file in Firebird folder

2016-06-28 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
28.06.2016 20:28, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > My thought as well, but I just want to make sure it isn't some sort of > temporary file or something else ;) Firebird don't use .FDR extension for any internal file. -- WBR, SD.

Re: [firebird-support] (unknown)

2016-06-29 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
29.06.2016 10:28, Якушев Евгений annino...@yandex.ru [firebird-support] wrote: > So here is the question: is it a Firebird bug or something wrong with the > windows server? > Unfortunatelly we have not found any usefull sollution on the web. http://www.ibase.ru/keepalive/ -- WBR, SD. --

Re: [firebird-support] Unable to backup production database with gbak and SuperServer 3

2016-07-04 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
04.07.2016 14:31, Köditz, Martin martin.koed...@it-syn.de [firebird-support] wrote: > Is there a restriction with backup on SuperServer? No, unless you are trying to do backup in embedded mode (what exactly you do). -- WBR, SD.

Re: [firebird-support] Re: Simple create or alter procedure on Firebrid 3.0 creates "unsuccessful execution caused by system error that precludes successful execution of subsequent statements"

2016-07-07 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
07.07.2016 9:57, jonatan.laurit...@yahoo.dk [firebird-support] wrote: > OK. After Firebird 64 bit installation it was necessary to make Firebird32 > bit client > installation and with Firebird 3.0 32bit fbclient.dll/gds32.dll this > statement can be > executed normally. Execution of statement

  1   2   3   4   5   6   7   8   >