[firebird-support] Migration from Firebird 2.0 to 2.1 or 2.5

2012-01-23 Thread Aldo Caruso
Hi, I'm usinig Firebird 2.0 Super Server on Linux Debian 5.0 As I'm migrating to Debian 6.0 I have two choices: Firebird 2.1 and Firebird 2.5 As it is a production system, I have to migrate as smoothly as possible. Is the migration from 2.0 to 2.5 seamless or is it more

[firebird-support] SP Exception handling

2012-01-23 Thread Si Carter
Hi, Is it possible to get the error message if one is thrown within a stored procedure? i.e WHEN ANY DO BEGIN IF (ERRORMESSAGE CONTAINING 'some string') THEN DO SOMETHING ELSE EXCEPTION; -- re-throw the exception END regards Si

Re: [firebird-support] Migration from Firebird 2.0 to 2.1 or 2.5

2012-01-23 Thread Matthias Hanft
Aldo Caruso wrote: Is the migration from 2.0 to 2.5 seamless or is it more convenient to migrate to 2.1 first ? I have done that, and the only problem I encountered was using some special chars like äöü within triggers while the database and/or connection was configured to charset NONE

RE: [firebird-support] Sizing conversion project

2012-01-23 Thread Rick Debay
You mean beside licensing cost? I was hoping to use a SWAG such as cost per LOC to estimate the database conversion cost; most of our code is in triggers, stored procedures, etc. Do you use some Firebird specific features like Events? We have the hooks in place (Firebird generates events) but

Re: [firebird-support] Sizing conversion project

2012-01-23 Thread Alexandre Benson Smith
Em 23/1/2012 14:53, Rick Debay escreveu: You mean beside licensing cost? I was hoping to use a SWAG such as cost per LOC to estimate the database conversion cost; most of our code is in triggers, stored procedures, etc. So I think you will have a *lot* of work to be done... It's a long time

[firebird-support] Running Interbase and FB 2.5.1 together

2012-01-23 Thread bennie_coetzer
Hi, I am busy converting from Interbase to Firebird but need to support the Interbase software at the same time. To achieve this I would like to run an IB server and a FB server simultaneously. I may want to read the data from the IB and write it into a FB DB. Please advise if I am on the

[firebird-support] Multiple instances

2012-01-23 Thread bennie_coetzer
If I run multiple instances of FB, where are the different firebird.conf files saved? Bennie

[firebird-support] Multi-instances - still

2012-01-23 Thread bennie_coetzer
I have performed the following actions: C:\Program Files\Firebird\Firebird_2_5\bininstsvc sto Service Firebird Guardian - DefaultInstance successfully stopped. C:\Program Files\Firebird\Firebird_2_5\bininstsvc r Service Firebird Guardian - DefaultInstance successfully deleted. Service Firebird

Re: [firebird-support] Multiple instances

2012-01-23 Thread Jesús García
El 23/01/2012, a las 12:00, bennie_coetzer bennie_coet...@yahoo.com escribió: If I run multiple instances of FB, where are the different firebird.conf files saved? Bennie I think You have to install Firebird in a different folder for each instance, with its own Firebird.conf Jesus

[firebird-support] ODBC Connection using Firebird 2.1.

2012-01-23 Thread dave_m_henry_1
Hi, I am having issues setting up ODBC from firebird 2.1. I have tried the following configurations: windows 7 64bit + ODBC 64 bit driver + firebird 32 bit windows xp 32bit + ODBC 32 bit driver + firebird 32 bit In both cases I receive a Unable to connect error when testing the connection in

Re: [firebird-support] ODBC Connection using Firebird 2.1.

2012-01-23 Thread Thomas Steinmaurer
Hello Dave, I am having issues setting up ODBC from firebird 2.1. I have tried the following configurations: windows 7 64bit + ODBC 64 bit driver + firebird 32 bit windows xp 32bit + ODBC 32 bit driver + firebird 32 bit In both cases I receive a Unable to connect error when testing the

Re: [firebird-support] Multiple instances

2012-01-23 Thread Hannes Streicher
Guten Tag Jesús García, and use different Port Numbers El 23/01/2012, a las 12:00, bennie_coetzer bennie_coet...@yahoo.com escribió: If I run multiple instances of FB, where are the different firebird.conf files saved? Bennie I think You have to install Firebird in a different