Re: [firebird-support] Error Loading Pluggin Engine12

On Wed, 24 Jun 2020, 4:47 pm Dimitry Sibiryakov s...@ibphoenix.com [firebird-support], wrote: > 24.06.2020 13:14, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] > wrote: > > the Process Explorer reports the dll as under : > > > > D:\Program Files\Firebird\Firebir

Re: [firebird-support] Error Loading Pluggin Engine12

On Wed, Jun 24, 2020 at 2:10 PM Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 24.06.2020 03:07, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] > wrote: > > Use Process Explorer to find out which exactly fbclient.dll is > loaded. > &

Re: [firebird-support] Error Loading Pluggin Engine12

On Tue, Jun 23, 2020 at 9:53 PM Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 23.06.2020 18:07, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] > wrote: > > I have not set any environment variable. > > > > But I do have Firebird 3..0 install

Re: [firebird-support] Error Loading Pluggin Engine12

On Tue, Jun 23, 2020 at 9:12 PM Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 23.06.2020 17:35, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] > wrote: > > connect "192.168.0.2:/home/ubuntuUser/Firebird/MYDB.FDB" user 'SYSDBA' > password '

Re: [firebird-support] Error Loading Pluggin Engine12

On Tue, Jun 23, 2020 at 8:27 PM Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 23.06.2020 16:08, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] > wrote: > > Do not use embedded mode. > > > > I am not using embedded mode. > >Show

Re: [firebird-support] Error Loading Pluggin Engine12

On Tue, 23 Jun 2020, 7:37 pm Dimitry Sibiryakov s...@ibphoenix.com [firebird-support], wrote: > 23.06.2020 14:46, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] > wrote: > > But when I try to connect using Flamerobin, i get the message: > > > > Error loading plug

[firebird-support] Error Loading Pluggin Engine12

Hi, I have installed Firebird 3.0 on Ubuntu 20.04 machine and I am trying to connect through a Windows 10 machine. I am able to connect using isql from the Ubuntu and Windows machine both. But when I try to connect using Flamerobin, i get the message: Error loading plugin Engine12 Module

Re: [firebird-support] Ubuntu 18.04 Firebird 3.03 Server Connection String: Local Works, URL-Style Fails

On Fri, Apr 5, 2019 at 6:32 PM Rustam rusta...@ukr.net [firebird-support] < firebird-support@yahoogroups.com> wrote: > > > Check your FB client library. May be you are using 'embed' version > ('fbembed' instead of 'fbclient', or 'fbembed' renamed to 'fbclient') > 1. Edit the config file as under

Re: [firebird-support] Ubuntu 18.04 Firebird 3.03 Server Connection String: Local Works, URL-Style Fails

On Fri, Apr 5, 2019 at 4:49 PM Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > > > On 2019-04-05 12:22, LtColRDSChauhan rdsc1...@gmail.com > [firebird-support] wrote: > > Hello, > > > > 1. The following connection string works: > > > &

Re: [firebird-support] Ubuntu 18.04 Firebird 3.03 Server Connection String: Local Works, URL-Style Fails

On Fri, Apr 5, 2019 at 4:00 PM Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 05.04.2019 12:22, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] > wrote: > > 2. While following connection strings fails: > > Ubuntu_Machine:/home/ubuntu_user/Do

[firebird-support] Ubuntu 18.04 Firebird 3.03 Server Connection String: Local Works, URL-Style Fails

Hello, 1. The following connection string works: /home/ubuntu_user/Documents/Sample.FDB 2. While following connection strings fails: Ubuntu_Machine:/home/ubuntu_user/Documents/Sample.FDB localhost:/home/ubuntu_user/Documents/Sample.FDB 127.0.0.1:/home/ubuntu_user/Documents/Sample.FDB 3. The

Re: [firebird-support] Re: Deadlock error from firebird during midnight

