(Open DataBase Connectivity) A database programming interface from Microsoft that provides a common language for Windows applications to access databases on a network. ODBC is made up of the function calls programmers write into their applications and the ODBC drivers themselves.
For client/server database systems such as Oracle and SQL Server, the ODBC driver provides links to their database engines to access the database. For desktop database systems such as Access and FoxPro, the ODBC drivers actually manipulate the data. ODBC supports SQL and non-SQL databases. Although the application always uses SQL to communicate with ODBC, ODBC will communicate with non-SQL databases in its native language. See JDBC.
ODBC Interfaces
These are the various ways applications access data sources using ODBC and other Microsoft interfaces.
For client/server database systems such as Oracle and SQL Server, the ODBC driver provides links to their database engines to access the database. For desktop database systems such as Access and FoxPro, the ODBC drivers actually manipulate the data. ODBC supports SQL and non-SQL databases. Although the application always uses SQL to communicate with ODBC, ODBC will communicate with non-SQL databases in its native language. See JDBC.
ODBC Interfaces
These are the various ways applications access data sources using ODBC and other Microsoft interfaces.
 | Reproduced with permission from Computer Desktop Encyclopedia. Copyright (c) 1981-2008 The Computer Language Company Inc. All rights reserved. |
Additional Resources
- DBTools (zip)
- DBTools is a database interface program. It was coded by MS 6.0 with MFC connect with ODBC drivers. So it can run on MS platform only. DBTools provides a standard command-file interface for DataBases access on MS platform. This version is the first release on CNET Download.com.
- Software downloads 2008-08-15
- Navicat (Oracle GUI) (exe)
- Navicat Oracle GUI is an Oracle database management tool, which can convert XML, CSV, MS Excel, MS Access, and popular data formats to MySQL databases, eliminating time-consuming data entry and the errors that accompany it. Other useful major features include Import and Export wizard, Unicode support, SSH Tunnel, Batch Job...
- Software downloads 2008-08-15
- Development environments: Microsoft vs. Open Source
- Development environments: Microsoft vs. Open SourceA little simple reasoning... is enough to reveal what's going on. Let's try.Quote: "Anything you can do with Microsoft servers, clients, Office, and dot.net technologies I can do better [i.e. at some combination of greater functionality, lower risk, and lower cost] using the standard LAMP/SAMP...
- Discussion threads 2008-08-07
- WinSQL (do)
- WinSQL is a must have utility for DBAs and programmers who deal with databases. It empowers them to be more productive by providing an intuitive tool that can talk to any database through ODBC. More than 80% of today's business applications require interaction with a relational database. In a typical...
- Software downloads 2008-08-06
- Navicat Free PostgreSQL GUI (exe)
- Navicat PostgreSQL Manager is a PostgreSQL database management tool, which can convert XML, CSV, Microsoft Excel, Microsoft Access, and popular data formats to PostgreSQL databases, eliminating time-consuming data entry and the errors that accompany it. Other useful major features include Import and Export wizard, Unicode support, HTTP/SSH Tunnel, Batch Job...
- Software downloads 2008-08-05
- ASP.NET XMLMaker (exe)
- ASP.NET XMLMaker is an easy-to-use code generator for creating ASP.NET 2.0 pages that output XML from a Microsoft Access, SQL Server, Oracle, or any ODBC Data Source. You can instantly serves XML for Ajax, RSS, Flash or any other applications that consumes XML. ASP.NET XMLMaker is designed for high flexibility,...
- Software downloads 2008-07-30
- SmartVizor Variable Data Printing Software (zip)
- SmartVizor is a variable data printing application that runs on a Windows computer. It is one of the least expensive full-featured variable data printing solutions available today. You can use almost any database format with SmartVizorDbase (.dbf),Microsoft FoxPro (.dbf),Paradox (.db),Microsoft Excel (.xls),delimited ASCII (.csv, .txt). SmartVizor also provides ODBC. Version...
- Software downloads 2008-07-09
- AssetManage Enterprise (exe)
- Use AssetManage Enterprise to track where your assets are, their current status, and who they are currently assigned to. Scan and print asset tag labels from within the program. AssetManage keeps track of expenses related to an asset, creates inventories for multiple locations, and lets you attach images, documents and...
- Software downloads 2008-06-30
- SQL Query Tool (using ODBC) x64 Edition (msi)
- Query Tool using ODBC is a Universal Data Access UDA tool. It lets you query ODBC data sources, author SQL scripts and queries, return query results to a grid or free-form text, retrieve ODBC driver information, execute multiple SQL scripts or stored procedures simultaneously, and more. Not available on IA64-based...
- Software downloads 2008-06-23
- SQL Query Tool (using ADO) x64 Edition (msi)
- Query Tool using ADO is a Universal Data Access UDA tool. It lets you query OLE DB data sources, author SQL scripts and queries, return query results to a grid or free-form text, retrieve provider properties, execute multiple SQL scripts or stored procedures simultaneously, and more. Not available on IA64-based...
- Software downloads 2008-06-23
- Handy Backup (txt)
- Handy Backup Standard is a backup software certified with the Microsoft Works with Windows Vista logo. Performs automatic backup to DVD/CD, Blu-ray, HD DVD, FTP, USB, Flash, FireWire, LAN, and online. Supports ZIP64 compression, 128-bit encryption, has a flexible scheduler, can run as Windows service and notify via e-mail. Has...
- Software downloads 2008-06-19
- QIOS Pelican (msi)
- With QIOS Pelican you send all your customers, colleagues, friends, employees, club members or another group of people the same e-mail, but with personalized content. To send this personalized, bulk or mass e-mail QIOS Pelican uses two basic elements for its job: A Datasource and an E-mail. The datasource contains...
- Software downloads 2008-06-16
- Build your own Google
- In an earlier post I talked a bit about a start-up called Kickfire who are releasing an accelerated database appliance for MySQL applications in the 1TB-3TB range that gives comparable performance to an equivalent Oracle RDBMS setup for around a quarter of the price. Kickfire sounds compelling for utility...
- Blog posts 2008-06-05
- SSuite Office - MonoBase (zip)
- Features that are available in Monobase are these, create unlimited databases with unlimited tables, fields, and rows Paradox. Access any ODBC compatible database of any size, from 1 Kilobyte to 1 Terabyte. Filter tables instantly. Run SQL statements with the SQL query engine. Create custom reports for all your databases....
- Software downloads 2008-06-05
- DTM Schema Comparer (exe)
- DTM Schema Comparer is a visual database schemes comparison and synchronization tool that supports ODBC, OLEDB, IDAPI, and Oracle Call Interface connections. The visual representation of database schemes as a tree makes the comparison process more comfortable. The tool deals with tables, views, indexes, keys, triggers, and procedures. The built-in...
- Software downloads 2008-06-03
- ADO console (exe)
- ADO console is a simple program that allows to query various databases, that have OLE DB or ODBC providers. It was created to execute SQL queries against different databases and to exchange data between them. It was mainly used with these providers: Microsoft OLEDB provider for Visual FoxPro (allows connecting...
- Software downloads 2008-06-02
- FlySpeed DB Migrate To SQL Server (zip)
- Transfer databases from any engine to Microsoft SQL Server quickly and reliably. FlySpeed DB Migrate to SQL Server expedites the migration from your current engine into MS SQL. Migrate your entire database complete with structure and data, or transfer data from the source database into an existing structure. Get access...
- Software downloads 2008-06-02
- Handy Backup Server (txt)
- Handy Backup Server is all-included workstation backup solution for small and medium business enterprise networks. The utility supports files-based and image backup of both network workstations and the central server, has numerous backup options, a flexible scheduler and can run as Windows service under Windows 2000/XP/2003/Vista. In addition, Handy Backup...
- Software downloads 2008-05-30
- Physis Database Export Utility (exe)
- Physis Database Export Utility is to make your work with databases more efficient and even enjoyable. It converts unlimited databases, including (Firebird, Interbase, PostGre-Sql, Sybase, SqlLite, Mysql, Oracle, Microsoft Access, Microsoft SQL Server, Excel and text files or ODBC) tables to (TXT,XLS,DOC,HTML,DBF,SQL,XML,RTF,SAV,PDF,WQ1,SLK,XML,WK1,DIF). After you choose your server, the list of...
- Software downloads 2008-05-22
- How do I... Replace a complex connection string with a DSN?
- Technically speaking, a Data Source Name DSN is an identifier to a data source for an Open Data Base Connectivity ODBC driver library. ODBC is a function library that interfaces between the Application Programming Interface API and compliant database systems. Anybody who's interacted with foreign data programmatically knows that getting...
- Download resources 2008-05-20
Neighboring Terms
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
- Which solar technology will survive?
-
At the Cleantech Forum in San Francisco, Todd Glass of Heller Ehrman moderates a discussion, among tech execs, on the various solar technologies making a difference in the green movement.
- Watch the video >>
- Access the latest Intel and industry best practices
-
Designed specifically to address the concerns of senior IT managers at organizations with more than 100 employees, the Intel Premier IT Professional Program provides best practices via local and e-Seminars and a members-only Web site.
- View the Intel Premier IT Professional web-site tour >>
