Need help with Manipulating an MSSQL/Sybase database in C/C++
Ok I've searched through the FAQ, even though I thought this might be beyond the scope of that, I've done a Search, and could not find what I am looking for, so I am posting it here.
Here is my project:
Take information from 3 different Excel CSV files, and either update, insert or delete based on comparisons between the files and the database.
Basically a one way Sync between the CSV files and the Database.
The app will need to be used on both Sybase and MSSQL, so my best guess (considering I've never even thought about having a thought about changing a database via C/C++) would be that I have to use ODBC to interact with the databases.
I am also developing this as a Win32 Console application because the whole idea of event driven programing escapes me. I just can't grasp the concept.
Ok now to my questions:
1. How do I connect to either Database through ODBC? Are there any funcions included in my .libs or do I need to write my own functions and can you offer some help or direction here?
2. Any help with the functions needed to Insert, Update, Select, or Delete record from the database, would be VERY much appreciated.