tag:blogger.com,1999:blog-91800903107442492192012-01-13T22:59:07.595+04:00InterBase, Firebird and other interestingDmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.comBlogger461100tag:blogger.com,1999:blog-9180090310744249219.post-12880514714275824272011-09-06T15:14:00.000+04:002011-09-06T15:14:27.719+04:00

We deal with the hardware by lot of different cases - when someone ask us what to buy for the new server, how to improve existing hadware, and, of course, when database becomes corrupted. Many hadware vendors (as we see) sell servers with ready to use RAID (1, 5 or 10), with operating system installed on that raid. Also these hardware vendors think that it is cool that customer will place

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-77417811752659666142011-03-23T10:54:00.002+03:002011-03-23T11:44:40.619+03:00

You do not know what is that? Well, InterBase and Firebird allow specifying connection parameter that will disable garbage collection by statements in this connection. This is the same as the option -g for gbak. And, of course, all other connections without this parameter will continue to try collecting garbage in the database, if any. This connection option mostly is not known, because standard

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-75348729158264217602009-10-29T01:37:00.003+03:002009-10-29T02:02:51.568+03:00

Alexey posted interesting info about sudden computer failure. Since I'm working with computers from 1987, I wan to share my experience too.3 years ago my computer won't turn on. Possible causes could be - processor, motherboard or power unit. After some thinking I choosed to buy new power unit, and I was right - motherboard and processor were alive. I was lucky not buying new motherboard, righ?

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-31988325736903768702009-09-26T03:12:00.002+04:002009-09-26T03:30:15.167+04:00

Yes, sometimes I use FBScanner too. :-)My system is complex, because I have huge number of Firebird, InterBase and Yaffil versions. While Yaffil does not interfere with Firebird and InterBase, I need to run periodically Firebird 1.0, 1.5, 2.0, 2.1, 2.5 and InterBase 6.x, 7.0, 7.1, 7.5, 2007 and 2009. I do this by removing services records with "instsvc remove" after installation, because I don't

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-47742707510066149832009-09-25T15:34:00.002+04:002009-09-25T15:44:14.917+04:00

Remember our IBDeveloper Magazine, no? It was (and is) at the website www.ibdeveloper.com, but some time ago it was hacked, so, your browser may tell you that you should not open this link.Anyway, we started to place interesting presentations about Firebird and InterBase on Scribd, and now decided to put there our IBDeveloper Magazine, all 4 issues. And, we found old lovely InterCom magazine

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-71819103984951622432009-09-17T09:58:00.002+04:002009-09-17T10:29:09.779+04:00

I'm watching not only the InterBase and Firebird newsgrops and forums, but the Delphi also.And I know that at least lot of russian Delphi programmers complaining about still non-existing support of 64 bit Windows in Delphi.Today at DelphiFeeds.com I saw the post "64 bit tommorow – Wh/if you’ll have more than 4GB “today”?", and want to share my opinion on this. Also I wish you to vote at that

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com5tag:blogger.com,1999:blog-9180090310744249219.post-3341490906564250102009-08-24T09:58:00.001+04:002009-08-24T09:59:30.170+04:00

We made 1 terabyte database test with Firebird 2.1. Read more. Questions?

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com3tag:blogger.com,1999:blog-9180090310744249219.post-20771792767635693312009-06-26T10:55:00.003+04:002009-06-26T11:42:44.933+04:00

We found strange behavior of local protocol connection of the Firebird SuperServer 1.5 and Windows. Tests were made on AMD 2-core processor computer with command line backup likegbak -b -g db.fdb db.fbkWhen gbak is not "attached" to cores (uses all), or "attached" to another processor core where the Firebird SuperServer runs (for example, fbserver. exe at core 0, and gbak.exe at core 1), gbak

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com3tag:blogger.com,1999:blog-9180090310744249219.post-42111349441709620162009-06-17T10:02:00.002+04:002009-06-17T10:22:30.056+04:00

Someone may make wrong conclusion from my previous post about sorting that "sorting ... mostly does writes". But, yes, I was speaking only about temporary sort files, and the sorting process itself. The whole picture of the query with PLAN SORT is the followingserver (Firebird, InterBase) reads portions of the data from the query, does sorting of this block and writes it to the temporary file. So

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-67360037062625703992009-06-04T18:19:00.003+04:002009-06-04T19:12:58.690+04:00

