i trying to connect mysql database and eclipse c++ and i set everything but when i want to compile a program using data base this error massage appears:

"fatal error:boost/shared_ptr.hpp: no such file or directory"

*****************************************************


how can i fix it, there is no solution on the internet, and i really really really tired of searching about this.

my compiler: gcc
my os: windows 8.1
**********************************
here you can see my code:

#include <stdlib.h>
#include <iostream>
#include "mysql_connection.h"
#include <cppconn/driver.h>
#include <cppconn/exception.h>
#include <cppconn/resultset.h>
#include <cppconn/statement.h>
#include <cppconn/prepared_statement.h>
using namespace std;

int main(void)
{
cout << endl;
cout << "Let's have MySQL count from 10 to 1..." << endl;

try {
sql::Driver *driver;
sql::Connection *con;
sql::Statement *stmt;
sql::ResultSet *res;
sql::PreparedStatement *pstmt;

/* Create a connection */
driver = get_driver_instance();
con = driver->connect("tcp://127.0.0.1:3306", "root", "37975");
/* Connect to the MySQL test database */
con->setSchema("test");

stmt = con->createStatement();
stmt->execute("DROP TABLE IF EXISTS test");
stmt->execute("CREATE TABLE test(id INT)");
delete stmt;

/* '?' is the supported placeholder syntax */
pstmt = con->prepareStatement("INSERT INTO test(id) VALUES (?)");
for (int i = 1; i <= 10; i++) {
pstmt->setInt(1, i);
pstmt->executeUpdate();
}
delete pstmt;

/* Select in ascending order */
pstmt = con->prepareStatement("SELECT id FROM test ORDER BY id ASC");
res = pstmt->executeQuery();

/* Fetch in reverse = descending order! */
res->afterLast();
while (res->previous())
cout << "\t... MySQL counts: " << res->getInt("id") << endl;
delete res;

delete pstmt;
delete con;

} catch (sql::SQLException &e) {
cout << "# ERR: SQLException in " << __FILE__;
cout << "(" << __FUNCTION__ << ") on line "
<< __LINE__ << endl;
cout << "# ERR: " << e.what();
cout << " (MySQL error code: " << e.getErrorCode();
cout << ", SQLState: " << e.getSQLState() <<
" )" << endl;
}

cout << endl;

return EXIT_SUCCESS;
}

i don't know how i can add boost lib to my eclipse.
i trying to fix this problem but i cant. i'm very depressed by it.
but please help me, how can i add boost library to my eclipse on windows platform.
sincerely yours, Daniel

i add boost to lib but it didn't work properly yet.
i tried to set eclipse and sqlite database too but it didn't work too and gave's error like mysql
the error was:" fatal error......"
i don't know why but it seems that eclipse don't support databases. why?

i installed mysql server and c and c++ api and add it to my library in eclipse but i still see this error "fatal error:boost/shared_ptr.hpp: no such file or directory"
i don't know what is it, i installed boost library, i installed everything for making a database and i don't give a result.
if you can or it's easy to you please check and write something useful to connect mysql on eclipse(c++).
cause there is no page on the internet about it

my mySQL path is: "D:\Programs\Programming\MySQL\MySQL Server 5.5"
and my mysql-connector c++ path that i download it from mysql's website is: "D:\Programs\Programming\MySQL\Connector C++"
and my-boost library that i don't know what is it is: "D:\Programs\Programming\boost_1_57_0"

i go to the eclipse and select the Project>>properties>>c/c++ build>>GCC C++ Comiler>>Includes and add below Item to Include path:
- "D:\Programs\Programming\MySQL\Connector C++\include"
- "D:\Programs\Programming\MySQL\MySQL Server 5.5\include"
- "D:\Programs\Programming\boost_1_57_0\boost"

and then i go to the Project>>properties>>c/c++ build>>MINGW C++ Linker>> Libraries and add below items to library search path:
- "D:\Programs\Programming\MySQL\MySQL Server 5.5\lib"
- "D:\Programs\Programming\MySQL\Connector C++\lib"

now when i want to compile this program(from mysql example )


#include <stdlib.h>
#include <iostream>
#include "mysql_connection.h"
#include <cppconn/driver.h>
#include <cppconn/exception.h>
#include <cppconn/resultset.h>
#include <cppconn/statement.h>
#include <cppconn/prepared_statement.h>

using namespace std;

int main(void)
{
cout << endl;
cout << "Let's have MySQL count from 10 to 1..." << endl;

try {
sql::Driver *driver;
sql::Connection *con;
sql::Statement *stmt;
sql::ResultSet *res;
sql::PreparedStatement *pstmt;

/* Create a connection */
driver = get_driver_instance();
con = driver->connect("tcp://127.0.0.1:3306", "root", "37975");
/* Connect to the MySQL test database */
con->setSchema("test");

stmt = con->createStatement();
stmt->execute("DROP TABLE IF EXISTS test");
stmt->execute("CREATE TABLE test(id INT)");
delete stmt;

/* '?' is the supported placeholder syntax */
pstmt = con->prepareStatement("INSERT INTO test(id) VALUES (?)");
for (int i = 1; i <= 10; i++) {
pstmt->setInt(1, i);
pstmt->executeUpdate();
}
delete pstmt;

/* Select in ascending order */
pstmt = con->prepareStatement("SELECT id FROM test ORDER BY id ASC");
res = pstmt->executeQuery();

/* Fetch in reverse = descending order! */
res->afterLast();
while (res->previous())
cout << "\t... MySQL counts: " << res->getInt("id") << endl;
delete res;

delete pstmt;
delete con;

} catch (sql::SQLException &e) {
cout << "# ERR: SQLException in " << __FILE__;
cout << "(" << __FUNCTION__ << ") on line "
<< __LINE__ << endl;
cout << "# ERR: " << e.what();
cout << " (MySQL error code: " << e.getErrorCode();
cout << ", SQLState: " << e.getSQLState() <<
" )" << endl;
}

cout << endl;

return EXIT_SUCCESS;
}


i see it is dont compile and i see these errors:
- Description Resource Path Location Type
fatal error: boost/shared_ptr.hpp: No such file or directory Working line 31, external location: D:\Programs\Programming\MySQL\Connector C++\include\mysql_connection.h C/C++ Problem



i don't know why i cant connect mysql to eclipse. i tried to connect it more and more (at least 1 month)
Please Help me!!!!

On 08/07/2015 03:12 AM, Danial Atash wrote:
> i see it is dont compile and i see these errors:
> - Description Resource Path Location Type
> fatal error: boost/shared_ptr.hpp: No such file or directory
> Working line 31, external location:
> D:\Programs\Programming\MySQL\Connector
> C++\include\mysql_connection.h C/C++ Problem
>

The compiler is looking for the boost/shared_ptr.hpp file in an Include
path subdirectory named boost. One of the include directories you added
ends with boost. Make sure that you aren't adding the wrong directory
to the path. If the shared_ptr.hpp file is in
"D:\Programs\Programming\boost_1_57_0\boost" that you added, then you
need to back this path entry up a level as
"D:\Programs\Programming\boost_1_57_0". The compiler with then look in
the boost subdirectory and find the header file.