Good morning.
I am using the SYSDBA account on using Windows 7 , Firebird 2.5 (x64) and
FlameRobin
Here is the message I get.
SQL Message : -923 Connection not established
Engine Code : 335544421
Connection rejected by remote interface
This looks like a permissions issue, although the error
Dear Alan,
Thanks for your reply.
This is my table ddl :
CREATE TABLE LOG
(
ID Integer NOT NULL,
ID_TBL Integer NOT NULL,
TBL_NM Varchar(40) NOT NULL,
OPR Char(1) NOT NULL,
LOG_AT Timestamp DEFAULT CURRENT_TIMESTAMP NOT NULL,
SNC Smallint DEFAULT 0,
PRIMARY KEY (ID)
);
I think, I found the
Hi,
Pleas show us
gstat -h
and plan for this query
I see 4 possibilites but can be more...
1. Long running transaction
2. Hard drive i to slow ( many operations on it)
3. Network problem try ping
4. You youse big amount of transaction - look at readonly transaction by it you
can check if you
I think, I found the problem.
I made a small app that seek for snc's value every second. It seems makes
firebird server
works heavily.
Changing seeking time from 1 second to 10 seconds seems solved the problem.
Have you considered using events, Anto? I.e. rather than the client
continuously
Dear Alan,
Thanks for your reply.
This is my table ddl :
CREATE TABLE LOG
(
ID Integer NOT NULL,
ID_TBL Integer NOT NULL,
TBL_NM Varchar(40) NOT NULL,
OPR Char(1) NOT NULL,
LOG_AT Timestamp DEFAULT CURRENT_TIMESTAMP NOT NULL,
SNC Smallint DEFAULT 0,
PRIMARY KEY (ID)
);
I think, I found the
It can be several issues, my guess is that flamerobin is 32bit version and is
loading a old version of fbclient
try to reinstall all to be 64bit versions (Firebird 2.5.x , Flamerobin x64 ...)
http://stackoverflow.com/a/7520588/66242
ps: or it could be a wrong password
--- In
On Sun, 3 Mar 2013 23:20:59 -0800 (PST), Ronan van Riet
ronanvanr...@ymail.com wrote:
Good morning.
I am using the SYSDBA account on using Windows 7 , Firebird 2.5 (x64)
and
FlameRobin
Here is the message I get.
SQL Message : -923 Connection not established
Engine Code : 335544421
Hello Mariuz.
I am not able to locate the FlameRobin x64 download link, do you perhaps have
it?
Thanks,
Ronan
From: mariuz mar...@mariuz.android-dev.ro
To: firebird-support@yahoogroups.com
Sent: Monday, March 4, 2013 12:34 PM
Subject: [firebird-support]
On Mon, 4 Mar 2013 05:37:43 -0800 (PST), Ronan van Riet
ronanvanr...@ymail.com wrote:
Hello Mariuz.
I am not able to locate the FlameRobin x64 download link, do you perhaps
have it?
http://sourceforge.net/projects/flamerobin/files/flamerobin/0.9.2/
(through http://www.flamerobin.org/
Thanks Mark.
Say, where do I configure the port number and host name? These fields are not
available in FlameRobin.
Which other UI should I be looking at?
Thanks in advance,
Ronan
From: Mark Rotteveel m...@lawinegevaar.nl
To: firebird-support@yahoogroups.com
On Mon, 4 Mar 2013 05:43:54 -0800 (PST), Ronan van Riet
ronanvanr...@ymail.com wrote:
Thanks Mark.
Say, where do I configure the port number and host name? These fields
are
not available in FlameRobin.
Which other UI should I be looking at?
It is part of the server registration (can't be
Thank you Mark.
For the benefit of others, installing FlameRobin x64 resolved my problem. I am
now able to create my new FB database.
Best regards,
Ronan
From: Mark Rotteveel m...@lawinegevaar.nl
To: firebird-support@yahoogroups.com
Sent: Monday, March 4,
Hello,
I turned my Firebird 1.5 database into Firebird 2.5 database (with the usefull
FBClone (http://code.google.com/p/fbclone/).
Now I'm testing my application in Delphi 5 where my ib_connection.charset is
now defined to WIN1252 and all seemed to work fine with the firebird 2.5 and
Hello Marianne
How do you use fbclone?
It is a command-line tool, but I can not find its documentation, just the
syntax.
Greetings.
Walter.
On Mon, Mar 4, 2013 at 11:08 AM, caste...@titelive.be wrote:
**
Hello,
I turned my Firebird 1.5 database into Firebird 2.5 database
Hello, castel!
Monday, March 4, 2013, 7:08:52 PM, you wrote:
cmtb Now I'm testing my application in Delphi 5 where my
cmtb ib_connection.charset is now defined to WIN1252 and all seemed
cmtb to work fine with the firebird 2.5 and utf8.
cmtb Until i tried to create a record where the field
This is the error message I get:
Use CONNECT or CREATE DATABASE to specify a database
SQL create database '/srv/firebird/rfinventory.fdb' user 'SYSDBA' password
'masterkey';
Statement failed, SQLSTATE = 08006
Error reading data from the connection.
I have made sure that the '/srv/firebird/'
After backup we do a test restore:
gbak -v -se server_name:service_mgr -use_all_space -r backup.fbk
test.fdb
Normally we just delete the file after gbak completes, but I'd like to
be nicer to the database server. Some coworkers have also been saying
they think that Firebird is still using the
Hello, Rick!
Monday, March 4, 2013, 11:07:12 PM, you wrote:
RD After backup we do a test restore:
RD gbak -v -se server_name:service_mgr -use_all_space -r backup.fbk
RD test.fdb
RD Normally we just delete the file after gbak completes, but I'd like to
RD be nicer to the database server.
I
Monday, March 4, 2013, 11:07:12 PM, you wrote:
RD After backup we do a test restore:
RD gbak -v -se server_name:service_mgr -use_all_space -r backup.fbk
RD test.fdb
RD Normally we just delete the file after gbak completes, but I'd like
RD to be nicer to the database server.
I wonder
Hello Walter,
As Konstantin said, i used -help and put the results in a text file.
fbclone.exe -help helpfile.txt
so that i can read it more easily.
greetings,
Marianne
[Non-text portions of this message have been removed]
Why does ibase_blob_echo sometimes fail to retrieve blob contents when
using PHP? I have searched all over for a solution to this without any
success.
Someone please help me out here.
Thanks,
Mags
[Non-text portions of this message have been removed]
Thanks Dmitry.
I'll have a look at this tomorrow.
Greetings,
Marianne
[Non-text portions of this message have been removed]
Mags Phangisa wrote:
Why does ibase_blob_echo sometimes fail to retrieve blob contents when
using PHP? I have searched all over for a solution to this without any
success.
Someone please help me out here.
Well for php support ...
http://groups.yahoo.com/group/firebird-php/
Drop your
Need a lot of help. Urgently. Using FB version 1.5.6.
I am having a few databases reporting Internal GDS errors that allow the
database to be backed up but do not allow it to be restored. Most of them have
reported I/O errors 10054 at one time or another. Most of these are databases
of 40 GB
I wonder that you
- use -use_all_space for test database. You see real speedup?
It requires less space for the test.
- delete restored database. Why you keep backup, that needed to be
restored again at some reasons? Instead, better keep database, delete
backup.
The backup is written to tape.
Dear Bogdan,
I have already add index on snc field.
Thanks Best regards,
Anto.
Hi
I would also add a compounded index snc + ID, or just snc
Regards Bogdan
[Non-text portions of this message have been removed]
Hello, Rick!
Tuesday, March 5, 2013, 1:36:21 AM, you wrote:
RD It requires less space for the test.
How much less in your case?
RD The backup is written to tape.
well, I understood why you store backup, but not
restored database. Also trying to have less space for backup.
The end of gbak is
Hello, Sean!
Monday, March 4, 2013, 11:42:44 PM, you wrote:
LS You missed a key point from Rick's post ... After backup we do a ***test
restore***
LS Obviously, Rick is double checking that the backup is valid.
missed nothing. Test restore does not differ from usual restore.
LS As for
28 matches
Mail list logo
