PDA

View Full Version : KDevelop + ODBC + Qt



cleber
30th May 2008, 14:58
Hello.

Me help please, I am trying connect to the database access (.mdb), more giving this error.

QSqlDatabase: QODBC driver not loaded
QSqlDatabase: available drivers: QMYSQL3 QODBC3

I am a newcomer.

Thanks.
Cleber Ramos

triperzonak
30th May 2008, 15:10
include your code please.. maybe their a problem in your QODBC plugins or your code it self..;)

cleber
30th May 2008, 15:15
QSqlDatabase *conexaoBD = QSqlDatabase::addDatabase( "QODBC" );

if (conexaoBD!=0)
qWarning( "QODBC ---> OK!" );

conexaoBD->setDatabaseName( "DRIVER={Microsoft Access Driver (*.mdb)};FIL={MS Access};DBQ=ocorr_atendidas2006_2007.mdb" );

triperzonak
30th May 2008, 15:34
did you try using QODBC3 instead of QODBC?

cleber
30th May 2008, 15:41
I alter for QODBC3, error:

[iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded QODBC3: Unable to connect

triperzonak
31st May 2008, 10:12
im using QT under windows OS. after installation i run configure, then the dll files for ODBC and sqllite will be made and this dlls are ready to use. i dunno in linux/unix.

try building a plugin for ODBC.

cleber
6th June 2008, 15:02
Hi,

How building a plugin for ODBC on LInux?

Thank,
Cleber Ramos

jpn
6th June 2008, 21:49
How building a plugin for ODBC on LInux?
http://doc.trolltech.com/4.4/sql-driver.html#qodbc-for-open-database-connectivity-odbc