Jaybird updated

Jaybird 2.1.3 released. This release fixes only one bug, JDBC-106, which is related to the situation when developers use DatabaseMetaData class with identifiers/patterns with case different to the one in the database.

The solution is to try to execute the query with the original case and when nothing is found, another query with uppercased identifiers is executed. This, in worst case will cause two queries to be executed against the database, which can lead to performance loss.

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.

DATASUS using Firebird

Firebird is being used (and distributed) in several applications produced by DataSUS. SUS is the name of the unified public health system in Brazil. DataSUS is the department responsible for the development of computer applications, etc.

The applications are used in hospitals spreaded in the whole country. You can find several references of Firebird in DataSUS site, like here and here. Probably there are thousands of Firebird servers running only in the Brazilian’s hospitals.

1 61 62 63 64 65 100