I've installed firebird (interbase) database server.
I tried using the isql.exe to connect to the employee.fdb database with success..
Yet, when trying from borland delphi 2009, it doesn't...
Good day
When I connect from my delphi app the first time when my windows xp or server 2003 has just rebooted, then it takes about 20 seconds
before the database are open for use.
When...
Hello! Can anyone tell me if the toLower() function is available in interbase?
For example, I have this piece of code:
select * from RELACOES where toLower(RELACAO) LIKE 'isa'
and it ga...
Hi,
I use a datagridview linked to a dataset loaded by a table stored on a firebird db.
The table contains a coluimn deifne as boolean but in the datagridview vb.net displays it as textbox...
Hello,
i am using Firebird database Server. with a requirement i have to synchronize my client and server database at requested times, as my clients application works in remote area away from...
We have a database that continually grows and in the process, sufferers a performance hit once it gets a little big. We found that every 3 or 4 weeks there is a pressing need to stop the datab...
I need a step by step guide on how to achive a secure connection between a PHP5 client and a Firebird database server that is installed behind a firewall on a remote network.
Thanks.
OK experts. My company is using a Firebird database version 2.1. I am trying to parse a string into separate rows using a SQL procedure or view. The table structure is sort of like this exampl...
Hi,
I am new to Firebird database. How to use cast in Group by clause. I have written SQL statement in this way
SELECT CAST(CSTARTTIME AS DATE)
FROM TESTTABLE
GROUP BY CAST(CSTARTTIME ...
Good day
I am running firebird 2.00 database engine and EMS Sql manager professional. I am trying to perform some database administration tasks.
Firstly my database is growing by size ea...
I have a Firebird database installed on Linux server. I want to alter one of the tables with new column "recordservertime" of type timestamp, and assign default value 'NOW', the code is below....
I have multiple Delphi versions, plus RAD Studio 2009 just installed, and have Interbase 2007 Developer. I want to test IB2009 (in RAD intallation package) against older Delphi versions and DB...
Hi,
I have a custom app written with Interbase 6 that performs horribly on a brand new Win2K3 SBS server. It has dual Xeon processors and I am told that is the source of the problem since I...
We're trying to obtain the foreign keys for our Firebird database, but are having a bit of trouble finding the right SQL statement to do so. Our last attempt is added below.
We have opened...
Dear Experts...
We have linux server running Firebird 1.5.5 and we would like to sync all databases to another server running firebird same version. This is for disaster recover. Whats the ...
A number of months ago, while searching for something else, I stumbled upon some query that featured a SELECT statement with a FROM that did not state a table, but a certain keyword series tha...
Hello,
I have a table where the users may enter names in upper and/or lowercase. I could have, for example, NAME1 equal to 'ABEL MARY' and NAME2 equal to 'deBlank John'. The query in the code...
are there any features analagous to access's compact and repair?
using firebird for a client side program - and getting quite large database sizes... its nearly like i'm getting the same so...
What is the correct syntax for creating a sub table?
I have :
CREATE TABLE dates(stay DATE, site VARCHAR(40));
CREATE TABLE client(name VARCHAR(40), address VARCHAR(40), visits dates);
T...
Is there an RDB$ table that tells me which user tables exist?
How can I check if a table already exists before I create one in a script that issues a CREATE TABLE command?
Thanks.
Similar questions to this have appeared here before, apparently without conclusive answers, so I hope members will forgive the repetition!
Server (Win server 2003?) runs IB7.1 server (as a ...
Hi,
I have been handed a Interbase 5 GDB file to generate a sales report by developing a customised program in C#/.Net.
The passwords/userid to access the GDB has also been provided, so wa...
Hi Experts,
I try to use a TIBEvents component but I don't know what kind of events are to be used. I have choosen logical events (for example EMP_NO>100) for the Events pro...
Hi
I have a interbase 5.5 wich comes with my Delphy 5 CD.
I use a ODBC to connecto to database, I obtain always the message:
Microsoft OLE DB Provider for ODBC Drivers error '8000...
Hi,
I need to see what SQL statements are being executed in my database.
How can I do it?
Thanks
