I've posted something along these lines before, but it's a tad bit different this time, hopefully some of you can point me in the right direction.
I'm designing a tool that will make adding things to a database easy for people not familiar with SQL, it will basically export a query to the SQL server, and I don't really know how to do that. It will require authentication for the SQL (MySQL 5.0). Any help you can give me would very much be appreciated.
Maulth 4 Junior Poster in Training
Ancient Dragon 5,243 Achieved Level 70 Team Colleague Featured Poster
I'm confused -- you want to write a c++ SQL class but you don't know the SQL language yourself ??:icon_eek:
Maulth commented: Thank you for helping me with my ODBC problem :D +1
Maulth 4 Junior Poster in Training
No, I'm sorry I just re-read that first post, I was tired when I made it, let me revise.
I'm writing a tool that will be used to create an SQL file. I know the table structure for the SQL, I just want to know how I get it to the MySQL server, actually have the program export it to the server. Sorry for my fragmented post earlier.
I saw something in an earlier post, called ODBC or something like that, would that be beneficial?
Ancient Dragon 5,243 Achieved Level 70 Team Colleague Featured Poster
yes, ODBC is one way, and is supported by most, if not all, modern SQL compliant data bases. There are already several free odbc c++ classes. So what you are trying to do has already been done several times in the past 10 or so years.
For MySql specifically, you can download free MySQL++.
Maulth 4 Junior Poster in Training
Thank you Ancient.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.