Developing drivers for all of these requires significant time, effort, and expertise. The industry standard APIs required to enable access by developers, third-party tools and application packages are ADO.NET, JDBC, ODBC and OLE DB. So what makes ODBC popular with different industry factions and why will ODBC remain popular for the foreseeable future?įor the data source owner ODBC is a must. ERP, CRM, and SCM packages all use ODBC as do query, analysis, reporting and ETL packages as well as productivity applications such as Microsoft Office. ODBC is very popular for custom enterprise application development and is widely supported by market leading ISVs. For any data source that lacks an ODBC driver there are numerous driver development kits and driver development shops waiting to help you plug that gap! It goes without saying that no respectable relational database lacks an ODBC driver. For example, many COBOL applications use ODBC for database access as do dynamic languages such as PHP, Perl, Python and Ruby along with Microsoft Access and other RADs.ĭespite being conceptually limited to relational databases, no significant data source lacks an ODBC driver: text files, Excel spreadsheets, ISAMs such as dBase, Paradox, C-ISAM, Btrieve and VSAM-you name it and an ODBC driver is most likely available. Though often thought of as an API for C and C++ applications, ODBC is frequently used with other languages. Probably the best known implementation of ISO/IEC 9075-3:2003 SQL Call Level Interface (part 3 of the complete SQL standard), ODBC is included in Windows, MacOS, all major Linux distributions, and is readily available for many Unix versions including AIX, HP-UX, Solaris, and FreeBSD. This article explains why and will explore the relationship between Microsoft SQL Server and ODBC and discuss where ODBC may go in the future.Ĭonceived as a broadly based, multi-platform, multi-database data access technology, ODBC has been an outstanding success. Fifteen years after its launch, ODBC is a firmly entrenched cornerstone of the software industry.
0 kommentar(er)
