SOCI Undefined Reference Error During Compilation
// relevant imports
using namespace soci;
using namespace std;
int main(int argc, char** argv) {
    string dbName = "mysql";
    string options = "dbname=db user=root password=abc";
    try {
        session sql(dbName, options); // this is line 22
    } catch (exception e) {
        printf("%s", e.what());
    }
    printf("working");
    return 0;
}

build/Debug/GNU-Linux-x86/main.o: In function `main':
/home/kevin/Dropbox/bamboo/main.cpp:22: undefined reference to
`soci::session::session(std::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, std::basic_string<char, std::char_traits<char>, std::allocator<char> > const&)'
/home/kevin/Dropbox/bamboo/main.cpp:22: undefined reference to `soci::session::~session()'

-L/usr/local/lib -lsoci_core -lsoci_mysql