C++ and MySQL through ODBC

Hello everyone,

I'm building a system for my school to make administration easier on  
the staff there and I need to get a C++ command line program to run  
ODBC and connect to an MySQL database, retrieve data and and submit  
data (updates alters and inserts).

I have the ODBC driver for MySQL implemented and I have it connecting  
to my SQL host but only using the test function of the ODBC admin.

What I need is an example program, something with a lot of comments  
and explanations in it, that can access a MySQL database (connect) run  
SQL insert and select commands (returning to strings) and be just in a  
simple interface. (preferably in Visual (studio or C) format and in  
one big file)

I have spent upwards of 20 (unsuccessful) hours trying to get it to  
work by myself before coming for help so I'm sure others are having  
the same issues. I hope that you will take the time to solve this.  
I've probably tried to follow the tutorials and wrappers that you can  
point me to. I'm probably just dumb for not understanding, but I want  
to understand a learn how to do this.

  I thought I had a baseline knowledge of programming in c++ until I  
had to take this on.

    Thank you so, so much.

      -Alex

Running:
Windows XP SP2
Visual Studio 2005
ODBC with host on local network EX: (192.168.1.5)
newest Visual C express as of 2008

Oh, and if you need more info, please let me know!

-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/[email protected]