connecting to MySQL through it's API

[Philip_Anselmo]

I'm now trying to connect to my app to MySQL using mysql.h from MySQL 4.1.... as I just can't make the damn plugin... somewhere theres a post explaining the plugin stuff..

The thing now is that after I made the connection I retrieve the table list as this:

.......
#include <mysql.h>
....
..
MYSQL_RES *res;
...
..
 
QStringList tablas()
{
    if (!res=mysql_list_tables( &mysql, NULL ))
    {
	QMessageBox::warning(0,"No se pudo obtener la lista de tablas", mysql_error( &mysql ));   
    }
    QStringList listaTablas = res->toStringList; 
    //convert MYSQL_RES to QSTRINGLIST ???
 for ( QStringList::Iterator it = listaTablas.begin(); it != listaTablas.end(); ++it ) {
 qWarning(*it + "\n");
 } 
    //muestra en consola la lista de tablas de la base de datos a la que se conecto
 
    return listaTablas;
}

.......
#include <mysql.h>
....
..
MYSQL_RES *res;
...
..

QStringList tablas()
{
    if (!res=mysql_list_tables( &mysql, NULL ))
    {
	QMessageBox::warning(0,"No se pudo obtener la lista de tablas", mysql_error( &mysql ));   
    }
    QStringList listaTablas = res->toStringList; 
    //convert MYSQL_RES to QSTRINGLIST ???
 for ( QStringList::Iterator it = listaTablas.begin(); it != listaTablas.end(); ++it ) {
 qWarning(*it + "\n");
 } 
    //muestra en consola la lista de tablas de la base de datos a la que se conecto
  
    return listaTablas;
}

To copy to clipboard, switch view to plain text mode 

so the question is..... tararraaarrataaan.
how do i get res to fill a QStringList?

I've tryed casting:

QStringList listaTablas = (QStringList)res;

QStringList listaTablas = (QStringList)res;

To copy to clipboard, switch view to plain text mode 

Dumbass way:

QStringList listaTablas = res;

QStringList listaTablas = res;

To copy to clipboard, switch view to plain text mode 

and DumbAss2 xD as there is no member... etc
error: 'struct st_mysql_res' has no member named 'toStringList

QStringList listaTablas = res->toStringList;

QStringList listaTablas = res->toStringList;

To copy to clipboard, switch view to plain text mode 

Any ideas?
the final idea is to fill a qcombobox with the QStringList with the table list

CB_Tablas->insertStringList(tablas());

CB_Tablas->insertStringList(tablas());

To copy to clipboard, switch view to plain text mode 

as you can see the function named tablas returns a QStringList that contains or should contain the table list from the database

please don't tellme to use qdatabase.h as that's now not an option

[wysota]

You have to process the result row by row and extract the data yourself... You can take a look at QMYSQL plugin to see how it does it. Oh, and don't give up compiling that plugin To be honest I have never had problems with that... Maybe you should try one more time? You can take a look ath the FAQ, maybe it'll help you.

[Philip_Anselmo]

jajja I finally made de damn plugin but I'm still geting ths Driver not Loaded shh..
I'm now running:

configure -plugin-sql-mysql -I d:\mysql\include -L d:\mysql\lib\opt

configure -plugin-sql-mysql -I d:\mysql\include -L d:\mysql\lib\opt

To copy to clipboard, switch view to plain text mode 

if that doesn't work... I finnished with the damn plugin...

And I'm looking to the code on the main.cpp from the mysql plugin and nothing so I'm looking on the qsql_mysql.cpp and well no ideas yet

... jejejej wait a second I think I got the idea xD... :$ as you can tell i'm working on real time XD

I realy hope the plugin work.... I would like to keep it qt and not doing a mixed ..... thing..

[jacek]

Do you use Qt3 or Qt4?

[Philip_Anselmo]

on this case. I'm working on Qt 4.1.2 as I need to make the plugin for an app which needs to run on windows... so everything I made on linux and works with the Qt 3.1.2 on linux has to run on wnidows compiled and ported to Qt 4.1.2 the ap and the porting works perfectly.. I just have to modify de conection... change the pointer for a variable.. changing the '->' for '.' etc.. and I have to add the #include <qsqlerror.h> but it works without problems excepet for the "Driver not Loaded"...

[jacek]

it works without problems excepet for the "Driver not Loaded"...

Check with Dependency Walker if your application and the plugin can find all DLLs they need. If there is a missing DLL, find it and place in the same directory as the executable.

[Philip_Anselmo]

I ran DependencyWalker on my app's exe and it tells me that couldn't find MSJAVA.DLL

java?
I don't remember have used java so... ?

but well..
on the other side.. I'm now worried about how to populate a qdatatable using the MySQL API ... mysql.h etc etc
I made a conection and populated a qcombobox with the tables from the database..
so now I'm trying to populate a qdatatable with the qsqlcursor... but I guess I'm not able to use it as the connection is made through the MySQL API not by qt.

[jacek]

I ran DependencyWalker on my app's exe and it tells me that couldn't find MSJAVA.DLL

You can safely ignore msjava.dll. Are there any other missing DLLs (especially for the plugin)?

[Philip_Anselmo]

it tells me that the libmysql.dll is missing so I putted it on the same folder as the exe and the qsqlmysql.dll and there's still Driver not Loaded message

and the other way using a MySQL API connection works on linux but on windows at compilling time... it just tells me errors on mysql_com.h and that a SOCKET is created without a type

¬¬ Qt hates me...

[jacek]

it tells me that the libmysql.dll is missing so I putted it on the same folder as the exe and the qsqlmysql.dll and there's still Driver not Loaded message

Do I understand you correctly that you have placed the plugin and the executable in the same directory?

[wysota]

qsqlmysql.dll should be in "sqldrivers/" subdirectory.