Hey I'm currently developing an application (for windows XP) which will need to store data in a SQL database - I could just write it to files but much more work would be required. I'm hoping to sell this application on-line when I'm finished and I'm wondering if anyone could offer some advice on stuff like:
Which C++ SQL library would you use?
Which DBMS would you use? I'd like to make the installation as simple as possible.
I've used MySQL a lot - my host provides it. But I was wondering if that would be the best way to go? During installation of my application they would also need to install MySQL... sounds hardish. What about ODBC?
Anyway, any information/links would be awesome. Thanks!
My favorite database access technology is ODBC direct. The drivers are installed with every installation of Windows, so there simply is nothing more needed. I've a tutorial on accessing Microsoft Access, SQL Server, and Microsoft Excel here using C++ and Win Api...