[PyQt] ANN: PyQt v5.8 and SIP v4.19.1 Released

[Pou Belle]

Pete wrote :

>>* -Install PostgreSQL to get libpq.dll
*>>* -Install vcredist_2013, or PostgreSQL will not work.
*
> Since this is a glitch in the PostgreSQL windows package, it should be
> reported to the PostgreSQL packagers.

I don't think it's a glitch. I use the PostgreSQL zip package, not the
msi/exe one, so it's not supposed to install vcredist automatically.

I thought PostgreSQL was compiled with the same version (vcredist2015)
as Python3.5, so I assumed I did not have to install vcredist, but it
turned out PostgreSQL  was compiled with 2013.

Whether it's automatic or not, the result is the same, you need to
have vcredist2013 on the client computer.

Cheers.


2017-02-22 12:40 GMT+01:00 Pou Belle <belepoub at gmail.com>:

> Sibylle wrote :
>
> >> Thanks Sibylle. I already had the PATH pointing to the bin directory,
> but didn't work.>>
> >> I finally found the solution :  I had to install vcredist_2013
> (Microsoft Visual C++ 2013 Redistributable)
> >>
> >> It's really strange, because python 3.5.2 and PyQt5.7.1 are both using
> vc2015, so I assumed they would refuse to work with a vc2013 library.
> >> Life is strange ;-)
> >>
> >It seems that PostgreSQL wants that library. At least the update to 9.6.2
> started with "Setup Visual C++ 2013 Redistributable".
> >
> >But does that mean this must be installed on every machine accessing a
> PostgreSQL database with a PyQt5 client application?
> >
> >Greetings,
> >Sibylle
>
>
> I think so.
> If you want an all-in-one package, you can still use PyQt5.6, it contains
> absolutely everything needed to work with PyQt/Qt.
> When the wheels replaced the exe (when moving from 5.6 to 5.7), a lot of
> stuff was removed from the package.
>
> It's sometimes difficult to know what's missing, until you hit a problem.
> I have seen threads on a few forums, that try to list what you need to
> install to get the same stuff as before wheels, but most of them are
> incomplete.
>
> So far I have found these steps :
> -Install PyQt.
> -Install Qt to get designer.exe and Qt5DesignerComponents.dll
> -Install pyqt5-tools to get pyqt5.dll if you want to use custom widgets in
> Designer. But pyqt5-tools is not maintained for all PyQt versions, so I
> avoid it.
> -Install MySQL to get libmysql.dll
> -Install PostgreSQL to get libpq.dll
> -Install vcredist_2013, or PostgreSQL will not work.
>
>
>
> 2017-02-21 18:34 GMT+01:00 Pou Belle <belepoub at gmail.com>:
>
>> Thanks Sibylle. I already had the PATH pointing to the bin directory, but
>> didn't work
>>
>> I finally found the solution :  I had to install vcredist_2013 (Microsoft
>> Visual C++ 2013 Redistributable)
>>
>> It's really strange, because python 3.5.2 and PyQt5.7.1 are both using
>> vc2015, so I assumed they would refuse to work with a vc2013 library.
>> Life is strange ;-)
>>
>>
>>
>> 2017-02-21 16:28 GMT+01:00 Sibylle Koczian <nulla.epistola at web.de>:
>>
>>> Am 20.02.2017 um 16:00 schrieb Pou Belle:
>>>
>>>> />>> But that can't be right: it would mean repeating this with every
>>>> update of either PyQt or PostgreSQL??? />>//>>/...or Qt. This is a Qt
>>>> issue, nothing to do with PyQt. I assume you just
>>>> need to make sure the directory containing the PostgreSQL DLL is on
>>>> PATH. />>//
>>>>
>>>>> Done, and now it works. Thank you!
>>>>>
>>>>
>>>>
>>>> Where did you find the missing dll for PostgreSQL ?
>>>> DependencyWalker indicates qsqlpsql.dll needs libpq.dll in order to
>>>> work.
>>>> So I downloaded PostgreSQL binaries from the official site, and got
>>>> libpq.dll.
>>>> But it doesn't work with PyQt5.7.1/Python3.5.2/Windows7-64bit, because
>>>> libpq.dll was compiled against Visual Studio 2013, and Python3.5.2 needs
>>>> Visual Studio 2015.
>>>>
>>>>
>>> It was exactly as Phil wrote: I put the ...\bin directory of my
>>> PostgreSQL installation (which contains libpq.dll) into my PATH and that
>>> helped: connecting to a PostgreSQL database now works. I didn't compile
>>> anything, not PyQt, not Python, not PostgreSQL. Possibly it would suffice
>>> to copy libpq.dll into a subdirectory of C:\Windows which is in the PATH
>>> anyway, but I don't know if that's a good idea. I know that early Firebird
>>> versions did copy a client dll into C:\Windows or C:\WINNT\system32.
>>>
>>> HTH
>>> Sibylle
>>>
>>>
>>>
>>> _______________________________________________
>>> PyQt mailing list    PyQt at riverbankcomputing.com
>>> https://www.riverbankcomputing.com/mailman/listinfo/pyqt
>>
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.riverbankcomputing.com/pipermail/pyqt/attachments/20170222/a4da8142/attachment.html>