Results 1 to 19 of 19

Thread: QOCIDriver: unable to create environment

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Mar 2009
    Location
    Brisbane, Australia
    Posts
    7,729
    Thanks
    13
    Thanked 1,610 Times in 1,537 Posts
    Qt products
    Qt4 Qt5
    Platforms
    Unix/X11 Windows
    Wiki edits
    17

    Default Re: QOCIDriver: unable to create environment

    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

  2. The following user says thank you to ChrisW67 for this useful post:

    thaihoangluu (10th May 2012)

  3. #2
    Join Date
    Dec 2011
    Posts
    33
    Thanks
    56
    Qt products
    Qt4
    Platforms
    Windows

    Default Re: QOCIDriver: unable to create environment

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

    But it's error
    Nguyễn Lưu Vũ - Http://nguyenluuvu.com

  4. #3
    Join Date
    Mar 2009
    Location
    Brisbane, Australia
    Posts
    7,729
    Thanks
    13
    Thanked 1,610 Times in 1,537 Posts
    Qt products
    Qt4 Qt5
    Platforms
    Unix/X11 Windows
    Wiki edits
    17

    Default Re: QOCIDriver: unable to create environment

    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.
    Last edited by ChrisW67; 10th May 2012 at 05:49.

  5. The following user says thank you to ChrisW67 for this useful post:

    thaihoangluu (10th May 2012)

  6. #4
    Join Date
    Dec 2011
    Posts
    33
    Thanks
    56
    Qt products
    Qt4
    Platforms
    Windows

    Default Re: QOCIDriver: unable to create environment

    Quote Originally Posted by ChrisW67 View Post
    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?
    Nguyễn Lưu Vũ - Http://nguyenluuvu.com

  7. #5
    Join Date
    Mar 2009
    Location
    Brisbane, Australia
    Posts
    7,729
    Thanks
    13
    Thanked 1,610 Times in 1,537 Posts
    Qt products
    Qt4 Qt5
    Platforms
    Unix/X11 Windows
    Wiki edits
    17

    Default Re: QOCIDriver: unable to create environment

    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.

  8. #6
    Join Date
    Dec 2011
    Posts
    33
    Thanks
    56
    Qt products
    Qt4
    Platforms
    Windows

    Default Re: QOCIDriver: unable to create environment

    Quote Originally Posted by ChrisW67 View Post
    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!!!!
    Nguyễn Lưu Vũ - Http://nguyenluuvu.com

  9. #7
    Join Date
    Mar 2009
    Location
    Brisbane, Australia
    Posts
    7,729
    Thanks
    13
    Thanked 1,610 Times in 1,537 Posts
    Qt products
    Qt4 Qt5
    Platforms
    Unix/X11 Windows
    Wiki edits
    17

    Default Re: QOCIDriver: unable to create environment

    I know your program generates error messages, you do not need to keep saying that. The situation will not change until you start applying some effort to identifying the problem.

  10. The following user says thank you to ChrisW67 for this useful post:

    thaihoangluu (10th May 2012)

  11. #8
    Join Date
    Dec 2011
    Posts
    33
    Thanks
    56
    Qt products
    Qt4
    Platforms
    Windows

    Default Re: QOCIDriver: unable to create environment

    Quote Originally Posted by ChrisW67 View Post
    I know your program generates error messages, you do not need to keep saying that. The situation will not change until you start applying some effort to identifying the problem.
    I connect MS SQL Server successfully but connect Oracle is very Complex @@
    Nguyễn Lưu Vũ - Http://nguyenluuvu.com

  12. #9
    Join Date
    Mar 2009
    Location
    Brisbane, Australia
    Posts
    7,729
    Thanks
    13
    Thanked 1,610 Times in 1,537 Posts
    Qt products
    Qt4 Qt5
    Platforms
    Unix/X11 Windows
    Wiki edits
    17

    Default Re: QOCIDriver: unable to create environment

    No, the Oracle client software needs to be installed correctly to be used. This is no different to the Microsoft SQL Server client, except that Microsoft install it with Windows.

    How have you installed the Oracle client software? Do any of the Oracle utilities function for connecting to the database?

  13. #10
    Join Date
    Dec 2011
    Posts
    33
    Thanks
    56
    Qt products
    Qt4
    Platforms
    Windows

    Default Re: QOCIDriver: unable to create environment

    Quote Originally Posted by ChrisW67 View Post
    No, the Oracle client software needs to be installed correctly to be used. This is no different to the Microsoft SQL Server client, except that Microsoft install it with Windows.

    How have you installed the Oracle client software? Do any of the Oracle utilities function for connecting to the database?

    How to install Oracle correctly?

    Step 1: I install Oracle Database Express Edition 11g Release 2. http://www.oracle.com/technetwork/pr...eSiteId=ocomen

    Step 2: I install Instant Client Downloads.http://www.oracle.com/technetwork/da...eSiteId=ocomen

    Am I correct?

    If I false please guide me Install Oracle.

    Thanks and sorry if My English is bad
    Nguyễn Lưu Vũ - Http://nguyenluuvu.com

  14. #11
    Join Date
    Mar 2009
    Location
    Brisbane, Australia
    Posts
    7,729
    Thanks
    13
    Thanked 1,610 Times in 1,537 Posts
    Qt products
    Qt4 Qt5
    Platforms
    Unix/X11 Windows
    Wiki edits
    17

    Default Re: QOCIDriver: unable to create environment

    Quote Originally Posted by Me
    Where is sqlplus.exe? Ignoring your program for the time being, can sqlplus connect to your database?
    Quote Originally Posted by Me
    Do any of the Oracle utilities function for connecting to the database?
    This is the last time I will ask:
    Do any of the Oracle supplied utilities work to connect to your database?

Similar Threads

  1. Unable to create qwtPlot object
    By jtso8 in forum Qwt
    Replies: 7
    Last Post: 23rd January 2012, 06:43
  2. Visual Studio 2010 Add-In - unable to create project
    By garaddon in forum Installation and Deployment
    Replies: 2
    Last Post: 1st January 2011, 11:40
  3. Eclipse debugging: Unable to create variable object
    By PUK_999 in forum Installation and Deployment
    Replies: 0
    Last Post: 20th August 2009, 21:42
  4. Unable to successfully create Qt application
    By remy06 in forum Qt Programming
    Replies: 1
    Last Post: 25th April 2009, 13:51
  5. QSQLITE Unable to fetch row in create
    By xgoan in forum Newbie
    Replies: 3
    Last Post: 18th October 2006, 14:39

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Qt is a trademark of The Qt Company.