Howto use MySQL with MSVC++ 6.0 on Windows

[Herbert Janko]

Hi!

I'm new to MySQL and I have a question about using MySQL 4.0.x with MSVC++ 6.0!

I'm searching for a howto guide which explains the right use of MySQL. I'm 
writing a C++ programm for a small database to log some things.
I want to know:
  - which header/lib (mysql.h, sqlplus.hh, libmysqld,...) is the best one for 
use with MSVC++ and Windows
  - which C/C++ API (C, Connector++,ODBC) is the best one for using with MSVC++
  - do I need other programms than MySQL 4.0.14, MyODBC 3.51.06, MySQL++ 1.7.1

I've found many things on the Internet and many things are delivered with MySQL, 
but mainly for Linux I think. Due to many possible way to connect via C++ to 
MySQL I ask for the best way to do it under Windows.

Perhaps someone can supply an example of one connection (like this one 
http://www.sqlite.org/quickstart.html)

thx,
Herbert
from Austria