Firebird has some funny ways of handling passwords

Firebird has some funny ways of handling passwords. The maximum length of passwords that is evaluated is 8 characters. Every character after the 8th is silently ignored. That’s especially funny because the ‘default’ password for a Firebird-installation is ‘masterkey’, which has 9 characters. You can, however, successfully log in to freshly installed Firebird-servers providing the password ‘masterke’.
I’m working with Interbase and Firebird for more than four years and just now realized that when a co-worker at our company found it out while learning SQL.
The only program that I know that makes note of that is gsec, which prints a warning when setting the password to something longer than 8 characters.

http://daniel-albuschat.blogspot.com/2008/04/passwords-in-firebird.html

[ED:Daniel is working on webkit based browser named arrora ]

Thule is using Firebird and Firebird .NET Data Provider

Thanks to Steve Ramacher, who sent me this info.

We run our business on a couple of AS400 mid range computers (we are in the process of converting to MS Dynamics AX). We use BPCS for out ERP system. 7 years ago we started running into situations where we need to archive our reports to externals servers. This included reports that are ran daily and invoicing.

We started with SharePoint services but quickly out grew the capabilities of SharePoint (in regards to what MS indexing server could do). I wrote a role based security web site using firebird as the backend. I then wrote an administrators console to that allows Administrators to add/remove users, control there access, deploy smart client programs, and view reports.

The next task was very cool, I use MS DTS services (runs as a job in system agent) to extract data from our AS400 (DB2) and load the tables in our firebird server (running on windows). From that I am able to power our invoice lookup. We spool 1500+ invoices a day for orders through a product called reform which creates a PDF version of the output at the same time that it prints the spool. I wrote a program that matches up the customer, tracking, shipping to the invoice. So we have a customer service application (Smart Client) that they are able to lookup post shipment invoice information (Printed invoice, customer information, tracking information, proof of delivery, etc.) all being powered by Firebird and the .net providers.

I have used this provider with data tables, datasets, and custom collections with absolutely phenomenal success. Over the years I have upgraded the sites to include the new features of you provider (roll provider etc). I mostly write custom collections so that I can control my CRUD operations. If the power of linq makes it to firebird, that would be amazing.

Firebird Experts Forum – fastest forum i have ever seen is powered by firebird

The forum here is created using the phpBB Software, available on phpbb.com. It is a great and free Open Source Solution and since version 3, it has full support for firebird. This installation uses apache 2.0, phpBB 3.01, php 5.21 and firebird 2.1 on windows 2003 server.

Macedonia’s Ministry of Finance uses Firebird

The ministry’s Money Laundering Prevention Directorate (MLPD) used Gnu Privacy Guard (GPG) between 2004 and 2007. This is Open Source software for encrypting and electronically signing data, allowing it to be transmitted securely even through public networks. The directorate also uses the Open Source relational database management system Firebird. “Both the banks and the MLPD accepted our solution without any objections, and it did not introduce any costs”, comments Jovanovic.

Read full article here.

1 11 12 13 14 15 32