Hi all!
Is there a way to set connection timeout for firebird at client side?
The default value is somewhere around 50 seconds and if i have wrong IP address
set up in connection parameters then the application will freeze for almost a
minute before it gives an error message that it couldn't con
This is network problem, not Firebird problem. Make sure he ican access the
host machine.
On Friday, September 1, 2017, 7:52:35 PM GMT+3, dres...@tbinc.com
[firebird-support] wrote:
The exception they are getting is:
ISC ERROR CODE:335544721 ISC ERROR MESSAGE: Unable to complete
Hello!
How can i use ib_util in my UDF written is C language if ib_util is written in
C++? (i need ib_util_malloc from there)Is there also a C version available?Or
do i have to write my UDF in C++? (i'm not good in that language)
Thank you!
No, it has value of TRX12270
On Thursday, August 24, 2017, 12:56:09 PM GMT+3, Antônio Gomes
acgomes2...@yahoo.com.br [firebird-support]
wrote:
there no a null string?
De: "Nagy Szilveszter nagy_szilvesz...@yahoo.com [firebird-support]"
Para: Firebird-support
Hi,
i have an UDF function that runs perfectly on Linux 64 bit systems. I wanted to
port it to Windows 32 bit, but i'm having problems there.
The UDF was written in C (not C++), compiled on Linux with gcc, everything
works fine.
I compiled the same C file on Windows with MinGW Developer Studio (u
Check if your DLL is compiled as 32 bit one. 32 bit DLL gives the same error on
64 bit Firebird.
Also check if your function names are not mangled in your DLL (check it with
this free tool DLLEXP http://www.nirsoft.net/utils/dll_export_viewer.html
I'm having similar problemsOn Thursday, Augus
Finally i managed to solve the problem.the keyword was
extern "C"
Now the compiler stopped mangling the function names and Firebird can see them
correctly.
Good luck all!
On Wednesday, March 29, 2017 11:54 AM, "Michal Kurczabinski
michk...@gmail.com [firebird-support]" wrote:
Thi
th platforms.
I have wasted a lot of time but succes yet to come. Please help if you can.
On Tuesday, March 28, 2017 4:26 PM, "Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support]" wrote:
28.03.2017 15:14, Nagy Szilveszter nagy_szilvesz...@yahoo.com
[firebird-support] wro
upport]" wrote:
28.03.2017 13:26, Nagy Szilveszter nagy_szilvesz...@yahoo.com
[firebird-support] wrote:
> Do you have ideas why it cannot find my UDFs?
First of all, check that your DLL exports 'sum'
Hi all,
I hope someone can help me because I'm running out of ideas.
I have an UDF collection written in C language. It works fine on the Linux
server (Firebird version is: firebird-superclassic-2.5.6.27020.0-1.el7.x86_64)I
just simply compiled it with gcc, copied the output .so file to Firebird'
Hello all!
Please somebody help me with installing ODBC driver on CcentOS linux. I need it
to make Sphinx work.
I followed Marius Popa's instructions, from FB main site:
http://www.firebirdnews.org/howto-install-firebird-odbc-driver-for-unixodbc-from-source/
First i installed firebird-superserve
Hi,
i don't know what you want to monitor. There are MON$ tables for monitoring
FB.We are using IBExpert for handling databases, which also has monitoring
options (it actually requests data from MON$ tables).There also is performance
analysis function and a lot more.
What we really do is: create
And also see if selinux is not blocking you.
On Monday, November 23, 2015 4:52 PM, "Steve Wiser
st...@specializedbusinesssoftware.com [firebird-support]"
wrote:
Run netstat -an from the command line on the server and make sure port
3050 is listening (you should see something lik
Hi Mirco,
we also developed dozens of web applications since 2009 using Firebird on Linux
(CentOS) servers and we never had problems. Once i had a database corruption,
but that could have been avoided if we stuck to the general safety rules.
We also have big databases, but we dont really like to
Hi,
i need FTs (Full Text Search) function to my application. After reading and
comparing different open-source solutions i found Sphinx is my way to go.
I run 64bit Firebird on a CentOS 6.x o.s.
I also managed to install Sphinx with yum (although it is a pretty old 0.8.9.1
versionthe current
Hello,
one of my firebird databases got corrupt in the last couple of days. It's a
pretty big one the FDB file is 8 GB.
The error I observed in the applications logfiles. It happens when the users
try to run a specific SP. The error message is:
# -902 # database file appears corrupt (/data/fireb
Hi all,
i have this error repeated about 20 times when backing up my database:
gbak:error accessing BLOB column EXPLICATIE -- continuing
gbak: ERROR:invalid BLOB ID
What should i do?
Thank you,
Szilveszter
I think this is a bug in FB 2.5, which causes a lot of headaches for me
too...Sometimes even restarting Firebird service doesn't help.
Does anyone know a solution for this? I'm using FB 2.5 64 bit Superserver on
Centos Linux
On Tuesday, November 26, 2013 11:16 AM, Kjell Rilbe
wrote:
De
I'm using GTTs in place of CURSORs.
From: hvlad
To: firebird-support@yahoogroups.com
Sent: Wednesday, August 7, 2013 11:29 AM
Subject: [firebird-support] Re: Do global temporary tables have performance
advantages over usual tables
--- In firebird
Hi,
i have an SP which contains some EXECUTE STATEMENT commands.
I want to trap any possible errors these statements might generate, and save
them into a log table, so i can analyze them later.
I only know how to get the error code (SQLCODE, GDSCODE) but i need the message
too. In which syst
I found a simple solution:
EXECUTE STATEMENT 'insert into A select * from B';
:D
____
From: Nagy Szilveszter
To: "firebird-support@yahoogroups.com"
Sent: Tuesday, July 30, 2013 9:15 AM
Subject: [firebird-support] insert from select i
Hi all,
i have a table A which contains user introduced data.
I have an identical structured table B.
I want to append all data from A into B at each end of month, and empty table A
so it will be small and fast for operations...and from table B i do the
reportings.
In PSQL i cannot use some
Is your database so big that you need the speed nbackup gives you?
Compare the speed with the integrity...which is more important in your
scenario? Think about a failure of your database...how will you proceed at
restoring? If it is a mission critical database you won't have too much time
for re
GROUP BY PRODUCTDESCRIPTION there is PRODUCTCODE missing here
if you use aggregate functions u have to add all fields to GROUP BY that are
not used with aggregate functions
From: Andrew gable
To: firebird-support@yahoogroups.com
Sent: Saturday, June 15, 2013
Really! :)
Well...that will be the next error i guess...like unknown field or something
insert into allBillOfMaterials('', totalTitles, bomNumber, bomDescription)
AllStar...may i recommend first reading an SQL book before "jumping in deep
water"? These errors are not really Firebird related,
Probably you inserted a too long string in a small field.
Example: you get this error if you want to insert "ABCDEFG" in a Varchar(5)
sized field. (this string need 7 chars)
From: Allstars
To: firebird-support@yahoogroups.com
Sent: Wednesday, May 15, 2013
Did you commit after creating the table?
From: Allstars
To: firebird-support@yahoogroups.com
Sent: Wednesday, May 15, 2013 8:42 PM
Subject: [firebird-support] Unable to INSERT INTO TABLE
Hello there,
I am fairly new to FIREBIRD SQL. I am using W
Hi all!
Can anyone please give me hint, advices about how to install Firebird on
Android device?
I'd like to create a small Android application that collects data (interview)
and when returning to the office it would upload the collected data to a
server. Direct database connection to the mai
Here are some other userful views that we use to get internal data (mostly we
build edit forms from these information) :
list all domains with type & length
CREATE OR ALTER VIEW OBJ_DOMAINS(
DOMAIN_NAME,
FIELD_LENGTH,
FIELD_CHARLENGTH,
FIELD_TYPE)
AS
SELECT f.rdb$field_name,
Hey there,
i did not follow the beginning of this thread but this looks like a proper SQL
query...and it should have nothing to do with the ODBC driver, because the
driver just sends the query to the server and the server will run it.
Could you please provide the error message you receive at r
30 matches
Mail list logo