[PyQt] Re: Build PyQt with sql Driver plugins

[paulino1 at sapo.pt]

Citando Linos <info at linos.es>:

> Paulino escribió:
>> Linos escreveu:
>>> paulino1 at sapo.pt escribió:
>>>
>>>> Citando Linos <info at linos.es>:
>>>>
>>>>
>>>>> paulino1 at sapo.pt escribió:
>>>>>
>>>>>> Citando Linos <info at linos.es>:
>>>>>>
>>>>>>
>>>>>>> Paulino escribió:
>>>>>>>
>>>>>>>> *>Linos* info at linos.es
>>>>>>>> <mailto:pyqt%40riverbankcomputing.com?Subject=%5BPyQt%5D%20Build%20PyQt%20with%20sql%20Driver%20plugins&In-Reply-To=200709251523.53366.phil%40riverbankcomputing.co.uk>
>>>>>>>>
>>>>>>>>
>>>>>>>> />Tue Sep 25 22:21:33 BST 2007/
>>>>>>>> ------------------------------------------------------------------------
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>> The last version in windows works very well for me with odbc support
>>>>>>>>> but i have compilend by hand (sip
>>>>>>>>> and pyqt, qt installed from binary) i dont know if binary packages
>>>>>>>>> fail, i have a problem with odbc in
>>>>>>>>> linux but in windows works very well.
>>>>>>>>>
>>>>>>>> I have also compiled by hand sip and PyQt, and instaled qt from
>>>>>>>> binary, but didn't got QODBC available.
>>>>>>>>
>>>>>>>> What options did you gave the PyQt's configure.py?
>>>>>>>>
>>>>>>>>
>>>>>>>> Paulino
>>>>>>>>
>>>>>>>>
>>>>>>> Paulino i am using gcc 3.4.5 from mingw, PyQt-win-gpl-4.3, sip-4.7,
>>>>>>> python 2.5.1 and
>>>>>>> qt-win-opensource-4.3.1-mingw, i compile pyqt whithout any options in
>>>>>>> configure.py, it detects qsql and
>>>>>>> qodbc while compiling and works ok.
>>>>>>>
>>>>>>>
>>>>>> I used the same packages you refer!
>>>>>>
>>>>>> I wonder why it didn't detected QODBC ????
>>>>>>
>>>>>> Paulino
>>>>>>
>>>>>>
>>>>> i have in c:\qt\4.3.1\plugins\sqldrivers\ the files:
>>>>>
>>>>> libqsqlodbc4.a
>>>>> qsqlodbc4.dll
>>>>>
>>>>> do you have the same?
>>>>>
>>>>>
>>>> Yes, and also:
>>>> libqsqlite4.a
>>>> qsqlite4.dll
>>>>
>>>> But don't have any driver available.
>>>>
>>>> Paulino
>>>>
>>>>
>>>
>>> i would try recompiling sip and later pyqt, if you have no luck i  
>>> can try in other virtual machine to see
>>> if it works for me other time.
>>>
>>>
>>>
>> I tried for 3 times - one on a clean virtual machine. No drivers available.
>
> Paulino i have tried today in a clean virtual machine and it works  
> for me, i have done this:
>
> install mingw-5.1.3.exe
> install qt-win-opensource-4.3.1-mingw.exe
> install python-2.5.1.msi
> install pywin32-210.win32-py2.5.exe


> add to system path variable:  
> c:\python25;C:\MinGW\libexec\gcc\mingw32\3.4.2;c:\MinGW\bin;C:\Qt\4.3.1\bin

I hadn't add this path :C:\MinGW\libexec\gcc\mingw32\3.4.2
All the others OK

> cd into sip-4.7 directory:
> 	python configure.py

I give the "-p win32-g++" flag to configure.py. (I learn it from PyQt  
wiki : http://www.diotavelli.net/PyQtWiki/BuildPyQt4Windows)
If i don't I get errors on the make command

> 	mingw32-make
> 	mingw32-make install
> cd into PyQt-win-gpl-4.3
> 	python configure.py
> 	mingw32-make
> 	mingw32-make install
>
Dit it like you!

> And later it works well for me, i have odbc drivers and it works, i  
> connect to an odbc source with this code.
>
> -----------------------------------------------------------------------------------------------------------------------------
> import os,  sys
> from PyQt4.QtCore import *
> from PyQt4.QtSql import *
> from PyQt4.QtGui import *
>
> def conectarMaxdb():
>     '''conexion via ODBC con QT a MAXDB'''
>     maxdb = QSqlDatabase.addDatabase("QODBC", 'maxdb')
>     maxdb.setDatabaseName("DRIVER={MaxDB  
> (Unicode)};HOSTNAME=192.168.1.20;DATABASE=MAXDB2") --> windows
> code dsn less
>     maxdb.setUserName("FAKE")
>     maxdb.setPassword("FAKE")
>     aperturamaxdb = maxdb.open()
>     if not aperturamaxdb:
>         QMessageBox.warning(None,  "Error conexion con la DB",   
> QString("Database Error:
> %1").arg(maxdb.lastError().text()))
>         sys.exit(1)
>     return maxdb
>
>
> if __name__ == "__main__":
>     app = QApplication(sys.argv)
>     dbmaxdb = conectarMaxdb()
>     print dbmaxdb.isOpen() -----> print True
>     print dbmaxdb.isValid() ----> print True
>
> -----------------------------------------------------------------------------------------------------------------------------
>
> I hope this can help you.
>
> Best Regards,
> Miguel Angel.
>

I'll try once more with pywin32-210.win32-py2.5.exe installed, that  
hadn't last time, although I haven't seen any reference to it related  
to PyQt...

Thank you very much for your help!

Paulino