943,564 Members | Top Members by Rank

Ad:
  • C++ Discussion Thread
  • Marked Solved
  • Views: 1651
  • C++ RSS
May 14th, 2008
0

Export SQL Query

Expand Post »
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.
Similar Threads
Reputation Points: 15
Solved Threads: 6
Junior Poster in Training
Maulth is offline Offline
65 posts
since Mar 2008
May 14th, 2008
0

Re: Export SQL Query

I'm confused -- you want to write a c++ SQL class but you don't know the SQL language yourself ??
Sponsor
Team Colleague
Featured Poster
Reputation Points: 5608
Solved Threads: 2282
Retired and Enjoying Life
Ancient Dragon is offline Offline
21,947 posts
since Aug 2005
May 14th, 2008
0

Re: Export SQL Query

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?
Last edited by Maulth; May 14th, 2008 at 7:15 pm.
Reputation Points: 15
Solved Threads: 6
Junior Poster in Training
Maulth is offline Offline
65 posts
since Mar 2008
May 14th, 2008
0

Re: Export SQL Query

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++.
Sponsor
Team Colleague
Featured Poster
Reputation Points: 5608
Solved Threads: 2282
Retired and Enjoying Life
Ancient Dragon is offline Offline
21,947 posts
since Aug 2005
May 14th, 2008
0

Re: Export SQL Query

Thank you Ancient.
Reputation Points: 15
Solved Threads: 6
Junior Poster in Training
Maulth is offline Offline
65 posts
since Mar 2008

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in C++ Forum Timeline: Issue with array assignment
Next Thread in C++ Forum Timeline: Text file traverse problem





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC