[firebird-support] Re: How to access Firebird DB on NAS storage device from client workstations
Hello, so if I see it right, it's possible to run a firebird server on a NAS with Linus as OS, have the database on that NAS as well and access it from client workstations, right? Is there a HowTo / a tutorial about such a setup? I have no idea about Linux, unfortunatelly, and so no experience with this. Some customers do ask about such a setup, so I wanted to see if it's possible, what requirements my application has to meet, what steps have to be done to setup Firebird on a NAS / on Linux in general etc. All tipps and advices are welcome. Best regards, Patrick --- In firebird-support@yahoogroups.com, Kjell Rilbe wrote: mariofb123 skriver: Thank you Lester. Based on your reply, I assume that it is not possible to run the Firebird server on the NAS drive, to control the database files located on that drive ? Seems to me you still haven't got this question answered. 1. It is not viable to have the DB file on the NAS and have multiple FB processes access it from variaous workstations. This is not what Marius asks about above, and he has stated that he undrestands that this doen't work. 2. It is not recommended to have the DB file and the server process on two different machines. If this is still going to be done, make sure only one single FB process is connected (has the file open) at any one time. Again, this is not what Marius asks about above. 3. Marius asks about the option to have both the DB file and the FB process(es) on the NAS. Some NAS devices have a Linux distro as OS and allows custom software to be installed directly on the NAS. This is what he wants to do. Noone seems to have answered this. I can't say anything else than I guess it's up to the NAS what it allows and how. From the FB point of view I can't see that there would be a problem with it. So, Mario, maybe you should contact the NAS supplier rather than asking here. What you need is to know how to install FB on the NAS and how to get the NAS to allow connection via port 3050 or whatever you set it up to use. Good luck! Kjell -- -- Kjell Rilbe DataDIA AB E-post: kjell.rilbe@... Telefon: 08-761 06 55 Mobil: 0733-44 24 64 [Non-text portions of this message have been removed]
[firebird-support] Re: I need help on how to cross compile firebird for arm?
--- In firebird-support@yahoogroups.com, Mark Rotteveel wrote: On Tue, 08 Jan 2013 09:44:42 -, addmanrey wrote: I've successfully compiled the firebird 2.5 source code on my Ubuntu desktop and I saw that it built some files and folders. /usr/local/firebird/include/ -ibase.h -iberror.h -ib_util.h -perf.h /usr/local/firebird/lib -libfbclient.so -libfbclient.so.2 -libfbclient.so.3.0.0 -libib_util.so and I checked the file type of the libraries which is: libfbclient.so: symbolic link to `libfbclient.so.2' libfbclient.so.2: symbolic link to `libfbclient.so.3.0.0' libfbclient.so.3.0.0: ELF 32-bit LSB shared object, Intel 80386, version 1 (SYSV), dynamically linked, BuildID[sha1]=0x790e3feb501db8b14fe7c66430a81382a4998342, stripped libib_util.so:ELF 32-bit LSB shared object, Intel 80386, version 1 (SYSV), dynamically linked, BuildID[sha1]=0xf3a3ab995c6648ca7220531bcada3ba5714f3c3c, stripped Now, what options I am going to include in autogen.sh and configure in order to make files for arm? I'm currently using arm-none-linux-gnueabi cross compiler and Ubuntu operating system and I need those include files and libraries to my Trolltech Qt configuration. I hope someone will guide me to solved this problem. thanks It is probably better to ask this question in the Firebird-devel mailinglist. See http://www.firebirdsql.org/en/mailing-lists/ under Firebird Developers' Lab Mark thank you for the quick response.
[firebird-support] Firebird Windows 3.11
Hi all, Does anyone know if I can access a firebird server from Windows 3.11 and if possible to run firebird embedded on Windows 3.11? Thanks Andy [Non-text portions of this message have been removed]
[firebird-support] Moving data from one database to another
Hi all, what tool can I use to move data from one database and insert it into another database? basically I have changed some tables with in my database and I have customers who use my System so I want to move their data from the old style to the new database Is this possible or do I need to make a sync app to do the move? Andy [Non-text portions of this message have been removed]
Re: [firebird-support] Firebird Windows 3.11
On Tue, 8 Jan 2013 14:47:04 -, Andy Gable andrew.ga...@tesco.net wrote: Hi all, Does anyone know if I can access a firebird server from Windows 3.11 and if possible to run firebird embedded on Windows 3.11? Windows 3.11, seriously, it is almost 20 years old by now? Out of curiosity: Why do you need that? I don't think there ever has been a Firebird version that worked on Windows 3.11. Mark
Re: [firebird-support] Moving data from one database to another
Hello Andy, what tool can I use to move data from one database and insert it into another database? basically I have changed some tables with in my database and I have customers who use my System so I want to move their data from the old style to the new database Is this possible or do I need to make a sync app to do the move? You can download a trial of Database Workbench at www.upscene.com and use the DataPump to do this, see: http://upscene.com/documentation/dbw4/tools_datapump.htm Hope this helps. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird!
[firebird-support] Re: Moving data from one database to another
Is this possible or do I need to make a sync app to do the move? There is a very nice data pump available: http://www.clevercomponents.com/products/datapump/index.asp Regards Christian
Re: [firebird-support] Firebird Windows 3.11
On 08/01/13 14:47, Andy Gable wrote: Hi all, Does anyone know if I can access a firebird server from Windows 3.11 and if possible to run firebird embedded on Windows 3.11? Maybe an old Interbase lib could connect to a modern FB server. Doubt fbembed would be possible, for starters I think it uses modern C++ stuff that old win16 targeted compilers wouldn't support[0]. Worse, it'd be written to assume larger memory ranges than win16 could offer. Scott [0] I think it's something like Visual C++ 4 was the last to target 16-bit. (Nope, just checked wiki and it was 1.5, v4 came with a copy v1.5 though) Maybe http://www.openwatcom.org
Re: [firebird-support] Firebird Windows 3.11
Andy Gable wrote: Hi all, Does anyone know if I can access a firebird server from Windows 3.11 and if possible to run firebird embedded on Windows 3.11? It seems to me it should be possible to access a firebird server from windows 3.11. We accessed Interbase with windows 3.11 and the connection for at least version 2.0, 2.1 and 2.5 of firebird is about the same. If you can find an old copy of Delphi version 1, 2 or 3 you could write something that accesses firebird. However, it would be difficult to write something in much else since the support libraries would not exist for windows 3.11. Though firebird will not compile on windows 3.11 because of lack of support libraries. Of course the question Mark asked is still relevant, why would you want to access from windows 3.11? Though I admit after much research I succeeded in getting windows 98 and older versions of programs running on a relatively new computer. It was sooo fast it was almost beyond belief. However, many web sites complained about the old browser. Ted
RE: [firebird-support] Firebird Windows 3.11
I write EPoS Software for small shops who can not afford the new Windows 7 machines And some of the machines I get can handle windows 98 normally but I have had a batch that only handles windows 3.11 I have a old win 3.11 app that uses text files as databases I was hoping I did not have to do updates to my EPoS back office to create data files again (as I am so use to the quick updating that the sql database offers now) Andy -Original Message- From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Mark Rotteveel Sent: 08 January 2013 2:58 PM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] Firebird Windows 3.11 On Tue, 8 Jan 2013 14:47:04 -, Andy Gable andrew.ga...@tesco.net wrote: Hi all, Does anyone know if I can access a firebird server from Windows 3.11 and if possible to run firebird embedded on Windows 3.11? Windows 3.11, seriously, it is almost 20 years old by now? Out of curiosity: Why do you need that? I don't think there ever has been a Firebird version that worked on Windows 3.11. Mark ++ 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
RE: [firebird-support] Firebird Windows 3.11
Wouldn't those machines run Linux fine ? I guess a lot better option than go with such a ancient OS. --- Em ter, 8/1/13, Andy Gable andrew.ga...@tesco.net escreveu: I write EPoS Software for small shops who can not afford the new Windows 7 machines And some of the machines I get can handle windows 98 normally but I have had a batch that only handles windows 3.11 [Non-text portions of this message have been removed]
RE: [firebird-support] Firebird Windows 3.11
Yes they would BUT I can only code in BASIC (QuickBasic for MS-DOS and Visual Basic for windows) -Original Message- From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Anderson Farias Sent: 08 January 2013 3:53 PM To: firebird-support@yahoogroups.com Subject: RE: [firebird-support] Firebird Windows 3.11 Wouldn't those machines run Linux fine ? I guess a lot better option than go with such a ancient OS. --- Em ter, 8/1/13, Andy Gable andrew.ga...@tesco.net escreveu: I write EPoS Software for small shops who can not afford the new Windows 7 machines And some of the machines I get can handle windows 98 normally but I have had a batch that only handles windows 3.11 [Non-text portions of this message have been removed] ++ 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
RE: [firebird-support] Firebird Windows 3.11
OK... anyway, if no better option comes up, you could try Wine, see if it works for your Windows apps http://www.winehq.org/ Regards,Anderson --- Em ter, 8/1/13, Andy Gable andrew.ga...@tesco.net escreveu: Yes they would BUT I can only code in BASIC (QuickBasic for MS-DOS and Visual Basic for windows) [Non-text portions of this message have been removed]
RE: [firebird-support] Firebird Windows 3.11
OK... anyway, if no better option comes up, you could try Wine, see if it works for your Windows apps http://www.winehq.org/ Windows 3.1 is *16 bit* not 32 environment. All Firebird releases are for 32 or 64 bit platforms. I doubt that you will find a 32 bit emulator that will run on a 16bit platform. Sean
RE: [firebird-support] Moving data from one database to another
I have actually decided to create a small data shunt application (at least I will know what is being moved around) Andy -Original Message- From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Thomas Steinmaurer Sent: 08 January 2013 4:48 PM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] Moving data from one database to another On Tue, 8 Jan 2013 14:56:19 -, Andy Gable andrew.ga...@tesco.net wrote: Hi all, what tool can I use to move data from one database and insert it into another database? basically I have changed some tables with in my database and I have customers who use my System so I want to move their data from the old style to the new database Is this possible or do I need to make a sync app to do the move? If you need specific, complex transformations of your data (and not simply pump data), you could also look at Pentaho Kettle (http://kettle.pentaho.com/ ); it is actually intended for Business Intelligence, ETL etc, but I have found that it can also be (ab)used for data migrations. Kettle aka Pentaho Data Integration is an excellent product and extensible, e.g. to plug in a Firebird Event Listener step. Used it in various open source DWH projects in the past. Regards, Thomas ++ 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
[firebird-support] Rolling back from 2.5 to 2.0
Hi all, I work with proprietary software that interfaces with Firebird 2.0. I recently updated to 2.5, but found that some features of our software had stopped working. Unfortunately, when I tried to roll back my test machine (Win7x64) to 2.0, the features of software that broke with 2.5 remain broken. I've performed a complete uninstall (including the registry), the directory has been deleted, but the software still acts like it did when 2.5 was installed. Does anyone know what might be persisting from the update? Thanks for your time.
[firebird-support] Re: ASCII_VAL for BLOB
I found out that typecasting as a text blob was the solution: ASCII_VAL(CAST(SUBSTRING(Image FROM 1 FOR 1) AS BLOB SUB_TYPE TEXT)) Note typecasting as (VAR)CHAR(1) or CHAR(1) CHARACTER SET ASCII does *not* work. According to the Firebird documentation, ASCII_VAL is only supported for (VAR)CHAR and text blobs, still i think it is better that also the right value should be returned for a byte in a binary blob, or that a 'not supported' error is raised. Kind regards! --- In firebird-support@yahoogroups.com, rj1102 wrote: Using Firebird 2.5 (WI-V2.5.2.26539), I try to access a blob with jpeg image, but somehow not all bytes return the right ascii value. E.g. I know the first byte of the blob is x'FF' since statement below returns 'TRUE': SELECT IIF(SUBSTRING(Image FROM 1 FOR 1) = x'FF', 'TRUE', 'FALSE') FROM MyTable WHERE Id = 1 However statement below returns 74 where I expect 255: SELECT ASCII_VAL(CAST(SUBSTRING(Image FROM 1 FOR 1) AS BLOB)) FROM MyTable WHERE Id = 1 Field Image is defined as BLOB(80, 0) Is there another reliable way to retrieve the numeric value of a byte inside a blob? Thank you very much in advance! Robert
Re: [firebird-support] Rolling back from 2.5 to 2.0
Em 8/1/2013 18:58, halaekinree escreveu: Hi all, I work with proprietary software that interfaces with Firebird 2.0. I recently updated to 2.5, but found that some features of our software had stopped working. Unfortunately, when I tried to roll back my test machine (Win7x64) to 2.0, the features of software that broke with 2.5 remain broken. I've performed a complete uninstall (including the registry), the directory has been deleted, but the software still acts like it did when 2.5 was installed. Does anyone know what might be persisting from the update? Thanks for your time. Could it be the ODS upgrade ? see you !
Re: [firebird-support] Re: Rolling back from 2.5 to 2.0
At 11:07 a.m. 9/01/2013, Alexandre Benson Smith wrote: Could it be the ODS upgrade ? At 11:19 a.m. 9/01/2013, halaekinree wrote: Good thought, but the database structure is still the same - the only thing that changed is the server version. Thanks for the suggestion though! You missed the point of Alexandre's question. The on-disk structure (ODS) of a database is upgraded when you restore under a newer server a database with an older ODS than what the newer server creates. The actual *data structures* of the user data are not changed by this, although the structures of the metadata usually are. That's why databases are not backward-compatible and one strong reason not to commit a production database to such a change without thorough lab work. The API (application programming interface, the layer that applications use to communicate with databases through the server) is also likely to undergo changes in a major version upgrade. This will affect how user applications access data, in ways that would be hard to guess without some meaningful symptoms. For that reason, performing a major server upgrade is a bad idea unless you are in control of what the application can do to work with the API changes. You might be getting permission/privilege problems, if you lost the security database in the process of installing the new version. That problem is relatively easy to fix if you still have the security database (security2.fdb) that shipped with your application package. You haven't given enough information for anyone to tell whether your troubles are coming from ODS changes, API changes, or both. There are expert's techniques that can sometimes work to downgrade a database to an older ODS. If you have gotten yourself in the position of having wrecked a production database without any backups you can restore and revert to, you would be best advised to get professional help. Whatever you do, hang on to any backups and take a file copy of the database in its current state. Alternatively, the vendor of your application software may have tools to deal with this kind of mess. It's worth trying. ./heLen
[firebird-support] Re: Rolling back from 2.5 to 2.0
Thanks, that was very informative! I'll try to include more information to better explain my situation. Our software uses SQL scripts to create databases that we can then interface with. After installing 2.5 I can access and modify existing databases. If I roll back to 2.0, I can still access and modify those same databases, but the script to *create* a database no longer works and instead throws an ISC error (335544375). Since it works in machines running a virgin 2.0 install, but not on 2.5 or a machine that has been rolled back from 2.5, which suggests to me that the uninstaller is missing something. Let me know if there is any additional information I can provide that would further explain my situation. --- In firebird-support@yahoogroups.com, Helen Borrie wrote: At 11:07 a.m. 9/01/2013, Alexandre Benson Smith wrote: Could it be the ODS upgrade ? At 11:19 a.m. 9/01/2013, halaekinree wrote: Good thought, but the database structure is still the same - the only thing that changed is the server version. Thanks for the suggestion though! You missed the point of Alexandre's question. The on-disk structure (ODS) of a database is upgraded when you restore under a newer server a database with an older ODS than what the newer server creates. The actual *data structures* of the user data are not changed by this, although the structures of the metadata usually are. That's why databases are not backward-compatible and one strong reason not to commit a production database to such a change without thorough lab work. The API (application programming interface, the layer that applications use to communicate with databases through the server) is also likely to undergo changes in a major version upgrade. This will affect how user applications access data, in ways that would be hard to guess without some meaningful symptoms. For that reason, performing a major server upgrade is a bad idea unless you are in control of what the application can do to work with the API changes. You might be getting permission/privilege problems, if you lost the security database in the process of installing the new version. That problem is relatively easy to fix if you still have the security database (security2.fdb) that shipped with your application package. You haven't given enough information for anyone to tell whether your troubles are coming from ODS changes, API changes, or both. There are expert's techniques that can sometimes work to downgrade a database to an older ODS. If you have gotten yourself in the position of having wrecked a production database without any backups you can restore and revert to, you would be best advised to get professional help. Whatever you do, hang on to any backups and take a file copy of the database in its current state. Alternatively, the vendor of your application software may have tools to deal with this kind of mess. It's worth trying. ./heLen
Re: [firebird-support] Re: Rolling back from 2.5 to 2.0
At 01:26 p.m. 9/01/2013, halaekinree wrote: Thanks, that was very informative! I'll try to include more information to better explain my situation. Our software uses SQL scripts to create databases that we can then interface with. After installing 2.5 I can access and modify existing databases. If I roll back to 2.0, I can still access and modify those same databases, but the script to *create* a database no longer works and instead throws an ISC error (335544375). That exception is Unavailable database. What that means in the context you describe is that the sql CREATE DATABASE has probably gotten as far as creating a file in the filesystem with the basic infrastructure for making it into a database; but something is preventing the server from connecting the client app (isql? calls in a batch script?) to it. If it can't do that, then no database. Database unavailable can occur for several reasons, not all of them related to one another. If the server is not running, or if the script is not supplying the correct security info (user name password), or the client's connection to the server got dropped (or crashed); if (in 2.0) your script is trying to make a serverless connection to a Classic server; you (or the script) tried to create the database on a non-physical disk or partition (a Windows share, for example)...and so the list goes on. Since it works in machines running a virgin 2.0 install, but not on 2.5 or a machine that has been rolled back from 2.5, which suggests to me that the uninstaller is missing something. The uninstaller uninstalls what its installer installed, on the whole. Be very, very careful to back up components of the server that were customised for your application package, such as the security database, aliases.conf and possibly firebird.conf. AFAIR, the uninstaller does leave these behind; but I think you said you deleted those. You said originally that you had installed Fb 2.5 on Win7 X64. However, if you installed the 64-bit Firebird and instructed the installer to install fbclient.dll into the system directory on 64-bit Windows, then it will be the 64-bit client library, which the installer may have been unable to delete because it was loaded. Your app is probably 32-bit and, if you are trying to run it locally, it's possibly not finding the 32-bit library of the same name. It could be worth checking. Let me know if there is any additional information I can provide that would further explain my situation. IBPhoenix does installation assistance as a professional service. IBP pays me (and others) to do this stuff for its paying customers. I'd better bow out here, lest I find myself in hot water with my principals. I'm sure someone will be able to get you back on the road, though. ./heLen
Re: [firebird-support] Re: Explanation about delta rows
Thank you Thomas, for your advice. Greetings. Walter. On Tue, Jan 8, 2013 at 12:45 PM, Thomas Steinmaurer t...@iblogmanager.comwrote: ** Walter, Well, FlameRobin is not enough for what I was looking for, so I shall write a program that can teach me everything about transactions. And the Trace API would be a perfect use case to see what's going on behind the scene with transaction and error tracing enabled. Regards, Thomas [Non-text portions of this message have been removed] ++ 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/