odbc connection via C program in windows

install gcc compiler
install MyODBC-3.51.11-2-win

paste sql.h, sqlext.h, sqltypes.h in the include folder
paste libodbccp32.a, libodbc32.a in lib folder

configure windows settings as per:: configuration link

compiler your c program with:
gcc testprogram.c -lodbc32

and u r done
cheers!!

jdbc + MySql

one good link for installation of mysql server, mysql-connector/java, some configuration details and simple java program illustrating use of jdbc ::

http://www.developer.com/java/data/article.php/3417381

bye