Inspired by discussion about sorting (PLAN SORT), did some simple tests. Right now I do not have "an article" about this, but want to show you some discovered facts:sorting the temporary file (fb_sort_nnnn.tmp and ib_sort_nnnn.tmp) mostly does writes, not reads (excluding database reads and fetching data from temp file). Firebird 2.1 read/write ratio is 1:10. InterBase 2009 read/write ratio is

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com1tag:blogger.com,1999:blog-9180090310744249219.post-31660451291154515042009-03-25T00:19:00.002+03:002009-03-25T00:45:13.120+03:00

InterBase for years uses Y-valve, implemented by Jim Starkey, to support previous databases in new InterBase versions.The native ODS (On-Disk Structure) for the particular server version is the only one - the ODS of database created with this server. For example, native ODS for InterBase 6.0 is 10.0. For Firebird 1.5 - 10.1, etc.And, as a feature, InterBase and Firebird supports at least N-1 ODS

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-40197967153787480582009-02-10T13:24:00.002+03:002009-02-10T13:41:58.860+03:00

IBAnalyst since version 2.0 may report about broken or inconsistent indices. The detection of this cases is being made by checking index key count and record cound. If key count is less than records + versions, than the index is broken.How it can happen?At first, of course, it can happen when the database is broken, and some keys are missing. But the more realistic case for this inconsistency is

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-15294678455611498902008-11-12T17:16:00.003+03:002008-11-12T17:31:08.824+03:00

We are proud to announce the release of FBScanner 2.1. This version introduces a very interesting new features, such as plans extraction for queries, improved logging and tags support; these features make development and administration of Firebird and InterBase much more productive and effective. Read feature matrix and download trial of FBScanner 2.1 to estimate its value and effectiveness.

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-11925838563723164372008-10-16T18:28:00.002+04:002008-10-16T18:43:58.432+04:00

This is a continuation of previous post about Firebird. Now I’d like to consider some facts about money flows around Firebird.First of all, a good question is how much money is being consumed by Firebird.The only public information is a set of reports from Firebird Foundation. The last public report is from 2007 year: http://firebirdsql.org/ffoundation/plenary/page_finance_agm2007.pdfFull set of

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com5tag:blogger.com,1999:blog-9180090310744249219.post-26991686687641867142008-10-15T15:54:00.003+04:002008-10-15T17:01:29.531+04:00

I’d like to clarify some facts about Firebird and Firebird Foundation. I think right now is a correct time to remind how all these things are organized, because some messages about "crisis, firebird's death, low finances" and so on being spreaded around.It seems that many people think that Firebird Foundations owns Firebird, makes development strategic/tactic decisions or something like this.

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com4tag:blogger.com,1999:blog-9180090310744249219.post-15591193561296956252008-09-16T22:06:00.002+04:002008-09-16T22:11:30.390+04:00

You CAN'T miss FBCon 08 - 6th Firebird International Conference that will be held in Bergamo from 25 to 27 september. Conference will be from thursday september 25 till saturday Every day have a special theme with best italian and worldwide firebird-world expert!Here some of our sessions, for a detail go to www.firebirdconference.net:Italian sessions :CTE e query ricorsiveDatabase per sysdba –

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com1tag:blogger.com,1999:blog-9180090310744249219.post-7331949441207874032008-09-14T19:41:00.010+04:002008-09-15T12:22:43.631+04:00

Some last database repair cases we did were with multi-file databases. Interesting, that latest InterBase and Firebird versions was used, and also file system for the storage was NTFS, not FAT32 and FAT16. But, the databases was created and maintained using 1 gigabyte files.If you still use InterBase 5 and less, stop reading this, please :-)This is strange, because all InterBase and Firebird

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com1tag:blogger.com,1999:blog-9180090310744249219.post-89322515125180472962008-09-01T21:01:00.005+04:002008-09-14T07:07:39.756+04:00

