Open Database Connectivity: Difference between revisions

Revision as of 22:49, 16 December 2004

Revision as of 14:23, 4 January 2005

Line 9:

A [[JDBC-ODBC Bridge]] is a [[JDBC]] [[driver]] which employs the ODBC driver to connect to the database. This driver translates JDBC method calls into ODBC function calls. Such a bridge is usually used when there is no [[JDBC]] driver available for a particular database. Sun included one such bridge in the [[JVM]], but this was intended as a stop-gap measure while JDBC Drivers were in short supply, was never meant for production use, and Sun generally recommends against its use. Independent data access vendors now deliver JDBC-ODBC Bridges which support current standards for both mechanisms, and far outperform the JVM built-in.

[[iODBC]], or Independent Open DataBase Connectivity, is an [[open source]], platform-independent implementation of both the ODBC and X/Open specifications, generally used on platforms other than [[Microsoft Windows]]. The iODBC project is distributed under the LGPL and/or BSD License, and is maintained and supported by [http://wwwuda.openlinksw.com/ OpenLink Software]. [[Apple Computer|Apple]] chose to bundle iODBC into [[Mac OS X]] and [[Apple Darwin|Darwin]], starting with Darwin 6.0 and [[Mac OS X 10.2]]. iODBC has been ported to several other operating systems and hardware platforms, including [[Mac OS 9]], [[Linux]] (x86, [[Itanium]], [[DEC Alpha|Alpha]], [[MIPS architecture|MIPS]], and [[StrongArm]]), [[Solaris Operating Environment|Solaris]] ([[SPARC]] & x86), [[AIX operating system|AIX]], [[HP-UX]] (PA-RISC & Itanium), [[Compaq]] [[Tru64]], [[Digital UNIX]], [[Dynix]], Generic UNIX 5.4, [[FreeBSD]], [[Data General|DG]]-UX, and [[OpenVMS]].

[[UnixODBC]] is a Driver Manager implementation for non MS Windows platforms. This is to include [[XFree86]] [[GUI]] support for both [[GNOME]] and [[KDE]]. UnixODBC is used by [[OpenOffice]].

Line 17:

*[http://www.roth.net/perl/odbc/conf/sld002.htm Presentation slides from www.roth.net]

*[http://www.iodbc.org/ The iODBC.org home page]

*[http://wwwuda.openlinksw.com/ OpenLink Software data access home page]

*[http://www.odbc.org/ The unixODBC Project home page]