Deploy QT SQL app where Oracle client is not installed

[mvbhavsar]

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

[ChrisW67]

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)

[ObiWanKenobe]

If you want Oracle access without client software installation, then use Oracle Instant Client.

[Qiieha]

Do it like ChrisW67 said.

[ObiWanKenobe]

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.

[mvbhavsar]

Thanks to all.
With Oracle instant client it worked.


Regards

Manish