QOCIDriver: unable to create environment

[thaihoangluu]

The errors generated by line 32 are self-explanatory, your options do not appear in the list here: QSqlDatabase::setConnectOptions()

Oh, i'm sorry

this code:
#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;
}
Errors:
QOCIDriver: unable to create environment
Unable to free Error handle: -1
Unable to free Environment handle: -1

I encountered this problem.
Help me, please.

[ChrisW67]

You don't say whether the database connection opens or not. The first line is a Qt warning, not an error. The warning results when OCIEnvCreate() (not a Qt function) fails. A quick search suggests this is either an incorrect ORACLE_HOME or permissions related: can your user read the directories under ORACLE_HOME?

[thaihoangluu]

You don't say whether the database connection opens or not. The first line is a Qt warning, not an error. The warning results when OCIEnvCreate() (not a Qt function) fails. A quick search suggests this is either an incorrect ORACLE_HOME or permissions related: can your user read the directories under ORACLE_HOME?

#include <QtCore>
#include <QtSql>
#include <QSqlDatabase>
 
#include <iostream>
 
using namespace std;
 
int main(int argc, char *argv[])
{
QSqlDatabase qdb = QSqlDatabase::addDatabase("QOCI");//If I replace "QOCI" = "QODBC" -> It's okay.
 
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;
}

#include <QtCore>
#include <QtSql>
#include <QSqlDatabase>

#include <iostream>

using namespace std;

int main(int argc, char *argv[])
{
QSqlDatabase qdb = QSqlDatabase::addDatabase("QOCI");//If I replace "QOCI" = "QODBC" -> It's okay.

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;
}

To copy to clipboard, switch view to plain text mode 

How to fix error QOCIDriver: unable to create environment .Hizzzz

[thaihoangluu]

Dear ChrisW67
Can you help me? Please !

[ChrisW67]

I already have...

The warning results when OCIEnvCreate() (not a Qt function) fails. A quick search suggests this is either an incorrect ORACLE_HOME or permissions related: can your user read the directories under ORACLE_HOME?

Have you checked these things?

[thaihoangluu]

I already have...


Have you checked these things?

How do you define Oracle_Home -> i don't know this.
Sorry if my question stupid

Do you guide me with image?
thanks so much.

[ChrisW67]

ORACLE_HOME is an environment variable, or on Windows a registry entry, that almost all Oracle utilities use to find, among other things, the Oracle client and connection information files. ORACLE_HOME has nothing to do with Qt specifically and is set outside your program. ORACLE_HOME is generally set by the Oracle client installer. I suggest you need to consult your Oracle DBA or Oracle documentation.

http://www.orafaq.com/wiki/ORACLE_HOME

[thaihoangluu]

Thank you.
I set varible environment :
Name: ORACLE_HOME
Value: C:\oraclexe\app\oracle\product\11.2.0\server

But it's error

[ChrisW67]

Take the "/server" off the end. The example in the FAQ I linked stops at the version numbered folder. You should be able to find a folder "bin" (usually contains sqlplus) in the folder pointed to by ORACLE_HOME.

[thaihoangluu]

Take the "/server" off the end. The example in the FAQ I linked stops at the version numbered folder. You should be able to find a folder "bin" (usually contains sqlplus) in the folder pointed to by ORACLE_HOME.

I tried all suggest , but it's nothing to effective



It's my HOME PATH ORACLE FOLDER.
a.jpg
Can you tell me Set variable environtment please?

[ChrisW67]

Where is sqlplus.exe? Ignoring your program for the time being, can sqlplus connect to your database?

I do not propose to download and install an entire RDBMS just to answer your question.

[thaihoangluu]

Where is sqlplus.exe? Ignoring your program for the time being, can sqlplus connect to your database?

I do not propose to download and install an entire RDBMS just to answer your question.

I don't know @@
I have followed all instructions but when running any program error!!!!