FirebirdSQL logo

Features Supported

  • Compiling for both 32-bit and 64-bit Windows clients on the Microsoft SDK base

  • Unicode

  • Thread-safe querying and other processing

  • Creating databases by means of functions SQLConfigDataSource, SQLDriverConnect, SQLExecDirect.

  • Multiple simultaneous transactions per connection, with varying transaction attributes if need be.For example, one read-only transaction, one or more simultaneous read/write transactions.

  • Transparent connection pooling via transaction settings

  • Firebird database events returned by triggers and stored procedures

  • Use of Microsoft ODBC cursors (odbccr32.dll, odbccu32.dll)

  • Firebird Services API (backup & restore, statistics, repair) by way of the function SQLConfigDataSource

  • The schemas SCHEMA or OWNER for cases where a schema is required for cross-DBMS compatibility in SQL queries

  • Fully functioning SQL syntax support for Services transactions via Firebird’s gpre pre-compiler language (“EmbedSQL”)

  • Use of the COM interface for Microsoft Distributed Transaction Coordinator (DTC)