Open Database Connectivity (ODBC) is Microsoft's strategic interface for accessing data in a heterogeneous environment of relational and non- relational database management systems. Based on the Call Level Interface specification of the SQL Access Group, ODBC provides an open, vendor- neutral way of accessing data stored in a variety of proprietary personal computer, minicomputer, and mainframe databases.
ODBC alleviates the need for independent software vendors and corporate developers to learn multiple application programming interfaces. ODBC now provides a universal data access interface. With ODBC, application developers can allow an application to concurrently access, view, and modify data from multiple, diverse databases.
ODBC is a core component of Microsoft Windows Open Services Architecture. Apple has endorsed ODBC as a key enabling technology by announcing support into System 7 in the future. With growing industry support, ODBC is quickly emerging as an important industry standard for data access for both Windows and Macintosh applications.
ODBC is a specification to which developers write either:
• An ODBC-enabled "front-end" or "client" desktop application, also known as an "ODBC Client." This is the application that the computer-user sees on the computer screen.
• An ODBC Driver for a "back-end" or "server" DBMS (Database Management System). This is the DBMS application that resides on a computer that is used to store data for access by several users. This application is not what is loaded on the end user's computer. This server application is usually more robust (faster, with centralized security, and backups of data, and so forth) than the client application. The ODBC Driver resides between the ODBC Client and the DBMS; however, it is loaded on the front-end computer.
image
Recordset Example Screenshots
Recordset have completed many projects covering a wide variety of industries. Here is a small sample showing screenshots and a brief description of how it works.
image
Recordset Solutions Has Moved
Recordset Solutions Ltd has moved from Wakefield and is now based in Leeds.
The new location is in Leeds City Centre and is easily naviagted to by the M1.
- Networked Systems
- MS Access & SQL Server
- MS Office Intergration
- Project Management Systems
- Stock Control Database
- Client Management Systems
- Asset Management Systems
- Convert Excel Sheets
- User Login With Permissions
- Customers & Suppliers
