Re: [firebird-support] Doubts about Firebird in Linux....

2018-05-16 Thread Aldo Caruso aldo.car...@argencasas.com [firebird-support]
I'm running Firebird on Linux since many years, with the following environment: 1. Ubuntu 14.04 ( I've also run it on Debian 6.0 ) 2. ext4 3. Journaling 4. Firebird 2.5.2 Aldo Caruso El 16/05/18 a las 20:43, Javier Cintron fcintr...@yahoo.com [firebird-support] escribió: Firebird ver

[firebird-support] Doubts about Firebird in Linux....

2018-05-16 Thread Javier Cintron fcintr...@yahoo.com [firebird-support]
Firebird ver 2.5.7.27050 64 bitsSuperserverWindows Server 2012R2 I am planning to change the operating system that hosts our ERP's Firebird Databases from Windows Server 2012R2 to Linux and I have some questions about it: - Which Linux distribution do you recommend? I have experience

Re: [firebird-support] Bulk upload options

2018-05-16 Thread 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]
Script is just a bunch of SQL statements executed in sequence. An insert script will never be faster than using prepared parametrized statements, since with scripts, Firebird will have to prepare/execute statements one by one. For specific cases, user may try to put the "inserts" inside an

Re: [firebird-support] Firebird 3 Wire compression encrypt basic setup ?

2018-05-16 Thread Issam Boughanmi amigof...@gmail.com [firebird-support]
thanks a lot .

Re: [firebird-support] Bulk upload options

2018-05-16 Thread hamacker sirhamac...@gmail.com [firebird-support]
months ago, I test method load data from script (sorry I dont test load from csv) and transfer source/to. Well, script is fast, but when error occour you need to correct file and try again and it´s not easy edit from huge file (only gvim app I can manipulate fast) Easy method that I choose

Re: [firebird-support] Firebird and Windows 10 update

2018-05-16 Thread fo...@darsys.com.ar [firebird-support]
Hi Solved SMB2 was disable. In addition, W2012 was updated today, and it caused a firewall problem, that was solved by deleting all firewall politics. Thank you all so much Manuel

Re: [firebird-support] Firebird 3 Wire compression encrypt basic setup ?

2018-05-16 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2018-05-16 21:07, Issam Boughanmi amigof...@gmail.com [firebird-support] wrote: > hi Mark, thanks for the great answer :) > > ok let's forget Fb3 wire thing ... > like i said i have already a working zebedee setup, now what is the > main benefit for using ssh instead apart that zebedee

Re: [firebird-support] Firebird 3 Wire compression encrypt basic setup ?

2018-05-16 Thread Issam Boughanmi amigof...@gmail.com [firebird-support]
hi Mark, thanks for the great answer :) ok let's forget Fb3 wire thing ... like i said i have already a working zebedee setup, now what is the main benefit for using ssh instead apart that zebedee development is stopped in 2005 :p ? ps : in the firebird faq there is a mention about ssl too ,

Re: [firebird-support] Bulk upload options

2018-05-16 Thread fabia...@itbizolutions.com.au [firebird-support]
Well, let's think this through When firebird executes the following command it does it extremelly quickly: Insert into Table Select * from Table That probably is because the sentence insert into table expects multiple results from the Select statement. isql on the other hand will have to

Re: [firebird-support] Bulk upload options

2018-05-16 Thread hamacker sirhamac...@gmail.com [firebird-support]
I dont know bulk method in firebird. You can write scripts, scripts is more fastest than transfer from machine to another. You can run isql.exe < script.sql If is not possible to create scripts then use (hard) commit each 1000 (or more) transfers, if you not to do, transaction will be slowing at

RE: [firebird-support] Firebird and Windows 10 update

2018-05-16 Thread 'Primoz Jenko' primoz.je...@domplan.si [firebird-support]
Hi to all! We have 100% similar problem. And link to a blog (solution describe there) is our solution too! Thank you very much to all! We hope we will be able to provide some answer as well on some other problem. Best wishes! Primoz From: firebird-support@yahoogroups.com

Re: [firebird-support] Re: Doubt about TempCacheLimit parameter...

2018-05-16 Thread Javier Cintron fcintr...@yahoo.com [firebird-support]
Thank you very much! On Wednesday, May 16, 2018, 7:01:14 AM CDT, Dmitry Yemanov dim...@users..sourceforge.net [firebird-support] wrote:   16.05.2018 07:05, Javier Cintron wrote: > Firebird ver 2.5.7.27050 64 bits > Superserver > Windows Server

Re: [firebird-support] Firebird 3 Wire compression encrypt basic setup ?

2018-05-16 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 15-5-2018 22:00, Issam Boughanmi amigof...@gmail.com [firebird-support] wrote: > i  have  a firebird 3 database hosted on internet  wich i want to access > it via a desktop application . > for that i need to make the communication as secure as possible . > > i have tested zebedee and it

[firebird-support] Re: Doubt about TempCacheLimit parameter...

2018-05-16 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
16.05.2018 07:05, Javier Cintron wrote: > Firebird ver 2.5.7.27050 64 bits > Superserver > Windows Server 2012R2 > > What is the unit of TempCacheLimit? Bytes. Settings > 4GB are not supported. Dmitry

Re: [firebird-support] Firebird and Windows 10 update

2018-05-16 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 16-5-2018 02:54, Helen Borrie hele...@iinet.net.au [firebird-support] wrote: > fo...@darsys.com.ar wrote: > >> Hi > >> Since few hours ago, in some customers after Windows 10 update, my app can >> not connect to server. > >> Fb server works, and clients with previous Windows versions work.

Re: [firebird-support] Firebird and Windows 10 update

2018-05-16 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 15-5-2018 23:50, fo...@darsys.com.ar [firebird-support] wrote: > Since few hours ago, in some customers after Windows 10 update, my app > can not connect to server. > > Fb server works, and clients with previous Windows versions work. > > > Error; 8004 - Unable to complete server request to

Re: [firebird-support] Firebird and Windows 10 update

2018-05-16 Thread 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support]
Hi all, Could this be related to: https://blog.mertech.com/windows-10-version-1803-breaks-some-shared-folder-applications "This means that applications started from these environments can’t open a connection to a database server." With regards, Martijn Tonies Upscene Productions

Re: [firebird-support] Bulk upload options

2018-05-16 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
16.05.2018 4:48, fabia...@itbizolutions.com.au [firebird-support] wrote: > Does anyone have experience with bulk updates via isql? Would it be X times > faster than using a normal application inserting the records inside a begin > transaction and commit at the end? No, because it is exactly