(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-2009 The Computer Language Company Inc. All rights reserved. |
Additional Resources
- SQLWriter 2.3.0 (Windows)
- SQLWriter is a powerful SQL script editor for all database developers and database administrators. It can edit different database SQL scripts in the same window and support Windows 98, Windows NT 4.0, Windows 2000, Windows ME, Windows XP and Window2003. In addition, it also edits or runs SQL queries and...
- Software downloads 2009-11-23
- Navicat for MySQL 8.1.6 (Mac)
- Navicat is an ideal solution for MySQL administration and development. This is an all-inclusive mysql front end provides a powerful graphical interface for databases management, development and maintenance. Easy installation and intuitive interface make it an irreplaceable tool for mysql on the web or your local desktop. Navicat supports all...
- Software downloads 2009-11-22
- Navicat (Oracle GUI) 8.2.17 (Windows)
- 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 2009-11-22
- Navicat (MySQL GUI) 8.2.17 (Windows)
- Navicat MySQL GUI is a MySQL 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, HTTP/SSH Tunnel, Batch Job...
- Software downloads 2009-11-22
- FmPro Migrator 5.31 (Mac)
- FmPro Migrator quickly and accurately migrates FileMaker Pro database structure and data to MySQL, Oracle, Access, SQL Server, Sybase, DB2, OpenBase, PostgreSQL, FrontBase, SQLite and Valentina. Converts Microsoft Access Tables/Fields, Forms/Reports, Relationships, Queries and Visual Basic code to FileMaker. Converts FileMaker Pro databases to Microsoft Access (Forms/SubForms/Reports and Visual Basic)...
- Software downloads 2009-11-22
- Internet Server Monitor 10.0.15 (Windows)
- Internet Server Monitor is a network monitoring tool enabling Systems Administrators to monitor network servers, services, and applications for failures as well as recoveries enabling issue identification and resolution before users report them. Internet Server Monitor handshakes with network resources and calls specific functions enabling Internet Server Monitor to determine...
- Software downloads 2009-11-19
- Xlight FTP Server 3.5 (Windows)
- Xlight FTP Server is an easy to use high performance FTP server with very low memory and CPU usage. It has many features and advanced features such as remote administration, SSL, SFTP,ODBC, LDAP, Active Directory, e-mail notification, and IPv6 support.
- Software downloads 2009-11-18
- RazorSQL 5.0.1 (Windows)
- Query, edit, browse, and manage all major databases from one database tool. RazorSQL is a database query tool, SQL editor, database browser, and administration tool with built-in connection capabilities for DB2, Derby, Firebird, FrontBase, HSQLDB, Informix, Microsoft SQL Server, MySQL, OpenBase, Oracle, PostgreSQL, SQL Anywhere, SQLite, and Sybase. Any other...
- Software downloads 2009-11-16
- Universal SQL Editor 1.2 (Windows)
- Universal SQL Editor is a graphical query tool for all database developers. It allows you connect any ODBC compliant databases, such as Oracle, DB2, SQL Server, Sybase, and edit SQL queries and scripts with code completion, syntax highlighting, SQL formatting, plus other useful features that allow you to work more...
- Software downloads 2009-11-16
- Advanced ETL Processor 2.4.2.9 (Windows)
- Advanced ETL Processor extracts data from any database, transforms, validates it and loads into another database automatically. A unique technology called "What You See Is What You Load" saves a lot of time during testing and design of validation and transformation processes. It shows you how the data will be...
- Software downloads 2009-11-13
- SQL Image Viewer 2.5.0.140 (Windows)
- SQL Image Viewer enables you to retrieve, view, convert, and export images stored in Firebird, MySQL, Oracle, SQLite, SQL Server and ODBC data sources, and supports the following image formats: BMP, GIF, JPG, PNG, PSD, and TIFF. It also recognises the following binary file types: PDF, MP3, WAV, 7Z, BZ2,...
- Software downloads 2009-11-13
- ESF Database Migration Toolkit Professional Edition 6.2.03 (Windows)
- ESF Database Migration Toolkit lets you transfer data across various database/file systems. With this toolkit, you can reduce the effort, cost, and risk of migrating to/from any of the following database/file systems: Oracle, MySQL, SQL Server, PostgreSQL, IBM DB2, Visual Foxpro, SQLite, FireBird, InterBase, Microsoft Access, Microsoft Excel, Paradox, Lotus,...
- Software downloads 2009-11-13
- GlobalSCAPE EFT Server 6.1.0.48 (Windows)
- EFT Server formerly Secure FTP Server is a secure file transfer solution for growing companies facing the challenges that come with an increasing network of business partners and processes. The core EFT Server platform provides secure transport protocols, extensive user account control, and post processing workflow. Utilize all the essential...
- Software downloads 2009-11-12
- SmartVizor 12.0.1.111 (Windows)
- SmartVizor is a stand alone, powerful and extremely easy to use 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.Using a separate application to create boilerplate documents is not a requirement, however. If you like, you can use SmartVizor...
- Software downloads 2009-11-11
- FlySpeed Data Export 4.4 (Windows)
- FlySpeed Data Export is the must-have tool to export data from your database quickly and easily. The ability to connect to almost any data source using OLE DB or ODBC, and exporting to the most-popular office formats makes FlySpeed Data Export a really universal data export tool. FlySpeed Data Export...
- Software downloads 2009-11-11
- DTM Schema Reporter 1.17.17 (Windows)
- DTM Schema Reporter is a reporting tool for database schema. The program creates reports in RTF, HTML or plain text formats and supports all common database interfaces - ODBC, IDAPI, or even Oracle Call Interface. This utility helps technical writers and database administrators create a report of any complexity level...
- Software downloads 2009-11-10
- IPHost Network Monitor 2.1 Build 3492 (Windows)
- IPHost Network Monitor is a reliable network and server monitoring tool. With this software you can keep track of your mail servers, internet hosts, database servers, and other network resources availability and performance. You can monitor any performance counter on remote Windows servers and workstations via WMI. Supported protocols are:...
- Software downloads 2009-11-07
- OpenLink Lite Edition ODBC Driver for SQL Server (TDS) 6.02.3280 (Mac)
- High-Performance ODBC Drivers provide transparent access to remote databases from any ODBC-compliant application. Desktop Productivity Tools (i.e., Spreadsheets, Word Processors, Presentation Packages, Desktop Databases, Personal Organizers, etc.), Client-Server Application Development Environments, Web-based Database Publishing Tools, and Computer Telephony Integration packages, are just a few of the many products that can...
- Software downloads 2009-11-05
- ODBCHTTP Home Edition 1.0.1 (Windows)
- ODBCHTTP is the first odbc driver that connects to databases over the Internet using standard HTTP or HTTPS protocols and that doesn't require specialized software to be installed on the webserver. Currently MySQL and Oracle are supported. DB2 and SQLServer are under development as well as the Linux port of...
- Software downloads 2009-11-02
- rTools Reporting Software for Sage Accpac ERP 4.1 (Windows)
- rTools is a Microsoft Excel based reporting software for Sage ACCPAC ERP like none other. rTools reports on Accpac Modules: General Ledger, Accounts Payable and Receivable, Inventory Control, Purchase Order, Order Entry and Project & Job Costing. All reports are completely auto-generated using powerful, automatic layout and formatting. As you...
- Software downloads 2009-11-02
Neighboring Terms
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
- New Online Dashboard for IT Leaders
-
Read about top issues IT decision-makers face every day, plus get cost-effective solutions to real-life IT problems.
- Learn more >>
- The best support in the Linux business
-
If Linux is going to power your mission-critical applications, you'd better have the best support known to business. Novell was rated the top provider of Linux technical support.
- Learn more >>
- The best support in the Linux business
-
If Linux is going to power your mission-critical applications, you'd better have the best support known to business. Novell was rated the top provider of Linux technical support.
- Learn more >>
- The more you simplify, the more you save
-
When you transition from your existing Red Hat environment to SUSE Linux Enterprise from Novell, you can recognize dramatic cost savings, perhaps as much 50%
- Learn more >>
Meet Doc
-
-
Here to help you with your Document Management Needs
- Doc is an enigma. Born to a Russian ballerina and a German electrical engineer, he grew up in various locations in the United States. He’s seen the insides of more brands, versions, and generations of printer and printer-related hardware than almost anyone.
- To learn more about this mysterious figure check out his blog on ZDNet and his Workspace on TechRepublic. You’ll be glad you did.
-
Produced by
ZDNet and -
