Database and ODBC
C++ class for ODBC (C++)
This is a set of related auxiliary classes, among them a string class and
a class implementing a double linked list - I avoided STL whenever possible at the time when I wrote this.
You may replace these auxiliary classes with the equivalent STL classes.
Includes a sample application called sql_odbc that accepts SQL statements
from a file or from the command line and executes them
File based cursors for large hit sets (C#)
HUCursorDemo: a sample
application written in C#. This sample program (GUI plus business logic)
demonstrates how large cursor sets can be handled in a program design that
is slightly more complex than the usual "vanilla" cursor handling samples. Features
parallel threads for visualisation and DB operation. Contains the complete
C# source code and a PDF article
(at the moment in German only) entitled "Handling large cursor sets in database
clients with C#" (in German: "Bewältigung großer Treffermengen in
Datenbankclients mit C#") explaining the basic architecture of this
approach that has successfully been used with several million hit records.
Screen dump for program HUCursorDemo
A simple ODBC/database GUI (wxWidgets, C++)
This is a simple user interface (see the screen dump below)
written in C++ based on the
wxWidgets framework using my own ODBC classes.
It offers a users friendly grid control to show the results of a SQL query. The
query results can be converted to PDF using some of my own PDF classes. The
ZIP file contains all necessary source code classes (GUI, PDF, ODBC etc.)
to build the executable, a Make file and also an executable.
wxWidgets and a C++ compiler (I use always Digital Mars C++) must be installed. This
is certainly not a replacement for huge tools like TOAD but it works fine for many
daily tasks. It should work with any ODBC data source and every database product that
has an ODBC driver.
Screen dump for program HUOdbc
Using the C Api for SQLite
Using the C-API to SQLite. This sample program in C/C++ demonstrates some
essential API calls to access SQLite databases. Illustrates how to connect to a database,
how to drop and create tables, how to insert records and how to retrieve them.
Runs under Linux and with little or no changes also under Windows.
If you want to contact me: this is my