Results 1 to 6 of 6

Thread: Deploy QT SQL app where Oracle client is not installed

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Jun 2010
    Posts
    97
    Thanked 2 Times in 2 Posts
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows

    Default Deploy QT SQL app where Oracle client is not installed

    Hi,

    I have developed an application using QOCI plugins and it is working fine on my machine. On my machine I have QT 4.7 and Oracle 10g client installed. Now I want to deploy this application on the machine having OS win xp where QT as well as Oracle client is not installed. I have deployed my executable with following dlls.

    libgcc_s_dw2-1.dll
    mingwm10.dll
    oci.dll
    oraclient10.dll
    QtCore4.dll
    QtGui4.dll
    QtSql4.dll

    also, I have created a directory called sqldrivers at the location where all above files and executable is there and have put qsqloci4.dll file in that.

    Now when I try to run my application GUI open up but when it try to connect to Oracle it gives an error that Driver not loaded.
    How to resolve this issue.


    Regards

    Manish

  2. #2
    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: Deploy QT SQL app where Oracle client is not installed

    You need to distribute the Qt SQL driver plugins for QOCI (assuming that is what you have used) and when loaded they need to be able to find the Oracle client dlls. Try putting the Oracle client libs in the sqldrivers folder with the plugin. The Oracle client libraries may also need other things in the environment like certain registry settings or configuration files.

    (You also need to be sure of the legality of distributing Oracle proprietary components, but that's not the technical issue)
    Last edited by ChrisW67; 30th March 2012 at 01:11. Reason: updated contents

  3. #3
    Join Date
    Oct 2011
    Location
    Germany
    Posts
    27
    Thanked 2 Times in 2 Posts
    Qt products
    Qt4 Qt5
    Platforms
    Unix/X11 Windows

    Default Re: Deploy QT SQL app where Oracle client is not installed

    If you want Oracle access without client software installation, then use Oracle Instant Client.
    Insanity: doing the same thing over and over again and expecting different results.
    Albert Einstein

  4. #4
    Join Date
    Apr 2011
    Posts
    195
    Thanks
    49
    Thanked 4 Times in 4 Posts
    Qt products
    Qt4 Qt5
    Platforms
    MacOS X Unix/X11 Windows

    Default Re: Deploy QT SQL app where Oracle client is not installed

    Do it like ChrisW67 said.

  5. #5
    Join Date
    Oct 2011
    Location
    Germany
    Posts
    27
    Thanked 2 Times in 2 Posts
    Qt products
    Qt4 Qt5
    Platforms
    Unix/X11 Windows

    Default Re: Deploy QT SQL app where Oracle client is not installed

    The standard Oracle client software must be properly installed. The oci dll deployed with it needs some registry settings and environment variables (ORACLE_HOME for example) set.
    Oracle instant client doesn't need that settings and can be used without any installation.
    I assume that the oci.dll you use comes from Oracle 10g Client installed on your computer. Without a proper Oracle Client installation, it won't work.
    As I said before, use Oracle Instant Client.
    Insanity: doing the same thing over and over again and expecting different results.
    Albert Einstein

  6. #6
    Join Date
    Jun 2010
    Posts
    97
    Thanked 2 Times in 2 Posts
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows

    Default Re: Deploy QT SQL app where Oracle client is not installed

    Thanks to all.
    With Oracle instant client it worked.


    Regards

    Manish

Similar Threads

  1. Client-Client communication
    By zgulser in forum Newbie
    Replies: 0
    Last Post: 2nd December 2010, 08:07
  2. how to deploy qt based application with oracle plugin
    By kaycee1 in forum Installation and Deployment
    Replies: 1
    Last Post: 28th October 2010, 17:02
  3. can i have both qt3 and qt4 installed
    By illuzioner in forum Installation and Deployment
    Replies: 1
    Last Post: 8th June 2007, 08:50
  4. correctly installed Qt4
    By Salazaar in forum Installation and Deployment
    Replies: 31
    Last Post: 7th May 2007, 07:24
  5. Fix: QT app won't run under Oracle Standard Client install
    By GreyGeek in forum General Discussion
    Replies: 0
    Last Post: 12th May 2006, 18:20

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.