User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the C++ section within the Software Development category of DaniWeb, a massive community of 397,626 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,371 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our C++ advertiser:
Views: 232 | Replies: 4 | Solved
Reply
Join Date: Mar 2008
Posts: 52
Reputation: Maulth is an unknown quantity at this point 
Rep Power: 1
Solved Threads: 5
Maulth Maulth is offline Offline
Junior Poster in Training

Export SQL Query

  #1  
May 14th, 2008
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.
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Aug 2005
Location: near St Louis, Missouri, USA
Posts: 10,641
Reputation: Ancient Dragon has much to be proud of Ancient Dragon has much to be proud of Ancient Dragon has much to be proud of Ancient Dragon has much to be proud of Ancient Dragon has much to be proud of Ancient Dragon has much to be proud of Ancient Dragon has much to be proud of Ancient Dragon has much to be proud of Ancient Dragon has much to be proud of 
Rep Power: 36
Solved Threads: 867
Moderator
Featured Poster
Ancient Dragon's Avatar
Ancient Dragon Ancient Dragon is offline Offline
Most Valuable Poster

Re: Export SQL Query

  #2  
May 14th, 2008
I'm confused -- you want to write a c++ SQL class but you don't know the SQL language yourself ??
I think it's about time we voted for senators with breasts. After all, we've been voting for boobs long enough. ~Clarie Sargent, Arizona senatorial candidate
Those who are too smart to engage in politics are punished by being governed by those who are dumber. ~Plato
Reply With Quote  
Join Date: Mar 2008
Posts: 52
Reputation: Maulth is an unknown quantity at this point 
Rep Power: 1
Solved Threads: 5
Maulth Maulth is offline Offline
Junior Poster in Training

Re: Export SQL Query

  #3  
May 14th, 2008
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 6:15 pm.
Reply With Quote  
Join Date: Aug 2005
Location: near St Louis, Missouri, USA
Posts: 10,641
Reputation: Ancient Dragon has much to be proud of Ancient Dragon has much to be proud of Ancient Dragon has much to be proud of Ancient Dragon has much to be proud of Ancient Dragon has much to be proud of Ancient Dragon has much to be proud of Ancient Dragon has much to be proud of Ancient Dragon has much to be proud of Ancient Dragon has much to be proud of 
Rep Power: 36
Solved Threads: 867
Moderator
Featured Poster
Ancient Dragon's Avatar
Ancient Dragon Ancient Dragon is offline Offline
Most Valuable Poster

Re: Export SQL Query

  #4  
May 14th, 2008
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++.
I think it's about time we voted for senators with breasts. After all, we've been voting for boobs long enough. ~Clarie Sargent, Arizona senatorial candidate
Those who are too smart to engage in politics are punished by being governed by those who are dumber. ~Plato
Reply With Quote  
Join Date: Mar 2008
Posts: 52
Reputation: Maulth is an unknown quantity at this point 
Rep Power: 1
Solved Threads: 5
Maulth Maulth is offline Offline
Junior Poster in Training

Re: Export SQL Query

  #5  
May 14th, 2008
Thank you Ancient.
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

DaniWeb C++ Marketplace
Thread Tools Display Modes

Similar Threads
Other Threads in the C++ Forum

All times are GMT -4. The time now is 9:08 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC