You are not logged in.

Qt and Data base

robert456

Beginner

  • "robert456" is male
  • "robert456" started this thread

Posts: 13

Occupation: Student

  • Send private message

1

Wednesday, July 28th 2010, 1:50pm

Qt and Data base

hi everybody,
i'm working on an application using Qt4 and Oracle 10g.
On my computer I have no probleme to connect to my data base(i have compiled the driver).
but now i want to run my application on an other PC connected to the same network as mine(to can access to data base).
My probleme is that the application cannot connect to data base and the error message say "Driver not loaded"
I have copied all DLL necessary(QT dll , oci.dll, qsqloci4.dll).

What is the probleme?? and what i have to do??

Please help me

thanxs :)

Messenger

Professional

  • "Messenger" is male

Posts: 1,286

Location: Lt

  • Send private message

2

Wednesday, July 28th 2010, 3:40pm

Quoted


I have copied all DLL necessary(QT dll , oci.dll, qsqloci4.dll).

What is the probleme?? and what i have to do??

Read Qt documentation how to deploy applications and plugins.
http://doc.qt.nokia.com/4.7-snapshot/deployment.html
http://doc.qt.nokia.com/4.7-snapshot/deployment-plugins.html
http://doc.qt.nokia.com/4.7-snapshot/plu…ocating-plugins


Show the structure how files was deployed.

imo qsqloci4.dll and oci.dll must be in [exe dir]\sqldrivers\ folder.

Use depends.exe and examine qsqloci4.dll and oci.dll. It will show if some dlls are missing.
Fighting fire with fire.
Three can keep a secret if two of them are dead.

robert456

Beginner

  • "robert456" is male
  • "robert456" started this thread

Posts: 13

Occupation: Student

  • Send private message

3

Thursday, July 29th 2010, 8:40am

the structure how files are deployed is like this:

folder_exe
------> app.exe
------> libgcc_s_dw2-1.dll
------> mingwm10.dll
------> QtCored4.dll
------> QtGuid4.dll
------> QtSqld4.dll
------> sqldrivers (folder)
-----------> folder
----------------> oci.dll (and i have also put all DLLs which was with oci.dll in the oracle folder)
----------------> qsqloci4.dll

And please tell how to use depends because its complicated for me or just where found the depends DLLs of the EXE file.

Messenger

Professional

  • "Messenger" is male

Posts: 1,286

Location: Lt

  • Send private message

4

Thursday, July 29th 2010, 8:59am

Quoted


folder_exe
------> app.exe
------> libgcc_s_dw2-1.dll
------> mingwm10.dll
------> QtCored4.dll
------> QtGuid4.dll
------> QtSqld4.dll
------> sqldrivers (folder)
-----------> folder <- what is this? or I misunderstand.
----------------> oci.dll (and i have also put all DLLs which was with oci.dll in the oracle folder)
----------------> qsqloci4.dll
must be something like
(main/application/executable folder)
app.exe
libgcc_s_dw2-1.dll
mingwm10.dll
QtCored4.dll
QtGuid4.dll
QtSqld4.dll
sqldrivers
sqldrivers\oci.dll (and i have also put all DLLs which was with oci.dll in the oracle folder)
sqldrivers\qsqloci4.dll

QtCored4.dll - never ever distribute debug application versions.

Quoted


And please tell how to use depends because its complicated for me or just where found the depends DLLs of the EXE file.

First google link - http://www.dependencywalker.com/
Fighting fire with fire.
Three can keep a secret if two of them are dead.

robert456

Beginner

  • "robert456" is male
  • "robert456" started this thread

Posts: 13

Occupation: Student

  • Send private message

5

Friday, July 30th 2010, 9:28am

Hi back,

the probleme of "driver not loaded" is resolved. I got an other one now.
An error message " ORA-12170: TNS: Connect timeout Unable to log on ". o_O

And about QtCored4.dll, i cannot run the application only if i compiled Qt in static mode and my application arent in debug mode (i didnt inderstand what you mean exactly)!!

Messenger

Professional

  • "Messenger" is male

Posts: 1,286

Location: Lt

  • Send private message

6

Friday, July 30th 2010, 10:04am

Quoted


And about QtCored4.dll, i cannot run the application only if i compiled Qt in static mode and my application arent in debug mode

Then maybe you use wrong version Qt dlls.
somewhere in internet

Quoted


The SDK comes with two sets of dlls. One set resides in $BASEDIR/bin and the other in $BASEDIR/qt/bin. The former contains the dlls used by Qt Creator, while the latter are the dlls that you want to ship with your executable.


Quoted


i didnt inderstand what you mean exactly

I meant only that application debug version must be used only for development. Not for sale/distribution etc.

What happens if you compile the application in release mode and try to run? Messages etc?

Make simple example project. Build it release mode. Archive everything (binaries and sources etc) and save in some file share. Post link here for examining.
Fighting fire with fire.
Three can keep a secret if two of them are dead.