I Have
Free version of Interbase 6.0 on Windows 2000 Adv Server
The problem is in the log file, this file is full with the following errors
NZON (Server) Fri May 27 14:48:23 2005
INET/ine...
What is causing the above error? I have installed both client and server (SuperServer) on user's machines, and I see this error often.
Hi,
I'm writiing a php script which will connect to a firebird server(all Linux). Firebird client is already installed on the webserver hosting the php. I need to configure PHP settings or ...
I am having a problem with getting the Firebird (v1.5.4) optimiser to come up with a decent execution plan where I am using a subquery.
See the 3 querys in the code snippet box.
Query1 e...
I want to aggregate records by week of the year to get a sum of charges for that week. My problem is that although I can achieve a week number on the first part of my select statement, it thro...
I keep getting the following error... Unable to complete network request to host "localhost".
I am using the following :
+++++++++++++++++++++++
Firebird-1.5.3.4870-0-Win32.exe
C# (.net ...
Hello experts!
Due to a messy import of data from another database we need an SQL statement with Firebird syntax that will update the numeric values in entire columns of specific tables by ...
How do i select Distinct on a specific column when the select statement selects multiple columns...
Example:
--------------------------------------------------------------------
booktown=...
Thanks for reading...
Never done a stored procedure before.
Here's the scenario:
On the server sits a table of seats available, example: A1, A2, A3, A4, A5, ... B1, B2, B3, B4, B5 etc.
C...
I have a .fdb file that is in firebird/interbase format that I need converted to mySQL (or access). I'm currently using a trial version of "Full Convert Enterprise Edition", but it's $250 and ...
I Use IBBackupService to backup a database but code return some error.
Connection rejected by remote interface .
I Use Firebird 2.1 instaled na Delphi 7.
I Have gds32.dll only in my system ...
Hi fellow experts.
Is it possible to do crosstab/pivot style queries using Firebird?
If not, what is the best way to achieve similar results(are stored procedures my only option?)?
Re...
Hi,
If I need to obtain the list of tables, fields for a given table, list of views and list of stored procedures for an Access database using an OleDb connection, I use the following funct...
I am using Firebird 1.5 in windows 2000 server. I use Firebird ODBC which I access in Delphi 7.
Using different sessions in my program on a firebird database, the maximum number of connect...
I am getting the above error on the code attached... this used to work just dandy under SQL Server... what do I need to do to fix it?
I assume the problem is in the SELECT statement, but I'...
Im in a bit of a pickle. My client has not be running his backups and called me today with an error on his software. On closer inspection ive found that the database is corrupt. Its a firebird...
On Firebird which function we can use instead of last_day function on oracle.
I hava a table that has a field name Date_Time, it´s type is TimeStamp. In the field it has the Date and Time. I want to do a SQL to delete everything where the Date is smaller (<) then 2/4/20...
Im occasionally receiving an error
Internal gds software check cannot continue after bug check
Tried to backup and received this error
gbak: ERROR: internal gds software consistency ...
I wrote this procedure to look for users within an certein age range,
however, when I run it I get the error message: "Multiple rows in singleto
select".
Why is my select considered a singl...
IS there such a thing that works well and doesn't cost the Earth?
From a cursory investigation (i.e. Google), I couldn't find much out there.
Anyone with suggestions?
Chris
I have some tables that have a field called CREATE_DATE. I would like to set the default values for new records to the current date. How can I accomplish this?
Does Firebird support the *truncate table* statement?
Can you point me to a place in the docs where I can find the answer to this type of question?
Hi experts,
A quick question. How do i use firebird gbak with delphi? i use firebird 2, delphi 7 and embedded firebird dll
Thanks.
Is there any GUI front-end for working with FireBird Database?
