[firebird-support] Re: request synchronisation error

2016-03-19 Thread hv...@users.sourceforge.net [firebird-support]
If your application not see such error - don't worry. Sooner of all it is related with prefetch logic by network server and handled by it internally. Regards, Vlad

[firebird-support] request synchronisation error

2016-03-19 Thread 'Checkmail' check_m...@satron.de [firebird-support]
Hello, we traced to find performance problems and we saw some messages output for example the following: 2016-03-17T09:01:52.5030 (2544:0C661670) ERROR AT JRequest::receive D:\INTERBASE\IFLS.GDB (ATT_21976, SYSDBA:NONE, NONE, TCPv4:192.168.0.70/50182)

[firebird-support] Re: Error with > 10 columns in SQL SELECT query using python firebirdsql

2016-03-19 Thread ggoo...@yahoo.com [firebird-support]
Thanks for this, I think you are right. A near identical installation on the production system didn't show this problem, and when I updated the firebirdsql python package on the test system the problem resolved. The database is primarily used as the backend for a niche commercial radiation

ODP: [firebird-support] Compiling stored procedure while database in production

2016-03-19 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
hi, you use very old version of Firebird with many bugs. First update Firebird to 2.5.5 or snapshot 2.5.6 regards,Karol Bieniaszewski Oryginalna wiadomość Od: "mailgro...@murdochfl.com [firebird-support]" Data: 17.03.2016 03:43

Re: [firebird-support] RECREATE Procedure issue.

2016-03-19 Thread Joje j...@codework-solutions.com [firebird-support]
I am using firebird 2.5.5 version. As my application is .net application I am using Firebirdclient.dll to interact with firebird database. Also I am executing the query inside my .net application. There are many queries in my .net application, only this 'RECREATE' query fails to execute while

[firebird-support] Re: UDF install in FB3.0 RC2

2016-03-19 Thread hv...@users.sourceforge.net [firebird-support]
> ---In firebird-support@yahoogroups.com, wrote : > > If we dismiss rfunc.dll because it has bugs then I mention ib_udf.dll (the > > one with FB2.x) and freeUDFLib.dll (that works under FB2.x). > Both dlls install into fb3rc2. Both fail in the manner I described. So what > is

Re: [firebird-support] Re: [OffTopic] Sphinx for Firebird on Windows 2003

2016-03-19 Thread hv...@users.sourceforge.net [firebird-support]
> ---In firebird-support@yahoogroups.com, wrote : > > Hi Vald, > > That was what I tried first, but unfortunately this build will not run on > Windows Server 2003. Got it. It doesn't run on W2K3 because VS 2013 doesn't support XP\W2K3 by default. I'll re-build it a bit

Re: [firebird-support] RECREATE Procedure issue.

2016-03-19 Thread Helen Borrie hele...@iinet.net.au [firebird-support]

Re: [firebird-support] RECREATE Procedure issue.

2016-03-19 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
Hello j...@codework-solutions.com, Saturday, March 19, 2016, 11:51:23 PM, you wrote: > Regarding thus issue could someone raise a ticket & update the documentation > of firebird. Not necessary. The documentation is under review at this stage. I have added warnings to both RECREATE PROCEDURE

Re: [firebird-support] RECREATE Procedure issue.

2016-03-19 Thread Joje j...@codework-solutions.com [firebird-support]
I am executing this query using my .net application and it is not throwing any error. If there was a error then it would log that error and will display it to the user. I executed this query in my third party SQL Manager and it throws an error /Invalid token.// //Dynamic SQL Error.// //SQL

Re: [firebird-support] RECREATE Procedure issue.

2016-03-19 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2016-03-18 9:10, Joje j...@codework-solutions.com [firebird-support] wrote: > I am executing this query using my .net application and it is not > throwing any error. If there was a error then it would log that error > and will display it to the user. If it is not throwing an error, then I

Re: [firebird-support] Re: [OffTopic] Sphinx for Firebird on Windows 2003

2016-03-19 Thread Alexander Tabakov a.taba...@eklektica.com [firebird-support]
Hi Vlad, My mistake about -id64. The *win32-xp *build is running just fine on W2K3, so once again thank you. Regards Alex On Sat, Mar 19, 2016 at 2:26 PM hv...@users.sourceforge.net [firebird-support] wrote: > > > > ---In firebird-support@yahoogroups.com,

[firebird-support] Re: [OffTopic] Sphinx for Firebird on Windows 2003

2016-03-19 Thread hv...@users.sourceforge.net [firebird-support]
> ---In firebird-support@yahoogroups.com, wrote : > > Hi Vlad, > > Thanks a lot. Can you by chance rebuild it with -id64 support or it will be > too much of a hassle? -id64 is already ON by default, see

Re: [firebird-support] Error with > 10 columns in SQL SELECT query using python firebirdsql

2016-03-19 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2016-03-17 5:54, ggoo...@yahoo.com [firebird-support] wrote: > I am querying a Firebird 1.5.3 database with python code using the > python firebirdsql module. All works well (query returns values as > expected) with up to 10 columns from two tables, but when I add an > 11th column I get the

Re: [firebird-support] RECREATE Procedure issue.

2016-03-19 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 19-3-2016 11:51, j...@codework-solutions.com [firebird-support] wrote: > Regarding thus issue could someone raise a ticket & update the > documentation of firebird. You can create tickets at http://tracker.firebirdsql.org/browse/DOC Mark -- Mark Rotteveel

Re: [firebird-support] RECREATE Procedure issue.

2016-03-19 Thread j...@codework-solutions.com [firebird-support]
Regarding thus issue could someone raise a ticket & update the documentation of firebird. Sent from Outlook Mobile On Sat, Mar 19, 2016 at 12:15 AM -0700, "Mark Rotteveel m...@lawinegevaar.nl [firebird-support]" wrote:  

[firebird-support] COALESCE

2016-03-19 Thread Tim Ward t...@telensa.com [firebird-support]
So I'm getting errors when there's a call to COALESCE with only a single parameter. (Why would we write code like that? - because nobody thought to spot it as a special case in our query generation code, perhaps.) So what does the Firebird book say? - well, my copy appears to say COALESCE

Re: [firebird-support] RECREATE Procedure issue.

2016-03-19 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 19-3-2016 04:44, j...@codework-solutions.com [firebird-support] wrote: > If it's not executing then it should send a message. Also I referred the > site documentation of recreate procedure. But there was no specific info > about dependency in stored procedure. > > But later when I referred the

[firebird-support] Events, any changing in fb 3 RC2?

2016-03-19 Thread 'Checkmail' check_m...@satron.de [firebird-support]
Hello, since FB 3 RC2 our C++ Application gets only the first post_event, some following there are not notice. Now we have insert a timer (sleep(500) after initevent) and it works (at the moment). Many Thanks

[firebird-support] Re: [OffTopic] Sphinx for Firebird on Windows 2003

2016-03-19 Thread hv...@users.sourceforge.net [firebird-support]
Hi Alex, try http://web.firebirdsql.org/download/sphinx/2.2.10/ http://web.firebirdsql.org/download/sphinx/2.2.10/ Regards, Vlad PS I was sure official site is updated with links to this build...

[firebird-support] Re: UDF install in FB3.0 RC2

2016-03-19 Thread russ...@belding.co.nz [firebird-support]
By experiments mentioned in this thread, UDF dlls that worked in FB 1 and 2 and not able to be used in FB 3 RC2.I am using 32 bit files. DLLs working in FB2.x can be placed in the FB3RC3 UDF folder and installed. "extractyear" is in rfunc.dll, used OK in FB2.x. When used in a FB3RC2 test,