On Fri, Dec 15, 2017 at 4:25 AM, LtColRDSChauhan wrote: > Ok, i will. > Thank you. > > On 15 Dec 2017 12:34 am, "Helen Borrie hele...@iinet.net.au > [firebird-support]" wrote: > > > > Hello LtColRDSChauhan, > > The net-provider list that you

Re: [firebird-support] Re: Deadlock error from firebird during midnight

Ok, i will. Thank you. On 15 Dec 2017 12:34 am, "Helen Borrie hele...@iinet.net.au [firebird-support]" wrote: Hello LtColRDSChauhan, The net-provider list that you have been posting to on Sourceforge is inactive. Any postings there are ignored. You need to

Re: [firebird-support] Re: Deadlock error from firebird during midnight

On Thu, Dec 14, 2017 at 5:22 PM, hv...@users.sourceforge.net [firebird-support] wrote: > > > ---In firebird-support@yahoogroups.com, wrote : > > On Thu, Dec 14, 2017 at 4:31 PM, hvlad@... [firebird-support] < > firebird-support@yahoogroups.com>

Re: [firebird-support] Re: Deadlock error from firebird during midnight

On Thu, Dec 14, 2017 at 4:48 PM, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] <firebird-support@yahoogroups.com> wrote: > 14.12.2017 12:03, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] > wrote: > > 1. Here server and client both are on the sam

Re: [firebird-support] Re: Deadlock error from firebird during midnight

On Thu, Dec 14, 2017 at 4:31 PM, hv...@users.sourceforge.net [firebird-support] wrote: > > > >>> 1. The PID remains same: 4212, before and after the exception is > caught. > > >> > >> I.e. there was no crash of Firebird, very good. > > >But still Firebird that

Re: [firebird-support] Re: Deadlock error from firebird during midnight

On Thu, Dec 14, 2017 at 4:11 PM, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] <firebird-support@yahoogroups.com> wrote: > 14.12.2017 11:34, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] > wrote: > > INET/inet_error: read errno = 10054, client host

Re: [firebird-support] Re: Deadlock error from firebird during midnight

On Thu, Dec 14, 2017 at 3:57 PM, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] <firebird-support@yahoogroups.com> wrote: > 14.12.2017 11:25, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] > wrote: > > I need to keep my deployed application running, and would h

Re: [firebird-support] Re: Deadlock error from firebird during midnight

On Thu, Dec 14, 2017 at 3:33 PM, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 14.12.2017 9:00, hv...@users.sourceforge.net [firebird-support] wrote: > >> 1. The PID remains same: 4212, before and after the exception is caught. > > > >

Re: [firebird-support] Re: Deadlock error from firebird during midnight

On 14 Dec 2017 13:30, "hv...@users.sourceforge.net [firebird-support]" < firebird-support@yahoogroups.com> wrote: >---In firebird-support@yahoogroups.com, wrote : >> On Thu, Dec 14, 2017 at 3:34 AM, hvlad@... [firebird-support] < firebird-support@yahoogroups.com> wrote:

Re: [firebird-support] Re: Deadlock error from firebird during midnight

On Thu, Dec 14, 2017 at 5:06 AM, LtColRDSChauhan wrote: > > > On Thu, Dec 14, 2017 at 3:34 AM, hv...@users.sourceforge.net > [firebird-support] wrote: > >> >> >> Looks like there was no crash of Firebird or WER doesn't catch it. >> >>

Re: [firebird-support] Re: Deadlock error from firebird during midnight

On Thu, Dec 14, 2017 at 3:34 AM, hv...@users.sourceforge.net [firebird-support] wrote: > > > Looks like there was no crash of Firebird or WER doesn't catch it. > > You may easy check if Firebird really crashed: just look at its PID > before and after > run

Re: [firebird-support] Re: Deadlock error from firebird during midnight

