RE: [firebird-support] Migrate from 1.5 to 2.1 or 2.5: Which is the best choice?
I'm evaluating the choice of migrating a 1.5 Firebird database either to 2.1 or to 2.5. I've readed the release notes of both versions but I can't find no elements that help to decide which one could be best choice. Personally, I upgraded from 2.1 to 2.5.1 because of the new features I needed to take advantage of. I have ditched FreeUDFLib. I have also started using temporary tables to speed up certain complicated queries, that would otherwise have been too slow to implement. I've tested the client application with both versions (2.1 and 2.5) and it seems to work fine. My questions are: - Is there any good reason for not migrating to 2.5 and migrate to 2.1? Personally, I would just use the latest version, but I have recently had a Debian customer point out that there isn't a stable 2.5.1 build for them yet. - Should I jump directly to 2.5, keeping in mind that SQL and data contents migrating issues could be almost the same in both versions? I recently changed from 2.1 to 2.5.1 and had no issues with anything needing to be changed on my side. - Has somebody any application running Delphi BDE components using Firebird 2.5? Sorry, I use Delphi XE2 and FIBPlus data access components. Hope that helps somewhat! Maya
[firebird-support] ANN Early Bird registration for Firebird Conference 2012 is now open
Hello All, As you know, Firebird Conference 2012 will take place in Luxembourg, October 26-27. http://firebirdsql.org/en/firebird-conference-2012/ Early Bird registration for Firebird Conference 2012 in Luxembourg is now open. For those who register before October 1 there are discounts from standard EUR190/GBP169 attendee fee: -10% discount for single attendee EUR 171/GBP152 -20% discount for group 3+ EUR 153/GBP135.2 Register now: https://www.ibphoenix.com/shop/category/8?cur=GBP After October 1 regular fees will be applied: for single attendee it will be EUR 190 (GBP 169), for group 3+ EUR 171/152 Regards, Alexey Kovyazin IBSurgeon (www.ib-aid.com)
[firebird-support] Updating Null Column values Will Raise an Exception -605
ENDDATE is date and was created after the table being created and it allows nulls so it filled the colum with nulls. So i want to set ENDDATE then i do : UPDATE MYTABLE SET ENDDATE=CURRENT_DATE WHERE MYID=1 Error -605 value null This wasnt supposed to happen ? It should Set RowID MYID primarykey ENDDATE with the CURRENT_DATE .The problem yet is in the IBOConsole and My Application Components if i change it manualy it accepts it with no problem only Update Query Problem ? So client Drivers dot use Sql ? I dont undestand wheres the problem.
Re: [firebird-support] Re: Desktop Application For Centralized Firebird Database...
Em 6/9/2012 17:54, Aage Johansen escreveu: Vishal wrote: ... Here, my doubt is Using Delphi 5 and Firebird database, is it possible for all the instances of this application which are installed at different cities could access one centralized database ? If yes then HOW ? ... You need a fixed IP address for the machine which is hosting the database (the db server). Your program - wherever it runs - just need to use a connection string with IP address or machine name:database path and filename, or alias, e.g. 123.234.123.234:D:\DB\ourdb.fdb (or possibly VISHAL_SERVER:LIBRARY_DB, with necessary definitions in place). You may have to persuade administrators to open port 3050 in firewalls (in- and outbound). Besides all said by Aege, I recomend you to read this article: http://web.firebirdsql.org/download.php?op=fileid=firebird_zebedee_eng.pdf Even using a compressed tunnel, FB protocol is known to be slow over high latency connections, if you could develop using a 3-tier approach you will have a much better performance. Replication is another option, but adds some complexity. see you !
Re: [firebird-support] Re: Desktop Application For Centralized Firebird Database...
W dniu 2012-09-06 22:54, Aage Johansen pisze: Vishal wrote: ... Here, my doubt is Using Delphi 5 and Firebird database, is it possible for all the instances of this application which are installed at different cities could access one centralized database ? If yes then HOW ? ... You need a fixed IP address for the machine which is hosting the database (the db server). Your program - wherever it runs - just need to use a connection string with IP address or machine name:database path and filename, or alias, e.g. 123.234.123.234:D:\DB\ourdb.fdb (or possibly VISHAL_SERVER:LIBRARY_DB, with necessary definitions in place). You may have to persuade administrators to open port 3050 in firewalls (in- and outbound). -- Aage J. I think you should also think about encryption os transmitted data, or is something new I don't know about Firebird yet ( I'm stuck with version 1.5) ? Boguslaw
Re: [firebird-support] Re: Desktop Application For Centralized Firebird Database...
But if I have internet not an Intranet facility, then also would it work ? From: Aage Johansen aagjo...@online.no To: firebird-support@yahoogroups.com Sent: Friday, 7 September 2012 2:24 AM Subject: [firebird-support] Re: Desktop Application For Centralized Firebird Database... Vishal wrote: ... Here, my doubt is Using Delphi 5 and Firebird database, is it possible for all the instances of this application which are installed at different cities could access one centralized database ? If yes then HOW ? ... You need a fixed IP address for the machine which is hosting the database (the db server). Your program - wherever it runs - just need to use a connection string with IP address or machine name:database path and filename, or alias, e.g. 123.234.123.234:D:\DB\ourdb.fdb (or possibly VISHAL_SERVER:LIBRARY_DB, with necessary definitions in place). You may have to persuade administrators to open port 3050 in firewalls (in- and outbound). -- Aage J. [Non-text portions of this message have been removed]
Re: [firebird-support] Re: Desktop Application For Centralized Firebird Database...
Den 2012-09-09 06:20 skrev Vishal Tiwari såhär: But if I have internet not an Intranet facility, then also would it work ? Intranet or internet doesn't really matter re works or doesn't work. Internet has higher latency, which is nog very good for Firebird's chatty protocol, but it does work. You need to make sure all firewalls open port 3050 (or whatever port you choose for your FB server). You also need to make sure the clients know where the server is, i.e. its hostname or its IP address. This would normally be done either by using a regular domain name like yourcompany.com or if you don't have a domain name, simply make sure the server has a fixed IP address (most ISP:s provide this service at a low extra cost). Now, the data will travel over the internet unencrypted, so you either need to decide that this is no problem (not sensitive data) or establish a VPN or secure tunnel, e.g. using Zebedee as mentioned earlier. This might slow down the connection a bit further, depending on your situation and setup. If the data traffic is too slow, due to the combo of high latency internet and FB's chatty protocol, you can write an extra tier/layer/server thingy that executes on the same machine as the FB server and handles all communication with the actual database server. Your clients would talk to your server thingy instead, hopefully using a more efficient protocol. Kjell Vishal wrote: ... Here, my doubt is Using Delphi 5 and Firebird database, is it possible for all the instances of this application which are installed at different cities could access one centralized database ? If yes then HOW ? ... You need a fixed IP address for the machine which is hosting the database (the db server). Your program - wherever it runs - just need to use a connection string with IP address or machine name:database path and filename, or alias, e.g. 123.234.123.234:D:\DB\ourdb.fdb (or possibly VISHAL_SERVER:LIBRARY_DB, with necessary definitions in place). You may have to persuade administrators to open port 3050 in firewalls (in- and outbound). -- Aage J. [Non-text portions of this message have been removed] -- -- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 [Non-text portions of this message have been removed]
[firebird-support] Is there an auto-conversion for text blobs while reading with isc_get_segment?
Hi, is there an auto conversion from the character set of a text blob to the encoding set for the connection? For example, what happens if my client connection character set is UTF-8, but the text blob column has ISO-8859-1? Did isc_get_segement() return UTF-8 data or ISO-8859-1? As far as I understand the Interbase API manual, I need to setup a filter. But how can this be done? I assume something like this: isc_blob_lookup_desc(); // prepare from_desc; isc_blob_default_desc(); // prepare dest_desc; unsigned char bpb[20]; unsigned short actual_len; isc_blob_gen_bpb(sv, to_desc, from_desc, sizeof(bpb), bpb, actual_len); But I don't see how this get the connection encoding? The description for isc_blob_default_desc() tells me: [...] Character set is set to the default character set for the process or database. [...] But isc_blob_default_desc() has no database handle param or something else which can be used to resolve the connection encoding. So I think this is the wrong way. I'm also a little bit confused by the fact that the DPB for isc_attach_database() (option isc_dpb_lc_ctype) requires a string like UTF-8 but the isc_bpb_target_interp option in the BPB requires an integer ..hhuuu? -- Daniel Vogelbacher web: http://daniel.vogelbacher.name irc: cytrinox @ (freenode|ircnet|quakenet) www.informave.org