hi,
i first created a db with tables triggers, generators and views with the console admin application that comes with firebird 1.5. I came now to problems dealing with dates in triggers. T...
Hi Experts,
Here's an issue i'm having. In a company with 8 machines, running Windows XP Professional. My application is running fine. Running Interbase 6. My client recently bought 3 new m...
An Interbase (version 5.6) database contains a Blob field which is used to hold an RTF document. A client has extracted the table (via an ODBC link) into an ACCESS (2003 version) database. T...
I had a system crash which required a reinstall of my Vista OS, Visual Studio, etc. After reinstallation I have struggled with my application in relation to Firebird Database. Read original Qu...
Hello,
I had a 500 MB Size Firebird Database File with .FDB extension. i deleted all the data from the database file. even then it is showing the size of 500 MB. how to reduce the size of the...
I have the following problem with interbase:
I program in visual basic, I connect myself with ibole.dll
through of oledb, at the beginning when I believe the database
the application...
Hello dear experts
I have an interbase database, and i need to convert it to mysql structure and data
how to do this
thank you
Hi,
I need to find out how to load documents (word, excel, openoffice, pdf, jpeg, bmp etc) into and out of firebird blob fields using Delphi (D2006). Can anyone help or point me to a good...
How do I change the default isolation level for a firebird server?
Hi,
InterBase Manager says running (automatic). In Services both the Guardian and the Server is running (automatic).
Still my application can't connect to a database (unavailable databa...
We have Interbase 7.1 installed on our server and need to retrieve, but not change, the SYSDBA password. Unfortuantely, there's software installed on the server that uses the current SYSDBA p...
The list of supported OS state Windows 32-bit... does that mean it will NOT run on Windows 7 x64 or Vista x64?
How can I set the level of transaction isolation in Delphi 7 Interbase Components? By the way, has anyone tested another good set of interbase access components? I've already tested Zeos and I...
Hi Experts,
to get started with InterBase I made a simple IB application. The used IB database is supllied with IB: C:\Program Files\Common Files\Borland Shared\Data\EMPLOYEE.GDB. On the Ma...
Hello there.
When I try to login to a Interbase (Interbase 7, Version 1.1.0.11) database already defined, I receive the following error message:
Error loging into the requested server.
...
Platform: Firebird 1.5 RC8 / Delphi 6 Enterprise / SQL Express Interbase connectivity components
When I store a SQLTimeStamp from Delphi to the Interbase database and then immediately retri...
I produce a product that uses an IB database. On the last release we included sql which created a FK on a table. I now want to send sql that will remove the table. To do so I need to drop t...
I'm using firebird 1.5 with the ZEOS components with Delphi 7.
I have two tables A and B. Both have a primary key on the field called KeyField.
Whenever I do a join on A and B, the respons...
I am using FIRST and SKIP (Firebird SQL) for recordset paging to reduce the time it takes for my records to travel from the server to the client.
This works great because instead of sending...
Hi there!
As a part of small update on my database. I tried to create a primary key on the table called Transact. This table contains the entity called 'CODE'. I am using gerator ( defined ...
I have installed a Firebird superserver on a machine
I plan to write a client application running on other networked machines that will need to access the Firebird database
The application ...
I have a .GDB database which i want to transfer to Excel. I dont have Interbase installed and I dont have any knowledge of Interbase.
I have a C# program that uses gsec.exe to set the user id and password. Under Vista, it shows up as not found, although the user says it's there... code snippet is below...
Any ideas why?
I would like to insert SQL error message in a log table within a stored procedure.
For example, I would like to know which columns causes error -625, and I only know that the error message co...
Hi
I am maintaining a application developed in Delphi 6...db was initially in interbase...but now db file is same but instead of interbase we use firebird.
one of our client has done har...