On Wed, Dec 13, 2017 at 5:26 PM, hv...@users.sourceforge.net [firebird-support] wrote: > > > > 1. In the firebird.config file set: > > > BugcheckAbort = 1 > > > Ok. > > Hope you restarted Firebird service after config editing. > > 1. Yes please. > > > 2.

Re: [firebird-support] Re: Deadlock error from firebird during midnight

On Wed, Dec 13, 2017 at 4:27 PM, hv...@users.sourceforge.net [firebird-support] wrote: > > > ---In firebird-support@yahoogroups.com, wrote : > > > 2. Fresh DMP files at: > > How do you produce Firebird dump ? > > It shows healthy process with

Re: [firebird-support] Re: Deadlock error from firebird during midnight

On Wed, Dec 13, 2017 at 1:09 PM, hv...@users.sourceforge.net [firebird-support] wrote: > > > > 1. I have obfuscated data in my database and again created the DMP files > after the crash. The pack at the URL below contains > > the DMP files (of the Firebird

Re: [firebird-support] Deadlock error from firebird during midnight

;> [firebird-support]" <firebird-support@yahoogroups.com> wrote: >> >> 12.12.2017 13:28, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] >> wrote: >> > 1. I have generated DMP files for : >> > (a) The Firebird server - size 62,028 KB a

Re: [firebird-support] Deadlock error from firebird during midnight

On Wed, Dec 13, 2017 at 2:22 AM, LtColRDSChauhan <rdsc1...@gmail.com> wrote: > > > On 12 Dec 2017 9:29 pm, "Dimitry Sibiryakov s...@ibphoenix.com > [firebird-support]" <firebird-support@yahoogroups.com> wrote: > > 12.12.2017 13:28, LtColRDSChauhan rdsc1

Re: [firebird-support] Deadlock error from firebird during midnight

On 12 Dec 2017 9:29 pm, "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]" <firebird-support@yahoogroups.com> wrote: 12.12.2017 13:28, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote: > 1. I have generated DMP files for : > (a) The Firebird server - size

Re: [firebird-support] Deadlock error from firebird during midnight

On Tue, Dec 12, 2017 at 4:18 PM, LtColRDSChauhan <rdsc1...@gmail.com> wrote: > > > On 12 Dec 2017 16:02, "Dimitry Sibiryakov s...@ibphoenix.com > [firebird-support]" <firebird-support@yahoogroups.com> wrote: > > 12.12.2017 7:32, LtColRDSChauhan rdsc1

Re: [firebird-support] Deadlock error from firebird during midnight

On 12 Dec 2017 16:02, "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]" <firebird-support@yahoogroups.com> wrote: 12.12.2017 7:32, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote: > “Error reading data from the connection” has again surfaced Thi

Re: [firebird-support] Deadlock error from firebird during midnight

Hello, “Error reading data from the connection” has again surfaced despite of using FbTransaction tx = con.BeginTransaction( new FbTransactionOptions() {TransactionBehavior = FbTransactionBehavior.Concurrency | FbTransactionBehavior.NoWait}); Please help ! Regards, Rajiv On Sun, Dec 3,

Re: [firebird-support] Deadlock error from firebird during midnight

On Sun, Dec 3, 2017 at 5:04 PM, DougC d...@moosemail.net [firebird-support] wrote: > > > Please, let us know what the cause ended up being and how you resolved the > problem! > > Alright, I will explain the issue in detail. 1. I have a .NET application of mine

Re: [firebird-support] Deadlock error from firebird during midnight

Do you get all the three errors all the time? In my case long running querry through .NET Provider raised error "error reading data from connection ". The same queries ran fine through flamerobin. Regards, Rajiv On 30 Nov 2017 19:01, "'Joje' j...@codework-solutions.com [firebird-support]"

Re: [firebird-support] Select with calculated field problem

Please check if you have null values. Regards, Rajiv On 28 Nov 2017 7:05 pm, "alauren...@gmail.com [firebird-support]" < firebird-support@yahoogroups.com> wrote: > > > Hi, > > > I have 2 tables and I want to select some data from them based on a common > records. In the query, one of the column

Re: [firebird-support] Copy Table to Another Database

On Tue, Nov 21, 2017 at 10:33 PM, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] <firebird-support@yahoogroups.com> wrote: > 21.11.2017 15:52, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] > wrote: > > Please see if the under mentioned procedure is good enough:

