Re: [Dhis2-users] psqlodbc driver on 64 bit windows 7 computer

2012-08-08 Thread Jason Pickering
Not always. It depends on whether you are connecting to the database from a 64 bit or 32 bit client. In this case, if Office is 32 bit, then the 32 bit drivers must be installed and configured. If you are using 64 bit apps (like 64 bit R for instance) you will use the 64 bit drivers, which can be

Re: [Dhis2-users] psqlodbc driver on 64 bit windows 7 computer

2012-08-08 Thread Knut Staring
Hi Randy, I think the driver is probably correct, but what is really confusing is that there are two ODBCAD32.exe files on Win 64. You should use this one: C:\Windows\SysWOW64\odbcad32.exe On Wed, Aug 8, 2012 at 4:03 PM, Wilson,Randy wrote: > I’ve just set up a new laptop and have not been ab

Re: [Dhis2-users] psqlodbc driver on 64 bit windows 7 computer

2012-08-08 Thread Jason Pickering
Hi Randy, To setup DSN for 32-bit application you must use: %WINDIR%\SysWOW64\odbcad32.exe and for 64-bit application you must use: %WINDIR%\System32\odbcad32.exe I suspect your office is 32 bit. Best regards, Jason On Wed, Aug 8, 2012 at 4:03 PM, Wilson,Randy wrote: > I’ve just set up a new

Re: [Dhis2-users] psqlodbc driver on 64 bit windows 7 computer

2012-08-08 Thread Saptarshi Purkayastha
Have you looked at the drivers from here: http://www.postgresql.org/ftp/odbc/versions/ postgres 8 ones have been 32-bit I think --- Regards, Saptarshi PURKAYASTHA My Tech Blog: http://sunnytalkstech.blogspot.com You Live by CHOICE, Not by CHANCE On 8 August 2012 16:03, Wilson,Randy wrote: >

[Dhis2-users] psqlodbc driver on 64 bit windows 7 computer

2012-08-08 Thread Wilson,Randy
I've just set up a new laptop and have not been able to find the correct psqlodbc driver to use with DHIS-2 running Postgres 8.4. The only drivers that install and show up in the ODBC drivers when I create a new data source are the x64 drivers. The other drivers seem to install correctly but d

Re: [Dhis2-users] Problem with DHIS Orgunit Hierarchy after upgrade to 2.9

2012-08-08 Thread Bob Jolliffe
This problem seems not to be related to the upgrade but some pre-existing problem with the database. On 8 August 2012 08:00, Wilson,Randy wrote: > We’ve just upgraded one of our test instances of DHIS-2 to version 2.9. > For some reason the orgunit hierarchy has been flattened – only the lowest

Re: [Dhis2-users] Problem with DHIS Orgunit Hierarchy after upgrade to 2.9

2012-08-08 Thread Knut Staring
Hi Randy, Not sure if this is the same issue, but I've also observed some caching issues after shifting to 2.9, but I'm not fully sure if it's the browser cache or application cache, as I have had to clear both and restart both in order to get the left hand side treewidget to show up correctly. S

[Dhis2-users] Problem with DHIS Orgunit Hierarchy after upgrade to 2.9

2012-08-08 Thread Wilson,Randy
We've just upgraded one of our test instances of DHIS-2 to version 2.9. For some reason the orgunit hierarchy has been flattened - only the lowest level is displayed and there are no parents (see screen shot below). I have rebuilt the resource tables and cleared the cache. The parent units ar