Open Database Connectivity with Liberty BASIC

    Access and VB (*.mdb) relational databases can be used with Liberty BASIC programs through the ODBC API and SQL (Structured Query Language). In fact, any OBDC compliant database can be used through the ODBC API.

    With ODBC and SQL you can

    • execute SQL statements
    • create databases
    • create and modify tables
    • create fields
    • assign keys and indexes
    • save records
    • retrieve recordsets

    ODBC can also be used to maintain and repair databases.

    The sample code demonstrates the basic methods for: creating, opening, and closing databases, creating tables and fields, deleting a table, adding and reading records, deleting records.

    DSN Sample code. Connect using a Data Source Name.
    DSNless Sample code. Connect directly to the ODBC driver, no DSN required.

    Additional information about ODBC may be obtained by searching the MSDN library at http://msdn.microsoft.com for "ODBC Programmer's Reference" and "microsoft access driver programming considerations"

    Learn SQL at www.w3schools.com A good place to start if you are new to SQL.