Re: [firebird-support] Interbase/Firebird interaction?
1) Are there any adverse conflicts between IB6.5 and Firebird in a situation like this ... i.e., would running AT against an IB6.5 engine ultimately damage the data? As long as the data file is created and accessed by the IB6.5 server only no damage should occurr. The Firebird client lib seems to connect to IB server without problems - presumably using compatibility to IB 6.0 on both sides. If your Application does not use any features unique to FB it should run on IB 6.5. 2) Is there some way we can determine at startup time whether there is a Firbird engine running or an IB engine? We might want to ensure that AT is running in an environment served by Firebird only. You can use the Service-Api to ask for Server Version info. Elmar
Re: [firebird-support] Interbase/Firebird interaction?
On 1/17/2013 3:45 PM, Leyne, Sean wrote: We have the following report from a user, who owns a copy of our AuctionTracker software: Background: AT uses IBObjects 4.8.7, and is built running against Firebird V2.2.1.17910. The normal installation requires a Firbird installation on the workstation. Our development environment is Delphi7. There is no such release as Firebird v2.2.x. The 2.x Firebird releases as 2.1.x or 2.5.x Sean Typo on my part. Meant FB2.1.1.17910. [Non-text portions of this message have been removed]
Re: [firebird-support] Interbase/Firebird interaction?
Em 17/1/2013 21:40, lcampbell escreveu: We have the following report from a user, who owns a copy of our AuctionTracker software: Background: AT uses IBObjects 4.8.7, and is built running against Firebird V2.2.1.17910. The normal installation requires a Firbird installation on the workstation. Our development environment is Delphi7. This user had an old DB app. that runs against Interbase; with an IB6.5 installation on his workstation. He installed AT on the workstation WITHOUT a Firebird Server installation. Apparently, AT starts, runs, finds its data and executes several processes with no problems in this environment. We're using the IBObjects TIBODatabase to connect, passing it the location of the .FDB database files, and calling its Connect method. Apparently, the underlying IBO code doesn't care if it's running against an IB server or an FB Server. We are working to verify this. This raises a couple of questions: 1) Are there any adverse conflicts between IB6.5 and Firebird in a situation like this ... i.e., would running AT against an IB6.5 engine ultimately damage the data? 2) Is there some way we can determine at startup time whether there is a Firbird engine running or an IB engine? We might want to ensure that AT is running in an environment served by Firebird only. Anybody feel free to jump in with info/advice Lane Campbell NW Software Well.. I know I am not answering your questions But.. I would install FB on a diferent port and run against it. I think it will save you any kind of trouble... The IB server could not understand the FB ODS, will not provide all the features, but, in the general case de cliente API is very similar. see you !
Re: [firebird-support] Interbase/Firebird interaction?
This raises a couple of questions: 1) Are there any adverse conflicts between IB6.5 and Firebird in a situation like this ... i.e., would running AT against an IB6.5 engine ultimately damage the data? I had some significant issues if I used FB to access an IB database file. It was imperative to backup the IB database and restore it as FB database. This might or might not be an issue for you if you distribute a prepared database file (with all tables, procedures, triggers etc. created); if you instead create the database file from scratch, then you should be OK. Also, some statements behave differently under IB and FB (e.g. raise an error in one and work normally in the other - some CASTs, I think, and perhaps AS used in certain situations). 2) Is there some way we can determine at startup time whether there is a Firbird engine running or an IB engine? We might want to ensure that AT is running in an environment served by Firebird only. It is definitely possible to detect a version of Firebird by querying various system tables (e.g. if RDB$GENERATORS has a RDB$DESCRIPTION field, then the database is at least FB 2.0). I suppose you could do the same for IB (check whether a field or table exists, which only exists in one of the engines). Josef ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ * Your email settings: Individual Email | Traditional * To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) * To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com * To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [firebird-support] Interbase/Firebird interaction?
Mi mandi il cell che la ringrazio Codebue Fabio P-Soft Il giorno 18/gen/2013, alle ore 07:35, Josef Kokeš j.ko...@apatykaservis.cz ha scritto: This raises a couple of questions: 1) Are there any adverse conflicts between IB6.5 and Firebird in a situation like this ... i.e., would running AT against an IB6.5 engine ultimately damage the data? I had some significant issues if I used FB to access an IB database file. It was imperative to backup the IB database and restore it as FB database. This might or might not be an issue for you if you distribute a prepared database file (with all tables, procedures, triggers etc. created); if you instead create the database file from scratch, then you should be OK. Also, some statements behave differently under IB and FB (e.g. raise an error in one and work normally in the other - some CASTs, I think, and perhaps AS used in certain situations). 2) Is there some way we can determine at startup time whether there is a Firbird engine running or an IB engine? We might want to ensure that AT is running in an environment served by Firebird only. It is definitely possible to detect a version of Firebird by querying various system tables (e.g. if RDB$GENERATORS has a RDB$DESCRIPTION field, then the database is at least FB 2.0). I suppose you could do the same for IB (check whether a field or table exists, which only exists in one of the engines). Josef ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links
