Connect to SQL server
Hello,
I am working on a program that parses a webpage to get its input data. The page some contains information from an SQL database. Unfortunately the webpage was actually made with another goal in mind and as a result is not optimal for my application. Because the data in the database is more complete and better structured I would like to change my program to connect directly to the database.
I think I basically need three steps:
- connect to the database (over the network)
- execute a select query (I have no reason to modify or delete data in the database)
- process the result
While I am convinced this should be possible in C++11, I don't have any idea about how to do this.
I currently use the cUrl library to retrieve the webpage and SQLite for local storage, I hope it can also be helpful for the connection with the database.
Could you please help me get started with this challenge?
Thanks in advance, Nico
I am working on a program that parses a webpage to get its input data. The page some contains information from an SQL database. Unfortunately the webpage was actually made with another goal in mind and as a result is not optimal for my application. Because the data in the database is more complete and better structured I would like to change my program to connect directly to the database.
I think I basically need three steps:
- connect to the database (over the network)
- execute a select query (I have no reason to modify or delete data in the database)
- process the result
While I am convinced this should be possible in C++11, I don't have any idea about how to do this.
I currently use the cUrl library to retrieve the webpage and SQLite for local storage, I hope it can also be helpful for the connection with the database.
Could you please help me get started with this challenge?
Thanks in advance, Nico
Last edited on
Topic archived. No new replies allowed.