It's a common question with interesting background from developers . As I can suppose from IBSurgeon statistics, 99% of Firebird and InterBase developers use default page size: since the old ages it is 1024 bytes, and only for Firebird 2.0 it is changed to 4096 by default.There are 4 main things related with page size: indices depth, database cache size, records per page quantity and disk cluster

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com2tag:blogger.com,1999:blog-9180090310744249219.post-13244856357059738552008-08-19T11:57:00.003+04:002008-08-19T12:02:00.512+04:00

If you get this message in firebird.logFatal lock manager error: semaphores are exhausted, errno: 1It means that you sould try to increase semaphores count in firebird.conf.Applications at Linux use semaphores to interchange data. More interesting question is why semaphores are exhausted? The most common answer is that some other software (probably, it was developed not well enough), that starts

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-90476833846700631422008-05-28T16:06:00.003+04:002008-05-28T16:18:04.864+04:00

There is no rules to name generator, of course. Because generators does not have any relation to it's usage. When generator is being used in trigger or procedure, you can track dependencies in rdb$dependencies table.But, during repair services for some databases, we found that generators may not have any understandable relation with table, trigger or procedure. Moreover, we couldn't compute any

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com1tag:blogger.com,1999:blog-9180090310744249219.post-46039724820567492872008-04-14T21:23:00.003+04:002008-04-14T21:49:40.866+04:00

In the second part of April there are 3 conferences in Moscow, Russia, where will be Firebird sessions:RIT-2008, Russian Internet Technologies Forum, April 14-15Interop 2008, 3-rd Exibition of Corporate Internet Techologies, April 23-24Corporate Database Systems 2008, April 24-25Sessions will be presented by Dmitry Emanov, the leader of Firebird development team, and by Dmitry Kuzmenko, CEO of

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-65512786495213029232008-01-15T14:45:00.000+03:002008-01-15T14:55:19.386+03:00

We'd like to invite German developers to our free seminar in Munich, Germany, Jan 24.Agenda:New in Firebird 2.1, Vladislav Khorsun, developer FirebirdFast Reports Business Intelligence solutions for Developers, Michael Philippenko, CEO Fast ReportsCorruption fighting and Firebird database protection, Dmitry Kuzmenko, CEO IBSurgeonFast Reports new products and solutions, Michael Philippenko, CEO

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-47011100636689147052008-01-09T18:27:00.000+03:002008-01-09T18:33:15.232+03:00

InformationWeek mentions Firebird. As a "somewhat moribund project". Nice.And, the real fact is that: "Nearly all of the 195 identified defects are in fact actually within an external piece of code we use for character sets and collation sequences ICU".

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-43371316812907528922007-12-21T12:54:00.000+03:002007-12-21T12:56:40.240+03:00

Dear Friends!IBSurgeon wishes you Merry Christmas and Happy New Year 2007 and announces traditional Christmas sales for all our products.To get 20.07% discount you need to use discount coupon code:xmas2007 This promotion is valid until 31 December 2007.Save up to USD$340 (for IBSurgeon Pack Site License)!Click "Buy Now" and don't forget to enter a coupon code!):IBFirstAID Personal - save USD$60!

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-42571470993095420082007-12-21T12:53:00.000+03:002007-12-21T13:27:06.792+03:00

