i had this Problem, DB Connection fail!
O.S :Windows_XP
tool :Qt_Program(Ver. 4.3.3) installed on VisualStudio 2005
DataBase : Oracle 10g
I want to Connect DataBase , this is my source code
frist, i added Qt Module(Sql)
#include <QtSql>
#include <QSqlDatabase>
#include <QSqlQuery>
#include <QSqlQueryModel>
db.setHostName("192.168.1.223");
db.setDatabaseName("SSS");
db.setPort(1521);
db.setUserName("kkkk");
db.setPassword("1111");
bool ok = db.open();
#include <QtSql>
#include <QSqlDatabase>
#include <QSqlQuery>
#include <QSqlQueryModel>
QSqlDatabase db;
db = QSqlDatabase::addDatabase("QOCI");
db.setHostName("192.168.1.223");
db.setDatabaseName("SSS");
db.setPort(1521);
db.setUserName("kkkk");
db.setPassword("1111");
bool ok = db.open();
To copy to clipboard, switch view to plain text mode
and....... This defined tnsname.ora file
SSS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.223)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = SSS)
)
)
SSS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.223)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = SSS)
)
)
To copy to clipboard, switch view to plain text mode
compile Result : No error , but ok's value is false!
so... what's is the problem?
Bookmarks