Interesting issues and fixes with odbc and openoffice (usually you can use jdbc but that is another path to use firebird from OpenOffice/LibreOffice):
My name is Ocke Janssen, I’m the project lead of the dba.openoffice.org
project and I got a problem 😉
While trying to fetch bookmarks I crash inside the newest ODBC version
of Firebird.
(2 votes, average: 5.00 out of 5)
Loading... |
DA-SOFT Technologies announces the availability of AnyDAC for Delphi Spring 2011 release v 4.0.7.1719 – high-speed, Universal Data Access Components for Firebird, Interbase, SQLite, MySQL, MS SQL Server, Oracle, PostgreSQL, MS Access, IBM DB2, Sybase SQL Anywhere, Informix, DbExpress, ODBC, that simplifies the task of building Embarcadero Delphi, C++Builder and Free Pascal Compiler database applications. |
AnyDAC for Delphi can be immediately downloaded from the download page.
What is new in v4.0.7 and what is AnyDAC ?
(2 votes, average: 5.00 out of 5)Loading...
|
SQL Maestro Group is pleased to announce the release of Firebird Maestro v. 11.2, a powerful Windows GUI solution for Firebird administration and database development. |
New version features support for a lot of Firebird 2.5 and Firebird 2.1 new features, tools to generate CRUD stored procedures and updatable views, enhanced Dependency Tracker, and other useful things. Read full press-release.
(3 votes, average: 3.67 out of 5)Loading...You get an approximate value by running gstat and then check out the
Data pages value for the table. Multiply that value with your database page size. This is the allocated space on disk.
(3 votes, average: 3.67 out of 5)Loading...From Milan Babuskov blog:
I decided to automate conversion of MySQL database to Firebird. I got tired of manual find&replace process, and created a small parser that changes from MySQL to Firebird syntax. Currently it only supports database structure dump (no data, only structure) from PHPMyAdmin. Not all datatypes are supported, but feel free to “fix” it. It’s written in PHP and it’s open source. It would be great if you would send back any modifications you make. Download it here (source code included).
(12 votes, average: 5.00 out of 5)Loading...In this tutorial I will show you how to install multiple separate Firebird 2.1 servers on a single Host
(4 votes, average: 5.00 out of 5)Loading...What is Asyncronous System Trap ? : This is similar to Unixes signal’s or OS interrupts.
Technically this is callbacks from Lock Manager into the Engine called when
somebody acquires lock at level not compatible with current level. In this case
all processes who owns the lock receives notification and should take appropriate
action to release lock (immediately or deferred-ASAP).
The main trick with AST’s handlers is that AST is send asynchronously and
handler must take care to work correctly. Since v2.5 all ATS handlers runs in
separate thread. Before v2.5 it works using signals on Unixes and threads on
Windows.
PS the issue with old glibc and FB 2.5 is that since v2.5 we abandoned usage of old
System V semaphores (do you remember “semaphores are exhausted” error ? now
you can forget it completely) and start to use pthread mutexes. And old glibc have a
bugs in pthread mutex implementation.
(1 votes, average: 5.00 out of 5)Loading...Related to previous announcement:If you are on ubuntu and your ubuntu release is greater than Hardy (8.04) you are safe , on other distributions you can determine this way the glibc version
You must run the /lib/libc.so.6 and it will return the glibc version
in the first row.
In ubuntu or any debian based distro
/lib/libc.so.6 | head -n 1
GNU C Library (Ubuntu EGLIBC 2.13-0ubuntu1) stable release version
2.13, by Roland McGrath et al.
in this case glibc is 2.13
and is builded from eglibc sources
https://launchpad.net/ubuntu/+source/eglibc
another option is dpkg interrogation
dpkg -l libc6
on rpm based distros
rpm -q glibc
ps: other alternative ways
(No Ratings Yet)Loading...From www.firebirdsql.org:
It has been found that V.2.5 Classic for Linux has problems with AST delivery if used with glibc 2.5. With glibc 2.7 it works properly. The situation with glibc 2.6 is unknown for now. If your glibc version is lower than v.2.7, it must be upgraded before using Firebird 2.5 Classic/Superclassic.
(3 votes, average: 4.33 out of 5)Loading...Web-based Squirrel SQL client. It allows you to view database structure, import/export and manage your databases, including create database, table, store procedure, view,trigger and user. it supports Firebird
(2 votes, average: 5.00 out of 5)Loading...
