Enter your search terms

Web ArticleSet.com Submit search form

Some people do not understand the differences between Firebird ODBC and OLE DB technologies. In this article we'll compare an OLE DB provider with an ODBC driver and review Firebird components.Interbase ODBC driverODBC Firebird driver - is the ODBC API realisation with C language. ODBC API calls are sent to the definite Firebird, Interbase database API.ODBC drivers were the Microsoft first attempt to provide a standard of data accessing.Advantages of the ODBC techology is cross platform features. UnixODBC development lets ODBC drivers' use on Unix platform.Firebird and Interbase ODBC manufacturesFirebird ODBC Driver/Gemini InterBase - project is not supported since March, 2005 ODBC Easysoft drivers spread separately for Firebird and InterBase:- Easysoft ODBC-InterBase Driver - declared about Interbase 6, IB 7.5, IB 6.5, IB 7 support- Easysoft ODBC-Firebird Driver - declared about Firebird 1FB 1.5 supportThere is a large list of ODBC drivers but no information about drivers' last update for InterBase and Firebird. If to look at the numbers of supported versions, the changes were long ago.Firebird and Interbase OLE DB component - IBProviderOLE DB (or OLEDB) - Object Linking and Embedding, Database.OLE DB was created after ODBC and became the MS Corporation idea about standard data access interfaces.It allows connect to the Firebird and Interbase SQL Server applying the Firebird and Interbase component in Visual Studio 2005, 2008, ADO.Net, Delphi and other tools.Advantages of standard interfaces useBoth technologies are designed by Microsoft. The techologies goal is to isolate the client from data source realisation features providing him with standard access interface.There are some pros of such approach:- independence of client application from data source.- easy update of database servers.- application connectivity with many DBMS. - Many development tools' support.The idea is that it's easier for developers to realise 1 standard component API than to support multiple SQL Servers with different API.

Article Source: http://www.articleset.com