Hi,
Does anybody have any idea what could cause the following error on
backup using FB2.5
regards
Si
*** IBPP::SQLException ***
Context: ServiceImpl::Wait
Message: isc_service_query failed
SQL Message : -902
Unsuccessful execution caused by a system error that precludes
successful execution
Hello,
This is a database corruption, most likely caused by bad RAM.
Another reason could be accessing Firebird database with wrong version
of engine (InterBase? old Firebird?).
Download free FBFirstAID version, check your database and send log for
free investigation to our support team:
On 16 January 2012 19:12, Dmitry Yemanov dim...@users.sourceforge.netwrote:
16.01.2012 18:42, Nick Upson wrote:
I've just found http://tracker.firebirdsql.org/browse/CORE-2630
which leads to http://tracker.firebirdsql.org/browse/CORE-2993 which
says
its fixed in 2.1.4
They're
17.01.2012 15:00, Jesús García wrote:
Avoid using nbackup or nbackup before 2.5?
The latter, if you use Classic under high load.
Dmitry
Hi,
I was under the impression that copying a database that is currently in use can
cause a corruption because windows xcopy might deny the Firebird server access
to that file momentarily. I was looking for an official statement on this for a
customer of mine and found this:
On Tue, 17 Jan 2012 11:44:53 +, Maya Opperman
m...@omniaccounts.co.za
wrote:
Hi,
I was under the impression that copying a database that is currently in
use can cause a corruption because windows xcopy might deny the Firebird
server access to that file momentarily. I was looking for an
Hi,
If I want to drop a column-level default, in firebird 2.x I can do
ALTER TABLE tablename ALTER [COLUMN] colname DROP DEFAULT
But, if [COLUMN] has not a default value setting, that statement raise
an error.
The question is, How can I to know if a field has set a default value?
Query
If I want to drop a column-level default, in firebird 2.x I can do
ALTER TABLE tablename ALTER [COLUMN] colname DROP DEFAULT
But, if [COLUMN] has not a default value setting, that statement raise
an error.
The question is, How can I to know if a field has set a default value?
Query
Hello Maya,
Not everything is listed there.
More details can be found here: Firebird and InterBase corruptions
reasons http://ib-aid.com/articles/item70
Regards,
Alexey Kovyazin
IBSurgeon
Hi,
I was under the impression that copying a database that is currently
in use can cause a
Thanks, I will look into this
rgds
Si
On 17 January 2012 08:30, Alexey Kovyazin a...@ib-aid.com wrote:
Hello,
This is a database corruption, most likely caused by bad RAM.
Another reason could be accessing Firebird database with wrong version of
engine (InterBase? old Firebird?).
I was under the impression that copying a database that is currently in use
can cause a corruption because windows xcopy might deny the Firebird server
access to that file momentarily. I was looking for an official statement on
this for a customer of mine and found this:
thanks, thats great
Nick Upson
On 17 January 2012 12:00, Dmitry Yemanov dim...@users.sourceforge.netwrote:
**
17.01.2012 14:06, Nick Upson wrote:
please could you expand on that advice, what is the problem with nbackup
in
2.1.4?
It's really hard to explain briefly, but nbackup has
(my previous post appeared under another thread, as I did reply. I write
again to start new thread - sorry if someone gets 2 times).
how to create a stored procedure having a list of values as input parameter?
I need to retrieve result for query looking like
select field1, field2 from table1
Hi,
Maybe someone will come up with a more elegant solution, but if not,
here's a simple trick.
Pass your list of values as a string, separating values with commas
(take care not to add extra spaces between values etc.). Suppose the
parameter name in the procedure is par_list and the string
Hello,
A cli e nt recently had their application changed to run firebird rather
than paradox . It worked fine, with MS Access apps connecting to provide
data feeds from firebird. It is version 1.5 I am told.
Then it was moved to a windows server 2008.
I can no longer get MS Access to
15 matches
Mail list logo