Database Connection

[ddwinters45]

Hello, I need a good source to figure out how to set up a database that I can connect to a C++ program. I know how to code a database in SQL I just need help setting up the local database or SQL server, or whatever would be the best choice. I am new to programming with databases and don't know where to start reading to learn. I know this is out of C++ coding, but is it possible to set up a SQL server database as a local one or would I be better off setting one up in Microsoft Access and connecting to it? The program will only be run on one local machine so a server instance may be a bit overkill, but once again I am new to this side of programming and don't know where to start. I also need to figure out how to connect to the database in C++ and then interact with it. Any ideas of some good sources to look into? I would greatly appreciate it.

[Galik]

I have often used MySQL: http://www.mysql.com/

There are tonnes of programming examples on the web demonstrating how to connect and query using the MySQL C API. For example: http://zetcode.com/tutorials/mysqlcapitutorial/

There are also various C++ wrapper libraries available.

[ddwinters45]

Thank you I will look into that. I just didn't know what to look at or where to begin. Thank you very much.