What is the differences between OLE DB and ODBC technologies. Having Firebird and Interbase databases as the examples, there are some tips that can help choosing the data access provider.
New SQL instructions and features were added to Firebird 2.0: Derived Tables, EXECUTE BLOCK, INSERT RETURNING, ROLLBACK RETAIN, ROWS. Lets write a few c# examples for ADO .Net
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
Most interesting features of Firebird 2.1 are common table expressions CTE), global database triggers, temporary tables, database monitoring through the SQL, canceling running queries and new SQL statements
ODBC Escape sequences has included in ODBC standard and allows write SQL queries which compatible with many DBMS. Firebird and Interbase does not contains own implementation for escape sequences and therefore we have implemented them in IBProvider and now