Lead too short date April 2010 Refimprove date August 2009 In computing , ODBC Open Database Connectivity ... system s DBMS . The designers of ODBC aimed to make it independent of database systems and operating system s. An application can use ODBC to query data from a DBMS, regardless of the operating system or DBMS it uses. ODBC accomplishes DBMS independence by using an ODBC driver as a translation layer between the application and the DBMS. The application uses ODBC functions through an ODBC driver manager with which it is linked, and the driver passes the query to the DBMS. Overview ODBC defines .... ODBC provides a universal middleware layer between the application and DBMS, allowing ..., only the driver needs updating. An ODBC driver can be thought of as analogous to a printer or other ... functionality. An application that can use ODBC is referred to as ODBC compliant . Any ODBC compliant ... ODBC by adapting the SQL Access Group CLI. ref cite book last Harindranath first G coauthors ... isbn 9780306472510 page 451 pages 695 quote The first ODBC drivers ... used the SIMBA query processor ... Organization for Standardization ISO International Electrotechnical Commission IEC . ODBC 1.0 was released in September 1992. ref cite web url http www.easysoft.com developer interfaces odbc linux.html what is odbc title Linux UNIX ODBC What is ODBC? ref After ODBC 2.0, Microsoft decided to align ODBC 3.0 with the CLI specification making its way through X Open and ISO. In 1995, SQL CLI became ... developer interfaces odbc linux.html odbc versions title ODBC Versions date month year work Linux UNIX ODBC publisher Easysoft accessdate 2009 10 27 ref 1.0 released in September 1992 ref cite web ... Cluj Napoca page 2 format PDF accessdate 2009 10 27 quote ODBC 1.0 was released in September 1992 ... en us library ee388580 28VS.85 29.aspx title What s New in ODBC 3.8 publisher Microsoft accessdate 2010 01 13 quote Windows 7 includes an updated version of ODBC, ODBC 3.8. ref Drivers ... more details
Infobox Software name ODBC Administrator logo Image ODBC Administrator icon.png 64px screenshot Image ODBC Administrator screenshot.png 220px caption developer Apple Computer latest release version 1.0.2 latest release date operating system Mac OS X genre Database utility license Proprietary software Proprietary website http support.apple.com kb dl895 ODBC Administrator is a utility in the Mac OS X operating system for administering ODBC . mac stub Mac OS X Category Mac OS X Category SQL data access it Amministratore ODBC uk ODBC Administrator ... more details
advertisement date June 2008 Infobox Software name OpenLink Ruby on Rails ODBC Adapter logo developer ... Ruby , ODBC , Databases , Data Architecture , Software license Dual licensing Dual Licensed GNU General Public License GPL and Commercial website http odbc rails.rubyforge.org Official Web page The OpenLink Ruby on Rails ODBC Adapter is a native Ruby on Rails adapter providing transparent and consistent ... ODBC Adapter is released as free, open source software under the GNU General Public License . It requires the http ch werner.de rubyodbc Ruby ODBC Adapter for operation. OpenLink Rails ODBC Adapter The OpenLink Rails ODBC Adapter has been designed to provide a generic data access layer to the Rails ActiveRecord Framework library, enabling connectivity to any ODBC enabled database. This is achieved through use of the http ch werner.de rubyodbc Ruby ODBC Adapter from Christian Werner for the bridge from Ruby to the C based ODBC API. The OpenLink Rails ODBC Adapter has been tested extensively with the OpenLink ODBC Drivers . For full functionality, ActiveRecord requires specific features in the underlying ODBC drivers, and the OpenLink drivers were enhanced for this purpose. For this reason, it is recommended that the OpenLink Rails ODBC Adapter be used with these drivers where possible. The Rails Adapter does work to a fair degree with other third party ODBC Drivers. The following ODBC enabled DBMS databases are tested and certified compatible see the http odbc rails.rubyforge.org ... MySQL PostgreSQL DB2 Progress Installation Details on the installation of the Rails ODBC Adapter can be obtained from the official http odbc rails.rubyforge.org OpenLink Rails ODBC Adapter site , but in summary are Install Ruby Install Ruby ODBC Adapter Install Ruby Gems Install Ruby on Rails Install Rails ODBC Adapter See also OpenLink Software , the company that builds and maintains the Rails ODBC Adapter OpenLink ODBC Drivers , extended and certified specifically for use with the Rails ODBC ... more details
Connectivity ODBC logo developer OpenLink Software operating system Cross platform genre ODBC , Databases ... website http uda.openlinksw.com odbc Official Web page High performance, standards compliant data access drivers, the http data.openlinksw.com oplweb product category odbc this OpenLink Drivers for Open Database Connectivity ODBC were arguably the first ODBC driver implementation available for non ... transparent, ODBC based access to data sources such as DBMS databases from Desktop Productivity ... ODBC started as Windows only components, as ODBC was then a Windows only technology, and were strictly ... specific proprietary communication layers with its own network layer for serving ODBC clients. The new ... Tier were also handled by the new Multi Tier implementation. ref name DBMS ODBC Special Report, ODBC Branches Out, April 1996 cite news first Ken last North coauthors title ODBC Branches Out date ... of ODBC should be available to users on any platform. However, there was no ODBC Driver Manager available on any other platform. Therefore, initially, the Windows only ODBC drivers were accompanied ... platforms. In this packaging, all functions of the ODBC Driver Manager were built directly into the data ... by their UDBC products, Ke Jin partnered with OpenLink to develop the non Windows ODBC Driver Manager ... ODBC support to many non Windows operating systems including Solaris, AIX, HP UX, OpenVMS, the BSD ... name DBMS ODBC Special Report, Power to the People, April 1996 cite news first Clara H. last Parkes ... implementation, and have yet to be matched in any other data access implementation, ODBC or otherwise ... and every supported DBMS. When ODBC started getting significant uptake, the DBMS vendors seemed ... that ODBC was slow by nature. This generalized knock on the protocol was disproven by published studies, ref name DBMS ODBC Special Report, ODBC Branches Out, April 1996 cite news first Ken last North coauthors title ODBC Branches Out date April 1996 publisher Miller Freeman, Inc. url http www.dbmsmag.com ... more details
MyODBC is an ODBC interface and allows programming language s that support the ODBC Interface computer science interface to communicate with a MySQL database. The official name is Connector ODBC which designates the MySQL AB product family of MySQL ODBC drivers. These are known as the MyODBC drivers . External links http dev.mysql.com doc refman 5.1 en connector odbc introduction.html Introduction to MyODBC http forge.mysql.com wiki MyODBC MyODBC Page on MySQL Forge Wiki http dev.mysql.com downloads connector odbc 3.51.html MySQL Connector ODBC 3.51 Downloads http dev.mysql.com downloads connector odbc 5.1.html MySQL Connector ODBC 5.1 Downloads http webaj.com how setup mysql dsn datasbase source centos myodbc and unixodbc command line.htm How to setup sic MyODBC compu prog stub Category Data access technologies Category Application programming interfaces lt MyODBC ru MyODBC ... more details
lowercase title iODBC Infobox Software name iODBC logo caption developer latest release version 3.52.7 latest release date September 10, 2009 latest preview version latest preview date operating system Cross platform genre Data Access API license BSD Licenses BSD , LGPL website http www.iodbc.org www.iodbc.org Portal Free software iODBC is an open source initiative managed by OpenLink Software. It is a platform independent Open Database Connectivity ODBC Software development kit SDK and runtime offering that enables the development of ODBC compliant applications and drivers outside the Microsoft Windows Windows platform. The prime goals of this project are as follows Simplify the effort of porting ODBC applications from Windows to other platforms Simplify the effort of porting ODBC drivers from Windows to other platforms Create consistent ODBC utilization experience across all platforms History iODBC emerged from a cooperative effort between OpenLink Software and Ke Jin. OpenLink Software produced a Driver Manager less ODBC SDK that it branded as Open Database Connectivity UDBC Universal DataBase Connectivity ODBC UDBC UDBC in 1993, because of the sporadic nature of shared library implementations across Unix platforms. Ke Jin used UDBC as inspiration for building a Driver Manager for ODBC outside the windows platform. Over time Ke Jin and OpenLink Software decided to merge this effort into a single Open Source offering under the LGPL license. This process occurred at a time when the Free Software Foundation sought to have iODBC as a GNU General Public License GPL offering. The delay in determining final licensing status for iODBC led to the emergence of UnixODBC and led to a Fork software development fork in the platform independent ODBC SDK and runtime that exists today. Drivers and applications written using either SDK have remained compatible a tribute to both projects . External links http www.iodbc.org iODBC homepage Category SQL data access Category Middleware ... more details
products jdbc driverdesc.html Sun JDBC Overview ref Type1 Driver JDBC ODBC bridge Image JDBC driver.png thumb right 300px Schematic of the JDBC ODBC bridge The JDBC type1 driver, also known as the JDBC ODBC bridge, is a database driver implementation that employs the ODBC driver to connect to the database. The driver converts JDBC method calls into ODBC function calls. The driver is platform dependent as it makes use of ODBC which in turn depends on native libraries of the underlying ... for example, ODBC must be installed on the computer having the driver and the database must support an ODBC driver. The use of this driver is discouraged if the alternative of a pure Java driver ... by the functionality of the ODBC driver. Functions Translates query obtained by JDBC into corresponding ODBC query, which is then handled by the ODBC driver. Sun provides a JDBC ODBC Bridge driver. sun.jdbc.odbc.JdbcOdbcDriver. ... Driver ODBC Driver Database Advantages Easy to connect. Directly connected to the database. Disadvantages Performance overhead since the calls have to go through the jdbc Overhead bridge to the ODBC ... . The ODBC driver needs to be installed on the client machine. Not suitable for applets, because the ODBC ..., is preferred over this driver. Advantages As there is no implementation of jdbc odbc bridge, its ... of conversion of calls into ODBC or database API calls. Unlike the type 3 drivers, it does not need ... These drivers don t translate the requests into an intermediary format such as ODBC , nor do they need ... DB Open Database Connectivity ODBC References Reflist Category Java platform Category Data access ... more details
BBx is the original name for the Business Basic interpreter developed by BASIS International in 1985. Subsequent generations of BBx have been BBxPROGRESSION 2, BBxPROGRESSION 3, PROGRESSION 4, PRO 5 and Visual PRO 5. BASIS estimates that over 1.7 million end users worldwide run applications built with their products. BBx dialects include PRO 5 a character mode interpreter for Linux and Unix environments , Visual PRO 5 a graphical interpreter for the Microsoft Windows environment , PRO 5 Data Server a data server for PRO 5 data files , the BASIS ODBC Driver a Microsoft Windows ODBC driver for PRO 5 data files . The current generation of BBx BBj is a superset of the BBx language and environment implemented in Java programming language Java . External links http www.basis.com BASIS International Ltd. Category BASIC programming language family ... more details
. Simba pioneered ODBC by co developing the first standards based ODBC driver with Microsoft ... to build their original QuickDB server. Products Simba s products include a JDBC ODBC SDK , an OLAP ... data connectivity products. Primary Products Include http www.simba.com odbc sdk.htm SimbaEngine ODBC SDK An ODBC Driver, JDBC Driver, OLE DB Driver, or ADO.NET data Provider to any data source ... Cube ODBC JDBC SQL access for a MDX data cube http www.simba.com odbo to xmla.htm SimbaO2X Connects ... with Simba to develop ODBC 1993 Microsoft puts Simba technology on 30 million desktops 1993 Digital and Oracle partner with Simba 1993 First to ship complete software development kits for ODBC drivers ... solutions 1995 Pioneers server based ODBC. ODBC solutions for the UNIX market are delivered ... and Simba ODBC Driver for Microsoft HealthVault 2010 Simba releases SimbaEngine SDK 8.0.2 and SimbaProvider ... more details
unreferenced date September 2011 lowercase title unixODBC Infobox Software name unixODBC logo caption developer latest release version 2.3.1 latest release date November 28, 2011 latest preview version latest preview date operating system Cross platform genre Data Access API license GNU GPL GNU LGPL LGPL website http www.unixODBC.org www.unixODBC.org Portal Free software unixODBC is an open source project that implements the ODBC API . The code is provided under the GNU GPL LGPL license and can be built and used on many different operating systems, including most versions of Unix , Linux , Mac OS X , IBM OS 2 and Microsoft s Interix . The goals of the project include Provide developers with the tools to port Microsoft Windows ODBC applications to other platforms with the minimum of code changes. Maintain the project as a vendor neutral interface database SDK Provide ODBC drivers writers the tools to port their drivers to non Windows platforms Provide the user with a set of GUI and command line tools for managing their database access Maintain links with both the free software community and commercial database vendors, to ensure interoperability History 1999 The unixODBC project was first started in the early months of 1999 by Peter Harvey and was created as at that time the developers of iODBC another open source ODBC implementation were not then willing to LGPL the code, expand the API to include the current ODBC 3 API specification, and did not consider the addition of GUI based configuration tools worthwhile. iODBC now has these parts added, and applications that use the ODBC interface may use both iODBC and unixODBC, without change in most cases, as a result of both projects adhering to the single ODBC specification. 1999 July The original driver manager was very basic. The driver manager was rewritten by http www.easysoft.com Easysoft s Nick Gorham soon after the project started. Nick assumed leadership of the project in July 1999 with Peter Harvey continuing w ... more details
Orphan date February 2009 WebSiphon is a World Wide Web application server and software development tool used to create dynamic, data driven web sites. WebSiphon was developed by Purity Software for the Mac OS operating system , with version 1.0 released publicly in 1996. WebSiphon combines the proprietary SiphonScript scripting language with connectivity to several databases, including MySQL , FileMaker , and ODBC ODBC compliant databases, as well as its own integrated flat file database , called Purity Verona Verona . WebSiphon features functionality found in scripting based application servers as well as traditional Common Gateway Interface CGI . A developer can embed SiphonScript in HTML documents or execute a function in a stand alone SiphonScript Software package installation package . See also Perl PHP Active Server Pages ColdFusion External links http www.purity.com websiphon.ws WebSiphon product details http www.purity.com websiphon guide index.html WebSiphon documentation and SiphonScript language reference Category Web development software ... more details
Infobox software name Oracle Template Library title logo File screenshot File caption collapsible author Sergei Kuchin developer released Start date YYYY MM DD df yes no discontinued latest release version latest release date Start date and age YYYY MM DD df yes no latest preview version latest preview date Start date and age YYYY MM DD df yes no frequently updated DO NOT include this parameter unless you know what it does programming language C operating system platform size language status genre library computing library or Software framework framework license website URL otl.sourceforge.net The Oracle, ODBC, and DB2 CLI Template Library OTL is a C library for database access, written by Sergei Kuchin. The OTL exists since 1996. It consists of a single header file. Besides Oracle, the OTL supports DB2 natively , and various database systems now, directly or indirectly via Open Database Connectivity ODBC . External links sourceforge otl Category C libraries ... more details
Multiple issues advert November 2009 coi November 2009 notability November 2009 primarysources November 2009 ElevateDB is an embedded database engine developed and marketed by http www.elevatesoft.com Elevate Software, Inc. ElevateDB supports most of the ANSI SQL 2003 standard with minimal deviations, and includes support for dynamic SQL PSM in scripts, stored procedures functions, triggers, and jobs. ElevateDB can be compiled directly into the application using Delphi Lazarus C Builder, or is available as a single assembly .NET Framework .NET data provider for .NET and .NET Compact Framework applications and a single DLL ODBC driver for applications that can use the ODBC API for database access, such as Java programming language Java and PHP . External links http www.elevatesoft.com Elevate Software, Inc. http www.elevatesoft.com prodinfo?action list ElevateDB Product Information http www.elevatesoft.com articles?action list ElevateDB Technical Articles DEFAULTSORT Elevatedb Category Database engines ... more details
with ODBC for Native Relational Data Access ref Providers like ADO.Net which can run on top ... of OLE DB itself remains unclear. The same FAQ states that ODBC performs better than OLE DB ... more details
the queries in code rather than resources. The High Level interface is broadly similar to ODBC ..., retrieving data line by line for instance. One major difference between DAM and ODBC came about largely ..., ODBC was developed from the start to be a SQL based system, based on the standardized Call ... the commands and read the file. Under ODBC, all data source drivers are expected to understand ... it is returned. This difference made DAM much less useful than ODBC in practice. Since it was expected that DAL would be providing query standardization, DAM had no layer similar to ODBC s for translating ... Mac OS version of ODBC was available for some time, although support was limited. Starting with the release of OS X 10.2 Jaguar , Apple started distributing a version of the iODBC cross platform ODBC ... to ODBC when used with a non SQL data source. External links http developer.apple.com documentation ... more details
Remote Data Objects abbreviated RDO is the name of an obsolete data access application programming interface primarily used in Microsoft Visual Basic applications on Windows 95 and later operating systems . ref cite web last Microsoft title Using Remote Data Objects RemoteData Control url http msdn.microsoft.com en us library aa733681 VS.60 .aspx accessdate 2009 01 04 ref This includes database connection, queries, stored procedures, result manipulation, and change commits. It allowed developers to create interfaces that can directly interact with Open Database Connectivity ODBC data sources on remote machines, without having to deal with the comparatively complex ODBC API. Remote Data Objects was included with versions 4, 5, and 6 of Visual Basic the final version of RDO is version 2.0. References reflist See also Microsoft Data Access Components External links http msdn2.microsoft.com en us library aa733681 VS.60 .aspx Using Remote Data Objects and the RemoteData Control &mdash Documentation on the Microsoft Developer Network windows stub Category Microsoft application programming interfaces Category Database APIs de Remote Data Objects es Remote Data Objects ja Remote Data Objects pt RDO ru RDO ... more details
Unreferenced date February 2007 orphan date November 2009 Event Programming Language EPL was an early attempt by iSpheres at a standard SQL style language for detecting patterns of events in data . EPL enabled conditions on historical information, including ODBC databases, as well as real life streaming data , such as stock ticker stock ticks in one boolean condition. EPL had the ability to store time or length based windows for continual historical analysis , which is now accepted as a standard feature in the complex event processing market. When the condition was satisfied, a sequence of actions could be taken, including inserting a new event into another event stream. All EPL statements are of the form blockquote ON trigger WHEN boolean condition THEN sequence of actions blockquote Category Query languages Compu lang stub ... more details
unreferenced date December 2008 Relational Interface System RIS is Intergraph Corporation s middleware for connecting client software and DBMS . Was developed for UNIX including Intergraph CLIX CLIX many years before ODBC and last years for Apple Macintosh and Windows computers. It is used in geographic information system s Modular GIS Environment MGE and GeoMedia , the digital photogrammetric station ImageStation , security systems, CAD software such as MicroStation and mechanical design software I EMS predecessor of Solid Edge . Category Proprietary database management systems Database stub ru Relational Interface System ... more details
be ODBC . ODBC is a platform independent implementation of a database abstraction layer. The user installs specific driver software, through which ODBC can communicate with a database or set of databases. The user then has the ability to have programs communicate with ODBC, which then relays the results ... ODBC. Dependency A database abstraction layer provides yet another functional dependency for a software ... more details
less appealing than later systems like ODBC , where the translation normally takes place on the client side and is typically included for free with the database engine. The downside to the ODBC ... was later rolled into a single ODBC like driver layer, the Data Access Manager DAM . DAM was ODBC ... more details
Infobox Software name OpenDBX logo Image Logo opendbx.png caption developer Open Source Community latest release version 1.4.5 latest release date Apr 04, 2010 operating system Linux , Mac OS X , Microsoft Windows Windows , Unix genre Application programming interface API license LGPL website http www.linuxnetworks.de doc index.php OpenDBX www.linuxnetworks.de The OpenDBX library provides a unified and consistent Application programming interface API for software developers to different Database Management System database management systems . The Library computer science function library is written in the C programming language and aims at implementing access to the native database interfaces efficiently via a thin abstraction layer. It consists of a basic set of functions which are part of all vendor database libraries and can be extended by additional function blocks. Contrary to interfaces like ODBC , the OpenDBX library favors speed and flexibility and therefore doesn t try to unify the SQL SQL query language . It enables the application developer either to use only standardized SQL elements or to utilize more efficient database specific language elements as well. Furthermore, this approach allows adding support for databases which do not implement SQL as query language. Supported databases Firebird database server Firebird Interbase Microsoft SQL Server MS SQL Server MySQL Oracle database Oracle ODBC PostgreSQL SQLite SQLite 2 and 3 Adaptive Server Enterprise Sybase ASE External links http www.linuxnetworks.de doc index.php OpenDBX OpenDBX Website http sourceforge.net projects libopendbx Sourceforge project Category Application programming interfaces Category C libraries de OpenDBX ... more details
Butler SQL is a now defunct SQL based database server for the classic Mac OS from EveryWare Development. For much of its history it was partnered with another EveryWare product, Tango, that built dynamic database pages from SQL data. The product eventually ended up with Pervasive Software , although it is no longer sold. Butler was introduced to take advantage of new a Mac OS component known as the Data Access Manager DAM , which was similar in concept to ODBC , allowing end user client programs to access various data sources. Butler itself used another Apple technology, Data Access Language DAL , which was a variant of SQL that included additional flow control and data manipulation instructions. Butler spoke DAL as its native internal language, and supplied a number of DAM extensions to provide connectivity over a variety of networking systems. Butler 2.0, released in May 1996, added direct ODBC links as well. Butler suffered from performance problems due to the single user nature of the Mac OS. In particular, file access was single threaded and multitasking was coordinated by the applications, not the operating system. References Lawrence Charters, http www.wap.org meetings GM0196.html Data, Data EveryWare , January 1996 General Meeting , Washington Apple Pi http www.allbusiness.com technology software services applications network software 7229096 1.html EveryWare ships Butler SQL 2.0 , Business Wire , 13 May 1996 Category Discontinued software Category Mac OS software Category Proprietary database management systems ... more details
Encyclopedia
top
