PDA

View Full Version : work general with plugins



raphaelf
16th February 2006, 14:03
Hello everybody,

OS: WINXP
COMPILER: MINGW
QT: 3.4

I have programed a small program who make connection via obdc using the plugin "qsqlodbc.dll" with sql server. Everything work fine on "my machine".
I copied the program include all dlls to a client.
the program runs but my qsqlodbc.dll could not be found. "DRIVER NOT LOADED".
The Program are not able to use qsqlodbc.dll
What should i do to be able to use this dll in the same directory like my program?:confused:

zlatko
16th February 2006, 14:27
Create folder sqldrivers in your app folder. Put qsqlodbc.dll here.

raphaelf
16th February 2006, 14:43
Hi,
If i copy everything on the client and make a new directory "sqldrivers" and put my plugin there it works.
Maybe i have not explain exactly: I copyed everything on a server and i created a shortcut on a client. I was able to run the app from the client, but not to use the odbc plugin. I get the error message on the client "DRIVER NOT LOADED".
Have i a solution for that?

THX

zlatko
16th February 2006, 14:58
Problem with paths!
Use something like FileMonitor for searching what dll and where needed by your app in other comp

wysota
16th February 2006, 15:27
You might be missing some ODBC client libraries.

raphaelf
17th February 2006, 08:38
hi wysota,
where should i find the client libs? I have compiled qsqlodbc from qt source..

zlatko
17th February 2006, 11:03
how did you bild it if you havent needed libs?
I surly recomended you use FileMonitor:)

p.s. ODBC its not best way conect to database server,use native database driver for it;)

raphaelf
17th February 2006, 14:04
hi ;)
i tried to copy "libqlqlodbc.a" to the server, but i get the same error message
FileMonitor should help me,its true.
I read about native driver. The Docs say that on should use native driver instead of odbc..
But i found nothing how to create a native driver and how to connect with..
Have you informations about native drivers?

jacek
17th February 2006, 14:07
i tried to copy "libqlqlodbc.a" to the server, but i get the same error message
Try copying the .dll file instead. That .a file is needed only for linking.

raphaelf
17th February 2006, 14:14
Hi Jacek,
I tried allready to copy qsqlodbc.dll to the app directory and tried also to create a folder "sqldrivers" and copy the qsqlodbc.dll there.
I have a problem with starting the app from a client via shortcut
If i copy the app, dlls on the client it works..But we want to create on every client just a shortcut from the app that is on the server. If we change something on the app, we will have to make nothing on every client..

zlatko
17th February 2006, 14:16
I read about native driver. The Docs say that on should use native driver instead of odbc..
But i found nothing how to create a native driver and how to connect with..
Have you informations about native drivers?

sorry but what database server you use ?
Postgre? Firebird? Oracle? ...:confused:

raphaelf
17th February 2006, 14:18
MS SQL SERVER 7.0 :rolleyes:

zlatko
17th February 2006, 14:30
Hm..Qt havnt direct driver for it..You must use odbc...
I think you must have 2 dll:
one - qsqlodbc.dll what must be copied in sqldrivers folder
second - someodbc.dll what must be in the same with app folder

Dont ask me what is someodbc.dll :)

wysota
17th February 2006, 14:51
Hi Jacek,
I tried allready to copy qsqlodbc.dll to the app directory and tried also to create a folder "sqldrivers" and copy the qsqlodbc.dll there.
I have a problem with starting the app from a client via shortcut
If i copy the app, dlls on the client it works..But we want to create on every client just a shortcut from the app that is on the server. If we change something on the app, we will have to make nothing on every client..

Try changing the working directory to the one where the app binary resides before running the application, so that the driver for sql database is in "$PWD/sqldrivers".

BTW. You must have Qt libraries on every host anyway. Can't you place the sql driver on every host too along those libraries?

raphaelf
17th February 2006, 15:30
hi,
yes i will install on every host the qsqlodbc.dll file and make a user variable, of course with installshield :p
thx for all reply..