MarkoSan
25th May 2010, 11:46
Hi to all!
I am trying to acces MySQL database via MySQL Odbc connector. I've setup following code:
DataBrowserBaseClass::DataBrowserBaseClass(QWidget *parent,
const QString& strTableNAme,
QSqlDatabase& sourceDb)
: QWidget(parent)
{
createMembers(); // create member objects
if(sourceDb.open())
{
// db opened ok
if(queryTablesList()->exec())
{
// query exec ok
while(queryTablesList()->next())
{
tablesList()->append(queryTablesList()->value(0).toString());
} // while
}
else
{
// query exec error, handle it
sourceDb.close(); // closes connection to database
} // if
}
else
{
// db open error handler
}
}and I get following error:
"QODBCResult::exec: No statement handle available" Error: " "What does this mean? What am I doing wrong?
Sincerely,
Marko
I am trying to acces MySQL database via MySQL Odbc connector. I've setup following code:
DataBrowserBaseClass::DataBrowserBaseClass(QWidget *parent,
const QString& strTableNAme,
QSqlDatabase& sourceDb)
: QWidget(parent)
{
createMembers(); // create member objects
if(sourceDb.open())
{
// db opened ok
if(queryTablesList()->exec())
{
// query exec ok
while(queryTablesList()->next())
{
tablesList()->append(queryTablesList()->value(0).toString());
} // while
}
else
{
// query exec error, handle it
sourceDb.close(); // closes connection to database
} // if
}
else
{
// db open error handler
}
}and I get following error:
"QODBCResult::exec: No statement handle available" Error: " "What does this mean? What am I doing wrong?
Sincerely,
Marko