Hi,
Please just tell me what are the database drivers available/supported in Qt for encryption and decryption of database. It will be very helpful for me to compile/build Qt.

Actually we were already checking the error handling, but i had typed here simple way to explain, how i am doing ? sorry for that.

Any how now i am posting actual code content from my sample code.

Qt Code: 
  1. QSqlDatabase db1 = QSqlDatabase::addDatabase("SQLITECIPHER");
  2.  
  3.      db1.setDatabaseName("Qt.db");
  4.      qDebug() << QSqlDatabase::drivers();
  5.  
  6.         db1.open();
  7.  
  8.         QSqlQuery qry;
  9.         bool ret = qry.exec("PRAGMA key = 'test123';");
  10.         qDebug()<<"Pragma key exec ret:::"<<ret;
  11.         ret = qry.exec("PRAGMA cipher_use_hmac = OFF");
  12.         qDebug()<<"Pragma cipher exec ret:::"<<ret;
  13.  
  14.             ret = qry.exec("create table employee(sno INTEGER,empname varchar(100)); ");
  15.             qDebug()<<"create table exec ret:::"<<ret;
  16.             if(ret == false)
  17.             {
  18.                 QMessageBox::warning(this,"Error-msg","Table already created",QMessageBox::Ok);
  19.             }
  20.  
  21.         ret = qry.exec("insert into employee(sno,empname)values(46,'abc');");
  22.         qDebug()<<"insert into table exec ret:::"<<ret;
  23.         ret = qry.exec("insert into employee(sno,empname)values(11,'xyz');");
  24.         qDebug()<<"insert into table exec ret:::"<<ret;
  25.  
  26.         db1.close();
  27.         if(ret == true)
  28.             QMessageBox::information(this,"Info","Encrypted Successfully",QMessageBox::Ok);
  29.         else
  30.             QMessageBox::warning(this,"Error-msg","Encryption Failed",QMessageBox::Ok);
To copy to clipboard, switch view to plain text mode