PostgreSQL OLE DB Provider not visible in Excel 2010

Installed softwares

PostgreSQL 9.04 32bits
Windows 7 Pro 64bits
PostgreSQL OLE DB Provider 1.0.0.20 installed from Stack Builder
Excel 2010 64bits


The PostgreSQL OLE DB Provider is not visible in Excel 2010.

I tried to copy and register PGOLEDB.DLL and LIBPQ.DLL in
C:\Windows\System32 and in C:\Windows\SysWOW64.

Anybody has an idea ?

--
View this message in context: http://postgresql.1045698.n5.nabble.com/PostgreSQL-OLE-DB-Pr ovider-not-visible-in-Excel-2010-tp4372602p4372602.html
Sent from the PostgreSQL - odbc mailing list archive at Nabble.com.

--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
Carlo Curatolo [ Do, 05 Mai 2011 14:04 ] [ ID #2059128 ]

Re: PostgreSQL OLE DB Provider not visible in Excel 2010

On Thu, May 5, 2011 at 1:04 PM, Carlo Curatolo <genamiga [at] brutele.be> wrote:
> Installed softwares
>
> PostgreSQL 9.04 32bits
> Windows 7 Pro 64bits
> PostgreSQL OLE DB Provider 1.0.0.20 installed from Stack Builder
> Excel 2010 64bits
>
>
> The PostgreSQL OLE DB Provider is not visible in Excel 2010.
>
> I tried to copy and register PGOLEDB.DLL and LIBPQ.DLL in
> C:\Windows\System32 and in C:\Windows\SysWOW64.
>
> Anybody has an idea ?

A 32 bit driver isn't going to work with a 64 bit version of Excel.


--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: [at] pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
Dave Page [ Do, 05 Mai 2011 14:07 ] [ ID #2059129 ]

Re: PostgreSQL OLE DB Provider not visible in Excel 2010

Indeed...

I have uninstalled 64bits Excel and installed 32bits version ans everything
works.

Thanks a lot Dave.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/PostgreSQL-OLE-DB-Pr ovider-not-visible-in-Excel-2010-tp4372602p4372710.html
Sent from the PostgreSQL - odbc mailing list archive at Nabble.com.

--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
Carlo Curatolo [ Do, 05 Mai 2011 14:58 ] [ ID #2059130 ]
Datenbanken » gmane.comp.db.postgresql.odbc » PostgreSQL OLE DB Provider not visible in Excel 2010

Vorheriges Thema: psqlODBC 09.00.0300 Released
Nächstes Thema: problem with 09.0.0200