Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / New
Stats: 3,151,151 members, 7,811,292 topics. Date: Sunday, 28 April 2024 at 08:28 AM

Open Database Connectivity (odbc) - Programming - Nairaland

Nairaland Forum / Science/Technology / Programming / Open Database Connectivity (odbc) (1098 Views)

Pos Terminal Connectivity To Web Server / [Help Request] Help With Database Connectivity Error / Business Objects Connectivity To Oracle Rdb Database Issue (2) (3) (4)

(1) (Reply)

Open Database Connectivity (odbc) by Sorber98: 8:48am On Sep 08, 2009
Open Database Connectivity (ODBC) is an open standard application programming interface (API) for accessing a database. By using ODBC statements in a program, Web Design Firm can access files in a number of different databases, including Access, dBase, DB2, Excel, and Text. In addition to the ODBC software, a separate module or driver is needed for each database to be accessed. The main proponent and supplier of ODBC programming support is Microsoft.

ODBC is based on and closely aligned with The Open Group standard Structured Query Language (SQL) Call-Level Interface. It allows programs to use SQL requests that will access databases without having to know the proprietary interfaces to the databases. ODBC handles the SQL request and converts it into a request the individual database system understands.

ODBC was created by the SQL Access Group and first released in September, 1992. Although Microsoft Windows was the first to provide an ODBC product, versions now exist for UNIX, OS/2, and Macintosh platforms as well.

In the newer distributed object architecture called Common Object Request Broker Architecture (CORBA), the Persistent Object Service (POS) is a superset of both the Call-Level Interface and ODBC. When writing programs in the Java language and using the Java Database Connectivity (JDBC) application program interface, Website Design Firms can use a product that includes a JDBC-ODBC "bridge" program to reach ODBC-accessible databases.

1 Like

(1) (Reply)

Php Help! / Help On Php Code Simpllification / HELP!! Java Programmers In The House Pls Help.

(Go Up)

Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health
religion celebs tv-movies music-radio literature webmasters programming techmarket

Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10)

Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 20
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.