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++)

HuOdbc GUI 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.

Contact

If you want to contact me: this is my
mail address