Re: [firebird-support] Copy Table to Another Database

On Tue, Nov 21, 2017 at 4:12 PM, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] <firebird-support@yahoogroups.com> wrote: > 21.11.2017 10:01, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] > wrote: > > How can I copy all records of a table to another table in di

[firebird-support] Copy Table to Another Database

Hello, How can I copy all records of a table to another table in different database. The tables having same design. Regards, Rajiv

[firebird-support] Listing Stored Procedure In Order of Dependencies

Hello, I need to update several procedures in my database. For that, how can I list my stored procedures ordered on dependencies as under : --- Stored Dependencies Procedures if any IN --- SP_1 NONE SP_2

[firebird-support] Failed To Locate Host Machine Under Changed Environment

Hello, 1. Recently migrated my OS and Firebird as under: (a) From Windows 10 Home 32 to 64 Bit (b) From Firebird-3.0.2.32703_0_Win32 to Firebird-3.0.2.32703_0_x64 2. Now, only when my smart phone has USB tethering OFF, attempt to connect through FlameRobin 0.9.3 (git hash 5ece15b) fails with

Re: [firebird-support] Firebird Server 64 Bit With 32 Bit Clients on Remote Machines

Thanks, SD. On 15 Jun 2017 1:27 pm, "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]" <firebird-support@yahoogroups.com> wrote: 15.06.2017 4:40, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote: > Is it correct to have Windows 32 clients on remote machin

[firebird-support] Firebird Server 64 Bit With 32 Bit Clients on Remote Machines

Hi, Is it correct to have Windows 32 clients on remote machines connecting to 64 Bit Firebird-3.0.2.32703_0_x64. I am constrained to Windows 32 clients due to 3rd party dependencies. Regards, Rajiv

Re: [firebird-support] internal firebird consistency check

Thank you, Paul. There were issues related to RAM and while attempting to upgrade RAM (and OS from 32 to 64 Bit) I lost the corrupted database. Regards, Rajiv On 13 Jun 2017 2:03 pm, "'Paul Beach' pabe...@waitrose.com [firebird-support]" wrote: <<1. I got

Re: [firebird-support] internal firebird consistency check

Hi Alexey, Thanks for your quick help. I think RAM is the issue. Regards, Rajiv On 10 Jun 2017 1:44 pm, "Alexey Kovyazin a...@ib-aid.com [firebird-support]" < firebird-support@yahoogroups.com> wrote: Hi, Usually such corruptions happen due to hardware problems. Check you RAM

[firebird-support] internal firebird consistency check

1. I got following error reported Firebird-3.0.2.32703_0_Win32 : "internal firebird consistency check (cannot find record back version (291), file: vio.cpp line: 4676)" 2. Environment: .Net Provider 5.9.1.0 FlameRobin 0.9.3 (git hash 5ece15b) Windows 10 Home Operating System 3. Back up reported

Re: [firebird-support] "EXTRACT (YEAR FROM DT.DATA) <= 2016" or "DT.DATA <= '12/31/2016'"

On Sat, Dec 10, 2016 at 12:37 AM, Louis Kleiman lklei...@sstms.com [firebird-support] wrote: > > > You can create an expression index on EXTRACT (YEAR FROM DT.DATA) to get > performance improvements in your first expression, but an index on plain > ol' DT.DATA

[firebird-support] Migration to [ Firebird 3 ] from [ Firebird 2.5, which was migrated back from Firebird 3 Beta ]

