You are not logged in.

QOCIDriver: unable to create environment

thaihoangluu

Beginner

  • "thaihoangluu" started this thread

Posts: 3

  • Send private message

1

Tuesday, May 8th 2012, 8:48am

QOCIDriver: unable to create environment

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:


Source code

 
1

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



Errors:
QOCIDriver: unable to create environment
QOCIDriver:arseArgs: Invalid parameter: 'Prefetch_Memory'
QOCIDriver:arseArgs: 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!

Similar threads