QtForum.org »
QtForum.org » Qt »
Qt Programming »Dear visitor, welcome to QtForum.org. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.
Wednesday, July 11th 2007, 9:58pm
|
Source code |
1 2 3 4 5 6 7 8 9 10 11 12 |
# tnsnames.ora Network Configuration File: C:oracleproduct10.2.0client_1tnsnames.ora # Generated by Oracle configuration tools. MyDatabase = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = MyDatabasePcHostName)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = MyDatabase) ) ) |
Wednesday, July 11th 2007, 10:10pm
|
|
Source code |
1 2 3 4 5 6 7 |
QSqlDatabase db = QSqlDatabase::addDatabase("QOCI");
db.setDatabaseName("MyDatabase");
db.setHostName("MyDatabasePcHostName");
db.setUserName("userid");
db.setPassword("*******");
db.setPort(1521);
bool ok = db.open();
|
Wednesday, May 9th 2012, 9:48am
|
|
Source code |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 |
#include <QtCore>
#include <QtSql>
#include <QSqlDatabase>
#include <iostream>
using namespace std;
int main(int argc, char *argv[])
{
QSqlDatabase qdb = QSqlDatabase::addDatabase("QOCI");
qdb.setHostName("localhost");
qdb.setDatabaseName("test");
qdb.setUserName("postgres");
qdb.setPassword("1234");
qdb.setPort(1521);
if(qdb.open())
{
cout << "Database connection successful!" << endl;
}
else
{
cout << "Database connection not successful!" << endl;
}
qdb.close();
return 0;
}
|
