FB+ODBC+FlameRobin on Linux
This tutorial teaches how to install Firebird, Flamerobin and ODBC driver in a linux environment.
Category: Technical Articles
Technical articles, How-tos, guides, etc.
Generic Database Output Module for rsyslog
An introductory article about using the new Generic Database Output Module
This modules supports a large number of database systems via libdbi. Libdbi abstracts the database layer and provides drivers for many systems. Drivers are available via the libdbi-drivers project. As of this writing, the following drivers are available:
Integration Services, Part 1 – Import and data processing in Firebird and Interbase
SQL Server Integration Services (SSIS) – is a comfortable way for developing ETL processes. Integrations Services Projects are well integrated with other development tools of SQL Server 2005 – Analysis Services (SSAS) and Reporting Services (SSRS). Excel workbooks, text and XML files as well as databases with OLE DB Provider realization may be both data sources and data receivers. To work with Firebird и Interbase data в Integration Services you should use OLE DB Source and OLE DB Destination Components. Also you should install IBProvider Professional Edition.
Read full article.
Qt4 + Firebird – problem solved in ubuntu
This week I looked at Firebird2 and decided to give it a try. In a few minutes I discovered that the package libqt4-sql (the one that provides support for accessing databases from Qt4 apps) comes with just a few drivers enabled (coincidentally the ones that I mentioned above). Firebird is NOT enabled by default.
Here is how it was solved
Firebird .NET provider and calling sp with parameters
Firebird .NET provider has ability to create parameterized queries. Both named and unnamed parameters are supported. Everything works as you expect with select, insert, delete or update commands. The tricky part comes with stored procedures. Unlike MS SQL, that has direct support for named parameters, in provider, we’re parsing parameter names and we’re sending it to server “in right order”, so developer doesn’t need to know, that internally parameters were send unnamed.
Best way to open an database in qt(c++classes)
I want to exchange some ideas. I have a class to connect to the database Firebird. All classes that need access to the database is inherited this class. What is the best way to make connection to the database?
creating an empty firebird database in python
Here is an python thread on creating an empty database with kinterbase
What is SchemaProber?
The main purpose of SchemaProber is to provide a lightweight representation of a database schema. It doesn’t do anything except relay information from the database. Here’s the class diagram for SchemaProber
ADA (Autonomic Database Agent) – new project
ADA (Autonomic Database Agent) is a project that shows how to use AC concepts using AC techniques to implement autonomic behavior on a DBMS, a very popular kind of application, widely used nowadays and also a field where exploring autonomic concepts will show clear results. [He is using firebird for this autonomic unit]
Firebird embedded example for delphi is now ported to lazarus
I modified fb_embedded2.pas originally written for Delphi by Fikret Hasovic. Now it works with Lazarus!