I have recently upgraded from Apache 1.26 and PHP 4.3 to 2.2.11 and 5.2.9 respectively. With my original setup I had a scheduled task set to run every Sunday for a weekly newsletter. It would connect to my database (Interbase/Firebird) to find out what events were opening for the following week and get the list of addresses the email wil...
I get this error on many of the TQuery connected to Interbase via BDE. Exact message is: General SQL Error. Dynamic SQL Error, SQL error code = -804, SQLDA missing or incorrect version, or incorrect number/type of variables. The message appears as soon as i try to open/edit the TQuery at design time, or when a Post is done at run tim...
Hi, folks. When i belived i was a genius and that metadata was my intelectual property, i developed a procedure in firebird to track changes on a single table, something with id´s and time stamps. So, i´ve done a mega clever move and deleted the source of this procedure. Does anyone knows a BLR decoder, or the doc´s that i need to bui...
I try to follow http://edn.embarcadero.com/article/28604 for restarting Interbase. Here is some code: program IBRestart; {$APPTYPE CONSOLE} uses SysUtils, winsvc; var vManager, vService: SC_Handle; vtmp: TServiceStatus; begin vManager := OpenSCManager(nil, nil, SC_MANAGER_ALL_ACCESS); if vManager > 0 then begin vServi...
I'm working on a legacy software and sundenly it became a requirement to run interbase server (Interbase 2007) logged with a restricted user. We tried this here (not me) but no client is able to connect to the server, including IBConsole, like no Interbase server were instaled. Even whether both running in the same computer. Is it poss...
I'm running IB2009 and I'm trying to count the number of records where a specific field is neither NULL nor empty: SELECT COUNT(A.ID) FROM MYVIEW A WHERE ((A.VARCHARFIELD1 IS NOT NULL) OR (A.VARCHARFIELD1 <> '')) where MYVIEW is a VIEW, and MYVIEW.ID is an INTEGER, while MYVIEW.VARCHARFIELD1 is a VARCHAR(18). I'm getting the error me...
I am using InterBase and FireBird SQL in C# .net Enviroment. I would Like to use Transaction Scope in my program. How to do that Effectively with InterBase-FireBird ? Any Idea ? ...
When opening a TIBQuery (IBQuery.Open), is the correspondig Transaction active only the time the data is fetched from the DB or as long as IBQuery is closed? ...
Are there any negative impacts when a single user application uses only one IB transaction, which is active as long the program runs? By using only CommitRetaining and RollbackRetaining. Background: I want to use IBQuery(s) and connect them to a DB Grid(s) (DevExpress), which loads all records into memory at once. So I want to avoid re-...
I have a .IB file which I'd like to access using a Java Application. Where can I find the drivers for Interbase. My OS is Mac OS X ...
I am using FirebirdSql for Interbase database in C# .net environment. My application is divided into 3 parts, 1. Handler 2. Connector 3. DBLayer In Handler I set all my fields property, Like Decimal name = payment.name; Decimal convRate = payment.ConvRate; string remark = "Some Text"; retValue = Payment.Insert(name,convRate,remar...
I would like to know if anyone out in the industry has had experiance in migrating from Interbase to MS Sql Server. Migrating the tables & data is not a big concern, but triggers & stored procs will not be so easy. Any advice? ...
I am getting this error when I try to delete some rows in InterBase database, but for those ROWS I can fire SQL queries for SELECT and also UPDATE ... but not delete. What went wrong , what is the possible solution. ...
Currently, our database uses Win1252 as the only character encoding. We will have to support Unicode in the database tables soon, which means we have to perform this migration for four databases and around 80 Delphi applications which run in-house in a 24/7 environment. Are there recommendations for database migrations to UTF-8 (or UNICO...
Hi, I am attempting to add an Interbase connection pool to GlassFish v3 to use EJB 3.1 in a project. The glassfish log appears to be connecting to my database properly, it spits out all my table names and indices. However, I get an error INFO: fetching database metadata SEVERE: could not complete schema update java.lang.NullPointerExc...
I was inspired by the good answers from my previous question about SQL. Now this SQL is run on a DB with Interbase 2009. It is about 21 GB in size. SELECT DistanceAsMeters, AddrDistance.Bold_Id, AddrDistance.Created, AddressFrom.CityName_CO as FromCity, AddressTo.CityName_CO as ToCity FROM AddrDistance LEFT JOIN Address AddressFrom ON A...
We want to use Unicode with Delphi 2009 and Interbase, and found that to switch the character encoding from WIN1252 to UNICODE_FSS or UTF8 we first have to replace all instances of TStringField with TWideStringField in all datamodules. For around 60 datamodules, we can not simply do this over one weekend. I can see only two options for a...
Hi all I do a good deal of work with an Interbase server. I would like to develop a data access layer for it using NHibernate but there isn't a readymade dialact for Interbase. Does anyone know, is there an NHibernate dialect which is used for generic ANSI-only database work, or if any of the existing dialects will work okay with Inter...
Sorry for my English first of all. I have a problem and need help. I have a simple tool made by myself on c#. This tool makes connect to local or remote firebird server (v.2.5). And my tool can create specified .fdb file (database) somewhere on the server. Also i have a file with sql-statements (create table, triggers and so on). I wan...
I want to change our search as it is a bit hacky now. Currently it works like this: User enter a text in a textbox, for example Volvo and start searching. This search with SQL all posts containing Volvo. The result is a list with 2 columns, BoldID and DisplayValue. BoldID is just an unique number to identify the object in datab...