dhis2-users team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

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 configured through the respective ODBC control
panels. Both 32 bit and 64 bit connections will show up however in
both of the ODBC control panels, so it gets a bit confusing. :-/


Regards,
Jason


On Wed, Aug 8, 2012 at 4:09 PM, Knut Staring <knutst@xxxxxxxxx> wrote:
> 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 <rwilson@xxxxxxx> wrote:
>> 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 do not appear in the list.  When I use the 64 bit driver I
>> can’t connect with Microsoft Excel or Access 2010 – they give a message
>> saying that the architecture is different.
>>
>>
>>
>> Has anyone found a driver that will work?
>>
>>
>>
>> Randy Wilson
>>
>> HMIS Advisor
>>
>> MOH Rwanda
>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> +4791880522
> http://dhis2.org
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp