Introduction to NeoDBpro
NeoDBpro uses ODBC and ADO technology to access a variety of database formats including Microsoft® Access™, MySQL™, SQLite™, Microsoft® SQL Server™, Oracle™, PostgreSQL™, Paradox, dBase and more.. In fact, when properly configured with the appropriate ODBC driver, NeoDBpro can be used to access just about any type of database system. Of course, database programming is a not trivial endeavor so don't expect to master it overnight.
What is a Database?
Before starting with NeoDBpro, it's probably a good idea to explain exactly what makes up a modern database. A database is a special type of file designed for storing information. An address book or a box containing recipes printed on index cards are examples of databases you've probably used many times. On a computer, database files are organized into tables which are organized into records. In turn each record contains a group of fields. If the address book were a computerized database, each person would be a unique record. Those records would each contain fields for the person's name, street, city, state, zip code and telephone number. Modern databases can be simple, like an address book, or they can be relational. A relational database is one that consists of multiple tables containing a collection of related data.
What are ODBC and ADO?
ODBC (Open Database Connectivity) is a standard database access method developed by the SQL Access Group. The goal of ODBC is to make it possible to access any data from any application, regardless of which database management system (DBMS) is handling the data. ODBC manages this by inserting a middle layer, called a database driver, between an application and the DBMS. The purpose of this layer is to translate the application's data queries into commands that the DBMS understands. For this to work, both the application and the DBMS must be ODBC-compliant - that is, the application must be capable of issuing ODBC commands and the DBMS must be capable of responding to them.
ADO (ActiveX Data Objects) is Microsoft's high-level interface for data objects. ADO is designed to access all sorts of different types of data, including databases, spreadsheets, and other types of documents. Together with ODBC, ADO is one of the main components of Microsoft's Universal Data Access (UDA) specification, which is designed to provide a consistent way of accessing data regardless of how the data are structured.