Database Drivers Related to Qt

[StarRocks]

Dear Wysota,

I have done with Postgresql..........But having a problem with ODBC not knowing how to do it........Can you just help me out the way that you done for rest of the databases...........Thanks in advance......Any solution would be appreciable.......

Regards,

[wysota]

Is there any reason why you are trying all the database plugins?

For ODBC install appropriate packages for your system just like I have shown you for PostgreSQL.

[StarRocks]

Dear Wysota,

Thanks for the reply........Can you send me the same steps for ODBC like the way you sent me for PSQL ......I mean the commands that you sent me right similarly the same way can you give me in the form of step wise......Thanks in advance..........Any solution would be appreciable.....

Regards,

[sonulohani]

sudo apt-get install libqt4-sql-odbc

or download it from here:-

http://pkgs.org/download/libqt4-sql-odbc

[StarRocks]

Dear Wysota,

Thanks for the reply......As you gave me a link to find out right but im not knowing what this link will helpout me..I need to build drivers right for ODBC ....Can you give me in brief how do i run in Terminal of Ubuntu....That would be helpful......Thanks in advance....Any Solution would be appreciable....
http://www.lmgtfy.com?q=apt-get+ubuntu

Regards,

[wysota]

I need to build drivers right for ODBC ....

No, you don't.

Can you give me in brief how do i run in Terminal of Ubuntu

That's not a "I'm a Ubuntu luser, help me" forum. That's a Qt forum. To learn to use Linux, go to some other forum like www.linuxquestions.org

[StarRocks]

Dear Wysota,


Thanks for the reply..........I have builded Odbc driver,but when i run my program i am getting the following error message as " [unixODBC][Driver Manager]Data source name not found, and no default driver specified QODBC3: Unable to connect" ....I am not sure whether my program is wrong or the connection that i gave is wrong correct me if my program is wrong please find the code given below.........Thanks in Advance............Any solution would be appreciable.........



#include "mainwindow.h"
#include "ui_mainwindow.h"
#include <QTableWidget>
#include <QSqlDatabase>
#include <QMessageBox>
#include <qdebug.h>
#include <QtSql>

MainWindow::MainWindow(QWidget *parent) :
QMainWindow(parent),
ui(new Ui::MainWindow)
{
ui->setupUi(this);

qDebug()<<"Im Venu-------------------------------";
QTableWidget* table = new QTableWidget();
table->setWindowTitle("Connect to Mysql Database Example");

qDebug()<<"Im coming Back to Rock";

// qDebug()<<"Im Waiting for the Value"<<app.libraryPaths();

QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");

// db.setDatabaseName("Data Source=192.168.1.73,1433;Network Library=DBMSSOCN;"
// );


db.setHostName("192.168.1.73");
db.setDatabaseName("Test");
db.setUserName("sa");
db.setPassword("sa@123");


// db.setDatabaseName( "Test" );
// db.setUserName( "sa" );
// db.setPassword( "sa@123" );
// db.setHostName( "192.168.1.73" );

// db.setHostName("localhost");
// db.setDatabaseName("test");
// db.setUserName("venugopal");
// db.setPassword("admin");

qDebug()<<db.drivers()<<"Lemme speak something";
if (!db.open())
{
QMessageBox::critical(0, QObject::tr("Database Error"),
db.lastError().text());
}

QSqlQuery query;
bool a= query.exec("SELECT * FROM Employee");
qDebug()<<a<<"111111111111111111111111111111111111111111111";

table->setColumnCount(query.record().count());
table->setRowCount(query.size());

int index=0;
while (query.next())
{
table->setItem(index,0,new QTableWidgetItem(query.value(0).toString()));
table->setItem(index,1,new QTableWidgetItem(query.value(1).toString()));
index++;
}

table->show();

}

MainWindow::~MainWindow()
{
delete ui;
}

void MainWindow::changeEvent(QEvent *e)
{
QMainWindow::changeEvent(e);



switch (e->type()) {
case QEvent::LanguageChange:
ui->retranslateUi(this);
break;
default:
break;

}
}




Regards,

[wysota]

Definitely your database name is wrong. It should comply to ODBC standards of choosing the data source.

For the QODBC driver, the name can either be a DSN, a DSN filename (in which case the file must have a .dsn extension), or a connection string.