QOCIDriver: unable to create environment

[thaihoangluu]

Hi verybody.
I'm trying to connect Oracle Database using QOCI Driver.
I used QT Eclipse Plugin + MINGW + Eclipse C++ + Window 7.

I complied OCI.DLL success.
But when I run my code here:

#include <QApplication>
#include <QtSql>
#include <QtPlugin>
 
 
#include <iostream>
using namespace std;
 
/* Change these to match your database */
#define HOST   "127.0.0.1"
#define DB     "xe"
#define PORT   1521
#define USER   "testbed"
#define PASSWD "secre3t"
 
int main(int argc, char *argv[])
{
    QApplication app(argc, argv);
 
 
   // QSqlDatabase db = QSqlDatabase::addDatabase(ociDriver->create("QOCI"));
 
    QSqlDatabase qDB = QSqlDatabase::addDatabase("QOCI");
 
    qDB.setHostName(HOST);
    qDB.setDatabaseName(DB);
    qDB.setPort(PORT);
    qDB.setUserName(USER);
    qDB.setPassword(PASSWD);
 
    /* Probably overkill ;) */
    qDB.setConnectOptions("Prefetch_Memory=5242880;Prefetch_Rows=250");
 
    if (qDB.open() == FALSE) {
         cout<< "Error: opening DB failed because " << qDB.lastError().text().toStdString();
        return -1;
    }
 
 
    return 0;
}

#include <QApplication>
#include <QtSql>
#include <QtPlugin>


#include <iostream>
using namespace std;

/* Change these to match your database */
#define HOST   "127.0.0.1"
#define DB     "xe"
#define PORT   1521
#define USER   "testbed"
#define PASSWD "secre3t"

int main(int argc, char *argv[])
{
    QApplication app(argc, argv);


   // QSqlDatabase db = QSqlDatabase::addDatabase(ociDriver->create("QOCI"));

    QSqlDatabase qDB = QSqlDatabase::addDatabase("QOCI");

    qDB.setHostName(HOST);
    qDB.setDatabaseName(DB);
    qDB.setPort(PORT);
    qDB.setUserName(USER);
    qDB.setPassword(PASSWD);

    /* Probably overkill ;) */
    qDB.setConnectOptions("Prefetch_Memory=5242880;Prefetch_Rows=250");

    if (qDB.open() == FALSE) {
         cout<< "Error: opening DB failed because " << qDB.lastError().text().toStdString();
        return -1;
    }

   
    return 0;
}

To copy to clipboard, switch view to plain text mode 

Errors:
QOCIDriver: unable to create environment
QOCIDriver:: parseArgs: Invalid parameter: 'Prefetch_Memory'
QOCIDriver:: parseArgs: Invalid parameter: 'Prefetch_Rows'
Unable to free Error handle: -1
Unable to free Environment handle: -1

I set variables enviroment here:
Name: Path
Value: C:\oraclexe\app\oracle\product\11.2.0\server\bin;; C:\app\nguyenluuvu\product\11.2.0\client;C:\app\ng uyenluuvu\product\11.2.0\client_1\bin;E:\app\nguye nluuvu\product\11.2.0\client_1;C:\app\MAY02\produc t\11.2.0\dbhome_1\bin;%SystemRoot%\system32;%Syste mRoot%;%SystemRoot%\System32\Wbem;%SYSTEMROOT%\Sys tem32\WindowsPowerShell\v1.0\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\;C:\Prog ram Files\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\;C:\Program Files\TortoiseSVN\bin;C:\Program Files\TortoiseHg\;C:\MinGW\bin\; C:\msys\1.0\bin\;C:\luuvu\MinGW\bin;C:\Program Files\CMake 2.8\bin;C:\luuvu\qt\bin;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files\OPENCV;C:\App\nguyenluuvu\product\11.2.0\cli ent_1\oci\include;C:\App\nguyenluuvu\product\11.2. 0\client_1\oci\lib\msvc;C:\Windows\System32;C:\luu vu\qt\plugins\sqldrivers\qopenocci.dll;C:\oraclexe \app\oracle\product\11.2.0\instantclient_11_2;C:\o raclexe\app\oracle\product\11.2.0\server\bin;C:\Wi ndows\System32;C:\oraclexe\app\oracle\product\11.2 .0\server\oci\lib\MSVC;C:\oraclexe\app\oracle\prod uct\11.2.0\server\oci\include



Can you help me?
Thanks so much!

[ChrisW67]

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

[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.