Sorry for being late, and sorry for short seminar desctoption :-)Series of world-wide Firebird seminars ended this year with seminar in Warsaw. This was a special seminar, because it was organized by www.SoftKey.pl. Great thanks to Masha Kostrzebska - everything went great, and also hotel (Lord) was very fine (better than in Prague, and definitely better than in Paris - those who were in Paris

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-63681723439404820722007-11-12T10:22:00.000+03:002007-11-12T11:55:18.160+03:00

9 November, in Prague, in the series of Firebird events, there was a Firebird seminar. It was organized by IBPhoenix, IBSurgeon and FastReport with the great help of Pavel Cisar, IBPhoenix representative in Czech Republic. Sessions by main Firebird developer Dmitry Emanov, Dmitry Kuzmenko (IBSurgeon) and Mike Philippenko (FastReport), described Firebird roadmap, internals, security, optimization

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com2tag:blogger.com,1999:blog-9180090310744249219.post-36025230916863604432007-10-27T22:52:00.000+04:002007-10-27T22:53:50.795+04:00

30 October 2007, in Paris, France, there will be free seminar, organized by IBSurgeon (www.ib-aid.com), IBPhoenix France (www.ibphoenix.fr), Fast Reports (www.fast-report.com) and Mandriva (www.mandriva.com).Speakers at seminars will be Paul Beach, President of Firebird Foundation, with keynote and Firebird news, Vlad Khorsun, Firebird core developer, Dmitry Kuzmenko, IBSurgeon CEO and

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-12573157479445913392007-08-10T09:43:00.000+04:002007-08-10T10:25:46.970+04:00

While the SP1 was the only small bugfix and Vista fix, SP2 can be named something like InterBase 2007.5. Because it have some new interesting functionality:Journal preallocation - you may specify initial journal sizeDatabase file preallocations - you may specify initial database sizeDESCRIPTOR parameters for UDFs - ability to pass different data types at runtime, while parameter type is not

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-3423488399405984222007-07-19T17:18:00.000+04:002007-07-19T17:24:14.316+04:00

IBPhoenix announced a comprehensive set of tools for professional Firebird database application development - "IBPhoenix Firebird Developer Pack". This pack includesFirebird database engine Tools for database application development and management Tools for database monitoring and optimization Tools for database recovery and maintenance Replication tools Database connectivity drivers: .NET (with

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-76473231718000149472007-05-17T11:00:00.000+04:002007-05-17T11:02:38.377+04:00

Today new version of IBFirstAid is released. In short, now there are 2 separate versions - for Firebird and Interbase, both have lot of improvements.Read details at www.ib-aid.com.

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-84625299391901916722007-02-11T00:57:00.000+03:002007-11-12T20:02:39.677+03:00

Thanks to Fredrik Haglund for his post about this question.There are some issues with License Management, Local protocol (same as for Firebird, but IPCName can't be changed in ibconfig, as I know), and IBConsole.

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-24714567426431810342007-02-08T00:57:00.000+03:002007-02-08T02:43:40.790+03:00

Yes, it does!Of course, you want to know the details. Here they are.I used Vista Business that I've got some days ago from Microsoft. First I tried to install Firebird 2.01 RC1 distributive, and it went fine. Sorry, I have not tested Classic yet, but at least there are no problems with SuperServer.Since lot of public tests show that Windows Vista is slower than Windows XP at least for games, I

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com6tag:blogger.com,1999:blog-9180090310744249219.post-1756782590236280732007-02-01T01:02:00.000+03:002007-02-01T10:54:35.433+03:00

Today I've made some simple tests of Firebird's nbackup and InterBase 2007 online dump features.They have some differences, but one main point. Let's describe what nbackup or online dump is:You know that if you try to copy database when connections are active, you'll get broken copy. Because copying works sequentially, while database is a random access file. The idea of nbackup and online dump is

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com4tag:blogger.com,1999:blog-9180090310744249219.post-31183302229498981632007-01-27T15:29:00.000+03:002007-01-28T13:17:42.755+03:00

InterBase 6.0 introduced background garbage collection, but in active multi-user environments this caused to increase accumulation of garbage in database.In InterBase 7.1 Borland added 2 parameters, enabling to do something with garbage collection thread, allowing at least to experiment some with this issue. These parameters areSWEEP_QUANTUM - how much server time garbage collector thread will

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-80134783767581025692007-01-26T10:32:00.000+03:002007-01-26T10:41:45.523+03:00

"Firebird Null Guide" - nearly complete but boring descrption about nulls. Some things are missing:client-side specific of null processingbugs description does not refer to Firebird bug trackerno examples or links to "by descriptor" UDFsAnyway, I have not seen anything close to this document.

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-78929204807348711142007-01-10T20:44:00.000+03:002007-01-10T21:11:00.172+03:00

Several days ago I saw poll about auto-updating index statistics feature for Firebird at firebirdnews.org. Here is the results link.Well, 28% of voters think that this will be good. Interesting, that I can't say percent of systems where this feature will make performance worse. And can't say also, what percent of those 28% this will affect.Right now this is not a hard question to make auto-update

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-35037693183533465702006-12-06T10:13:00.000+03:002006-12-27T16:57:11.861+03:00

Some company had a database corruption - based on InterBase 5.6 system, oversized >4gb database. That company was not able to send database over internet, and their office also was one metro station from me, so I came to them to take broken database.Since this was a security office, I tried not to touch anything, and just looked at screen and told local administrator what to do.He showed me

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-34298792832950348512006-11-21T20:42:00.000+03:002006-11-21T20:50:08.200+03:00

Interesting that press starting to write more news about Firebird. For example, look at Firebird 2.0 announce at Computerworld. This is great, but, a lot of mistakes.First, I don't understand this kind of humour naming Firebird as "namesake open-source database". Next, operating systems list that Firebird supports a bit wider than "Windows, Linux and Solaris". And, at last, Borland's last releas

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-12277358483705729712006-10-15T01:37:00.000+04:002006-10-15T01:40:15.632+04:00

We did it! 14 October 2006. It went very fine. 200 visitors. ~25 people from sponsors and Firebird developers. Interesting sessions.2-nd conference will be next year, for sure.

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-10605437707938632462006-10-08T20:27:00.000+04:002006-10-25T18:50:12.808+04:00

IBAnalyst 2.0 is ready! New features list:Improved algorithms of statistics analysisFull Firebird 2 supportInterBase 2007 compatibleUses InterBase and Firebird client librariesTransaction Calculator - enables to understand how many transactions per seat your applications startsDatabase size and % of tables and indicesBroken or incomplete indices detectionMany interface changes - toolbar menu,

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-76972371174130132112006-09-20T16:52:00.001+04:002006-09-20T16:56:15.963+04:00

David Burton started series of articles about migration from MS SQL to Firebird.There is also "MS SQL to Firebird Migration Guide" at firebirdsql.org documentation page.

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-13307320437704050882006-09-18T16:27:00.000+04:002006-09-18T16:41:36.047+04:00

I found that Google Alerts is sometimes useless. During 3 weeks I tried to monitor news & web about Delphi, Firebird and Interbase, and the only news I've got were about Delphi Corp. (auto-parts company), Firebird tale and Stravinsky's music, and some protocol named "interbase".This is interesting at least because those keywords in their wanted meaning (IDE, RDBMS) can easily be found by Google

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-62022917033202037442006-09-01T11:37:00.000+04:002006-09-01T11:59:22.901+04:00

Do you remember old InterBase 5.6 bug when maximum number of transactions in database is depending on page size ?Strange, but early InterBase 6.0 versions have the same, sure. Yesterday we got database with the same sympthoms, but this is ODS 10.0 database with dialect 3, created with InterBase 6.0. Let's look at statistics from IBAnalyst:Sorry about numbers format, if it is hard to read - there

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-50223540545693816292006-08-18T01:42:00.000+04:002006-08-18T02:04:40.419+04:00

Borland released new DataDirect ODBC driver for InterBase customers (thanks Craig for the info). Also separate ADO .Net driver for InterBase (BDP 2.5.0) available.Both drivers are free for InterBase users, but there is another OLE DB driver that is very useful, especially for Visual Studio - IBProvider. It uses all existing and possible OLE DB features, like many transactions per one connect and

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-37535348447758751452006-08-18T01:26:00.000+04:002006-08-18T01:35:04.916+04:00

Yesterday we got broken database from some popular (in tight range) commercial system. It is built on InterBase 4.1, and still being sold by developers for wide range of shops. But, sometimes in these shops server power failure happens. In this case damage was increased by old InterBase 4 bug when data in header page is being shiffled. Hopefully, information was not broken, just mixed.Repair

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0tag:blogger.com,1999:blog-9180090310744249219.post-499657998723813102006-08-18T01:23:00.001+04:002006-08-18T01:23:55.584+04:00

In May our support got a customer alert that his InterBase 7.5 database is broken right after restore. We found that really, even after only metadata restore gfix reports about broken indices on rdb$dependencies and other system tables. Borland responded very quickly, telling that this is gfix error - it does not understand correctly new index structure introduced in ODS 11.2 databases. Hopefuly,

Dmitry Kuzmenkohttp://www.blogger.com/profile/14873944766211767677noreply@blogger.com0