Thread: Upgrade strangeness on win 32bit
I've just deployed the upgrade of the odbc driver in my organization, using as commandline (as suggested by batch file on .zip): msiexec /q /i "%SOFTWARE%\WPKG\psqlodbc-09_02_0100.msi" ALLUSERS=1 REINSTALLMODE=vamus REINSTALL=ALL REBOOT=ReallySuppress msiexec /q /i "%SOFTWARE%\WPKG\psqlodbc_x64-09_02_0100.msi" ALLUSERS=1 REINSTALLMODE=vamus REINSTALL=ALL REBOOT=ReallySuppress but found some inconsistencies: + on 'install and remove appication', both 32 and 64 bit installer report correctly the 09.02.0100 version + on ODBC DSN control panel, 64 bit (if applicable), report dll/driver version as 09.02.0100 + on ODBC DSN control panel, 32 bit (both on 32 and 64 bit), report ddl/driver version of the previous one (09.01.0200). I've tried to uninstall odbc driver 32bit and the reinstall it, and now i've got correct DLL version. I've to use different cmdline for different ''bitness''? Thanks. -- dott. Marco Gaiarin GNUPG Key ID: 240A3D66 Associazione ``La Nostra Famiglia'' http://www.sv.lnf.it/ Polo FVG - Via della Bontà, 7 - 33078 - San Vito al Tagliamento (PN) marco.gaiarin(at)lanostrafamiglia.it t +39-0434-842711 f +39-0434-842797 Dona il 5 PER MILLE a LA NOSTRA FAMIGLIA! http://www.lanostrafamiglia.it/chi_siamo/5xmille.php (cf 00307430132, categoria ONLUS oppure RICERCA SANITARIA)
I've forgot to say: > + on ODBC DSN control panel, 64 bit (if applicable), report dll/driver > version as 09.02.0100 and installer correctly ended with the code 'reboot needed' (3010). > + on ODBC DSN control panel, 32 bit (both on 32 and 64 bit), report > ddl/driver version of the previous one (09.01.0200). and installer ended with code 0, so no reboot needed. -- dott. Marco Gaiarin GNUPG Key ID: 240A3D66 Associazione ``La Nostra Famiglia'' http://www.sv.lnf.it/ Polo FVG - Via della Bontà, 7 - 33078 - San Vito al Tagliamento (PN) marco.gaiarin(at)lanostrafamiglia.it t +39-0434-842711 f +39-0434-842797 Dona il 5 PER MILLE a LA NOSTRA FAMIGLIA! http://www.lanostrafamiglia.it/chi_siamo/5xmille.php (cf 00307430132, categoria ONLUS oppure RICERCA SANITARIA)
No one reply. > I've to use different cmdline for different ''bitness''? Thanks. Having different cmdline for 32/64 bit can lead to mistakes, so.. i've no trouble at all at doing ''remove before upgrade'' also for 64 bit, what really confuse me is the .bat in the distribution tarball that insted suggest the 'vamus' upgrade schema. I need only a clarification. ;) -- dott. Marco Gaiarin GNUPG Key ID: 240A3D66 Associazione ``La Nostra Famiglia'' http://www.sv.lnf.it/ Polo FVG - Via della Bontà, 7 - 33078 - San Vito al Tagliamento (PN) marco.gaiarin(at)lanostrafamiglia.it t +39-0434-842711 f +39-0434-842797 Dona il 5 PER MILLE a LA NOSTRA FAMIGLIA! http://www.lanostrafamiglia.it/chi_siamo/5xmille.php (cf 00307430132, categoria ONLUS oppure RICERCA SANITARIA)
Hi Marco, (2013/06/10 18:48), Marco Gaiarin wrote: > > No one reply. > >> I've to use different cmdline for different ''bitness''? Thanks. > > Having different cmdline for 32/64 bit can lead to mistakes, so.. i've > no trouble at all at doing ''remove before upgrade'' also for 64 bit, > what really confuse me is the .bat in the distribution tarball that > insted suggest the 'vamus' upgrade schema. 9.2.0100 is a major upgrade. Maybe we should have disabled upgrade.bat. regards, Hiroshi Inoue
Mandi! Hiroshi Inoue In chel di` si favelave... > 9.2.0100 is a major upgrade. > Maybe we should have disabled upgrade.bat. Mmmh... ProductCode have not change for a while, even for that 'major' upgrade. On the past i've got trouble upgrading without REAINSTALL="vamus", but indeed i've not verified driver/ddl version, so probably was broken by some time. I've checked the driver version because on 64bit there's a reboot triggered, but it is month, even not years, that i upgrade odbc driver blindly... -- dott. Marco Gaiarin GNUPG Key ID: 240A3D66 Associazione ``La Nostra Famiglia'' http://www.sv.lnf.it/ Polo FVG - Via della Bontà, 7 - 33078 - San Vito al Tagliamento (PN) marco.gaiarin(at)lanostrafamiglia.it t +39-0434-842711 f +39-0434-842797 Dona il 5 PER MILLE a LA NOSTRA FAMIGLIA! http://www.lanostrafamiglia.it/chi_siamo/5xmille.php (cf 00307430132, categoria ONLUS oppure RICERCA SANITARIA)
Hi Marco, (2013/06/10 23:19), Marco Gaiarin wrote: > Mandi! Hiroshi Inoue > In chel di` si favelave... > >> 9.2.0100 is a major upgrade. >> Maybe we should have disabled upgrade.bat. > > Mmmh... ProductCode have not change for a while, even for that 'major' > upgrade. Oops sorry, I forgot to change the ProductCode. Is it better to change it even after the release? > On the past i've got trouble upgrading without REAINSTALL="vamus", but > indeed i've not verified driver/ddl version, so probably was broken by > some time. > I've checked the driver version because on 64bit there's a reboot > triggered, but it is month, even not years, that i upgrade odbc driver > blindly... The structure of 64bit psqlodbc driver package is different from the 32bit one. It doesn't contain libpq etc. Because the 32bit package changed the VC runtime merge module from VC90 to VC100, minor upgrade is essentially impossible. Because the 64bit package newly includes VC runtime merge module, minor upgrade is possible and seems to cause reboot in some case. regards, Hiroshi Inoue
Mandi! Hiroshi Inoue In chel di` si favelave... > Oops sorry, I forgot to change the ProductCode. > Is it better to change it even after the release? I'm not a programmer, and every software developer do with ProductCode what they want: oracle/sun have a base fixed UUID and change only some part, adobe keep ProductCode between major release for the reader, but change it at every release for flash. Bah. I hope there's a more knowledgable people on MSI format here... ;))) > The structure of 64bit psqlodbc driver package is different from the > 32bit one. Ok, it is perfectly clear now. Thanks. ;) -- dott. Marco Gaiarin GNUPG Key ID: 240A3D66 Associazione ``La Nostra Famiglia'' http://www.sv.lnf.it/ Polo FVG - Via della Bontà, 7 - 33078 - San Vito al Tagliamento (PN) marco.gaiarin(at)lanostrafamiglia.it t +39-0434-842711 f +39-0434-842797 Dona il 5 PER MILLE a LA NOSTRA FAMIGLIA! http://www.lanostrafamiglia.it/chi_siamo/5xmille.php (cf 00307430132, categoria ONLUS oppure RICERCA SANITARIA)
What we do with our installers (which I believe is correct) is to keep the ProductUpgradeCode constant between versions,while updating the ProductId to a new UUID with each release. - Dan ------------------------------------------------------------------------------------------- Dan Homerick daniel.homerick@2d3sensing.com Software Engineer Tel: 650-627-7624 2d3Sensing http://www.2d3sensing.com -----Original Message----- From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Marco Gaiarin Sent: Tuesday, June 11, 2013 6:39 AM To: pgsql-odbc@postgresql.org Subject: Re: [ODBC] Upgrade strangeness on win 32bit Mandi! Hiroshi Inoue In chel di` si favelave... > Oops sorry, I forgot to change the ProductCode. > Is it better to change it even after the release? I'm not a programmer, and every software developer do with ProductCode what they want: oracle/sun have a base fixed UUIDand change only some part, adobe keep ProductCode between major release for the reader, but change it at every releasefor flash. Bah. I hope there's a more knowledgable people on MSI format here... ;))) > The structure of 64bit psqlodbc driver package is different from the > 32bit one. Ok, it is perfectly clear now. Thanks. ;) -- dott. Marco Gaiarin GNUPG Key ID: 240A3D66 Associazione ``La Nostra Famiglia'' http://www.sv.lnf.it/ Polo FVG - Via della Bontà, 7 - 33078 - San Vito al Tagliamento (PN) marco.gaiarin(at)lanostrafamiglia.it t +39-0434-842711 f +39-0434-842797 Dona il 5 PER MILLE a LA NOSTRA FAMIGLIA! http://www.lanostrafamiglia.it/chi_siamo/5xmille.php (cf 00307430132, categoria ONLUS oppure RICERCA SANITARIA) -- Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-odbc