Re: [firebird-support] String right truncation Error

2012-02-26 Thread Mark Rotteveel
On 25-2-2012 20:11, Aldo Caruso wrote: Mark, I really don't know why, in the Debian stable version, the Firebird SS package isn't the final one but a Release Candidate. On the other hand, your advice worked fine, although I don't figure why. In this context, an EXIST

[firebird-support] Presumed server conflict with WHS 2003

2012-02-26 Thread Don Davis
Is there a known conflict between Firebird and Windows Home Server 2003? Or does WHS host prohibit Firebird from acting as a server? I recently installed Firebird 2.5.1.26351 (Win32) as a full server on my Windows Home Server 2003 machine. I created a test database using Virtual Volumes View

[firebird-support] Several questions about Firebird ODS

2012-02-26 Thread vklimov45
Recently I did some database rescue, but after that decided to make simple IBSurgeonViewer like utility to view data structure (how data structured, where it defined and how to bind everything together). And I got several questions-problems (based on FB 2.5 sources): 1. dtype_varying defined

[firebird-support] Freezing Firebird Database after working for sometime

2012-02-26 Thread Gustavo Moda
Hi, We have a system developed in PHP withFirebird database and Jboss running for a services communications with the Brazilian government's WebService. After migrating for a new DELL server due to performance issues, Firebird is freezing after working for sometime. The PID of firebird and

[firebird-support] Can't add primary key

2012-02-26 Thread michellelsawyer
I am trying to add a primary key to a table but when I finish the alter table script runs and says that primary key already exists. However, the primary key does NOT exists. I have tried logging out and back in thinking it was a refresh issue but there is still no primary key shown.

Re: [firebird-support] Freezing Firebird Database after working for sometime

2012-02-26 Thread Mercea Paul
On 2012.02.25 9:56 PM, Gustavo Moda wrote: INET/inet_error: connect errno = 111 Maybe you could have some network problems ( for VM )! Regards, -- Paul MERCEA ___ E-mail: paul.mer...@almexa.ro ___

Re: [firebird-support] Freezing Firebird Database after working for sometime

2012-02-26 Thread Alexey Kovyazin
Hello Gustavo, There are 2 reasons for freezing - inefficient SQLs and wrong transactions/garbage strategy. These reasons cover 99,9% of problems with freezing. Consider to have support from some knowledgeable Brazil professionals http://www.firebirdsql.org/en/firebase-brazil/ or learn how