Hi all,We are migrating our application from Interbase 5.6 to Firebird 1.5.4. In the process we took a backup of Interbase db which had \'Dialect\' setting as...
Hi all, I just finished my work to migrate from IB to FB. Everything works fine except that the query that usually runs quickly, now still runs very-very...
... The reason for this slowness is that Fb 2 corrects a logical error that is in InterBase NOT IN() processing and was in Firebird <= 1.5.x. Now, NOT IN()...
Hi,Could you please confirm whether using the statement \'SET SQL DIALECT 1;\' sets the dialect value temporarily for that particular session or else maintains...
... SET SQL DIALECT n works only in isql (including scripts executed in isql using the -i <scriptfilename> switch). And yes, once you switch to another...
Hi all,We just migrated from Interbase 5.6 to FireBird 1.5.4. We are facing few problems now in our application. First is in a VB application, here RDOQuery...
Hi All, A quick question on setting SQL Dialects. We are migrating Interbase 5.6 database to Firebird 1.5.4. We have used register exisiting database option in...
... I don't know what "the attached error" is but if you sent a file attachment, it would be eaten. We don't allow attachments to list messages. ... The only...
Sorry for the missing attachments. Here is the attached error file.On Wed, 12 Sep 2007 06:25:07 -0000 IB-Conversions@yahoogroups.com wroteHi All,A quick...
Hello All, Is there any tool available which will validate that all the database objects has been ported to Firebird without any problems? The tool should be a...
... isql -x database_name will extract a script with all the metadata declarations. It includes the source of procedures, views, triggers, etc (when...
... Any UDF that creates memory for the server should use ib_util_malloc available in ib_util.h; this has been documented for ages but people didn't pay much...
Hi,Thanks for the solution.We used the below command in Firebird version isql and it worked fine,\"isql -x -o c:\\medoutput.txt -user SYSDBA...
Hi We are migrating from Interbase 5.6 to firebird 1.5.4. Relating to migration work we need to...
Hi,It would be helpful if i get any queries or commands to list the active connections for a database in Interbase 5.6 and Firebird 1.5.4.Thanks in advance ...
... Read the API Guide and look for the isc_database_info() call and the isc_info_user_names item for IB5.6. You will get only yourself if you aren't ...
... No queries. You need to call isc_database_info() or isc_service_query() to get them, as explained in my other answer. Only if you are using FB 2.1 and...
I'm looking to move a Delphi application that uses dBase files (dbf) to Firebird. Is there a good utility that can help me with the date file conversion?...
Frank, F> I'm looking to move a Delphi application that uses dBase files (dbf) F> to Firebird. Is there a good utility that can help me with the date F> file...
I tried ibdatapump... could not get it to work. Had some success with Spectral Core Full Convert. But I was hoping to draw on the experience of those who have...
Frank, F> I tried ibdatapump... could not get it to work. Strange. It's been a while now, but I have used it several times in the past for exactly the same...
It looks as though ibdatapump should do the job quite well. That's the frustrating thing about it. I sent an e-mail to clevercomponents explaining the problem...
I'm looking to convert dBase files to Firebird. It appears that IBDataPump should do the job, however I'm having difficulty with it. I've tried e-mailing...
Frank, F> I'm looking to convert dBase files to Firebird. It appears that F> IBDataPump should do the job, however I'm having difficulty with F> it. I've tried...
Hi,I want to use IB7.5 database with Firebird2.1 . How could I convert it? I tried connect command in ISQL utility but generate an error SQLERROR = -820 ...
... They say they sell support for IBDataPump, maybe this is the reason they don't reply to free requests. Here's the information and there's one item specific...
... FB and IB are compatible only up to FB1 and IB6. Try to backup with IB and restore with FB, but there's no warranty that it will work. You may want to...
I am trying to import numeric values produced by others (analytical laboratories) into my Firebird (1.5) database. The numeric values can cover many orders of...
... If you import a number into a number type column then it is a number. If you bring an integer into a column of type FLOAT or DOUBLE PRECISION, e.g. 320,...
