Enter your search terms

Web ArticleSet.com Submit search form

Some people do not understand the differences between Interbase OLE DB and ODBC technologies. In this article we'll compare an OLE DB provider with an ODBC driver and review Firebird components.Interbase ODBC driverInterbase ODBC component - is the ODBC API realisation with C language. ODBC API calls are sent to the definite Firebird, Interbase database API.ODBC drivers were the firts attempt of the MS 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 Easysoft ODBC drivers spread separately for Firebird and InterBase:- Easysoft ODBC-InterBase Driver - declared about IB 6.5, IB 7, Interbase 6, IB 7.5 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 provider - IBProviderOLEDB or OLE DB - Object Linking and Embedding, Database.OLE DB was created after ODBC and became the Microsoft Company idea about standard data access components.OLE DB provides access to the Interbase and Firebird database using the Interbase and Firebird provider in Visual Studio 2005, 2008, Visual Basic, Delphi and other environments.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 realisation features.- easy update of database servers.- application connectivity with many DBMS. - Multiple development tools' support.The idea is that it's easier for developers to realise 1 standard component API than to support multiple DBMS with different API.

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