Category: Technical Articles

Technical articles, How-tos, guides, etc.

Integration Services, Part 1 – Import and data processing in Firebird and Interbase

Leave a comment

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.

Firebird .NET provider and calling sp with parameters

Leave a comment

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.

Firebird embedded example for delphi is now ported to lazarus

Leave a comment

I modified fb_embedded2.pas originally written for Delphi by Fikret Hasovic. Now it works with Lazarus!

Firebird Relational Database ‘protocol.cpp’ XDR Protocol Remote Memory Corruption Vulnerability

Leave a comment

Firebird is prone to an integer-overflow vulnerability because it fails to ensure that integer values aren’t overrun. Attackers may exploit this issue to overflow a buffer and to corrupt process memory.

Attackers may be able to execute arbitrary machine code in the context of an affected application. Failed exploit attempts will likely result in a denial-of-service condition.

1 … 52 53 54 55 56 … 78