Hello,I had migrated back from Firebird 3 Beta to Firebird 2.5. Later during migration from Firebird 2.5 to 3I got violation of PRIMARY or UNIQUE KEY constraint "RDB$INDEX_2" on table "RDB$FIELDS" for SEC$USER_NAME and SEC$NAME_PART Hence renamed RDB$FIELD_NAME field values in the system table

[firebird-support] Temporary Table In Memory

Hi, 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 the join of tables again and again for each query. Thanks and regards, Rajiv

Re: [firebird-support] Listing Table of Database in Order of Dependency

On Mon, Mar 28, 2016 at 11:21 PM, setysvar setys...@gmail.com [firebird-support] wrote: > > > >Hi, > > Hi Rajiv! > > >How can i list tables of a database in order of dependency ie > > > >TABLE_1 (no foreign key references) > >TABLE_2 (foreign key references, if

Re: [firebird-support] Listing Table of Database in Order of Dependency

g direction of doing something. > > regards, > Karol Bieniaszewski > > > > Oryginalna wiadomość ---- > Od: "LtColRDSChauhan rdsc1...@gmail.com [firebird-support]" < > firebird-support@yahoogroups.com> > Data: 25.03.2016 11:36 (GMT+01:00) >

[firebird-support] Listing Table of Database in Order of Dependency

Hi, How can i list tables of a database in order of dependency ie TABLE_1 (no foreign key references) TABLE_2 (foreign key references, if any, in TABLE_1 ) TABLE_3 (foreign key references, if any, in TABLE_1 / TABLE_2 ) TABLE_4 (foreign key references, if any, in TABLE_1 / TABLE_2 / TABLE_3)

[firebird-support] Restoring from Firebird-2.5.4.26856_0_Win32 to Firebird-3.0.0.32136_0_Win32_RC1

Hello, 1. I installed Firebird-3.0.0.32136_0_Win32_RC1 on Windows 10 with the Security DB initialized for Legacy Authentication. Using Flamerobin, I registered Server and then registered the EMPLOYEE.FDB. 2. When I tried to restore Firebird-2.5.4.26856_0_Win32 backed up DB i'm getting the

Re: [firebird-support] Re: Restoring from Firebird-2.5.4.26856_0_Win32 to Firebird-3.0.0.32136_0_Win32_RC1

Vlad, 1. Renamed RDB$FIELD_NAME field values in the system table RDB$FIELDS of the source database as under: 'SEC$USER_NAME' to 'SEC$USER_NAME_RAJIV' 'SEC$NAME_PART' to 'SEC$NAME_PART_RAJIV' 2. Restore was successful. Thanks, Rajiv On Thu, Nov 12, 2015 at 4:20 PM, hv...@users.sourceforge.net

Re: [firebird-support] How to Extract Filename from file path inside a stored procedure?

SET TERM ^ ; create ExtractFileName( FILEPATH varchar(360) DEFAULT 'D:\Program Files\Firebird\Firebird_2_5\firebird.log' ) RETURNS ( FILENAME varchar(360) ) AS declare variable Loop_Break smallint default 0; declare variable POS_BK_SLASH smallint default 0; declare variable pathlength

Re: [firebird-support] Get records based on the third portion of a version string

Please try : SET TERM !! ; alter PROCEDURE SP_VERSION_NOS( PORTION smallint, SEPARATOR char, EARLIER_TO integer) RETURNS ( VERSION_NO varchar(80) ) AS declare variable i smallint; declare variable SEPARATOR_POS Integer; declare variable VERSION_PORTION varchar(80); declare

Re: [firebird-support] Get records based on the third portion of a version string

Please check this : SET TERM ^ ; ALTER PROCEDURE SP_VERSION_NOS ( PORTION smallint, SEPARATOR char(1), VERSION_UPTO varchar(80) ) RETURNS ( VERSION_NO varchar(80) ) AS declare variable i smallint; declare variable SEPARATOR_POS Integer; declare variable VERSION_UPTO_PORTION_INT