PostgreSQL OLE DB Provider not visible in Excel 2010

PostgreSQL OLE DB Provider not visible in Excel 2010

am 05.05.2011 14:04:55 von Carlo Curatolo

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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: PostgreSQL OLE DB Provider not visible in Excel 2010

am 05.05.2011 14:07:14 von Dave Page

On Thu, May 5, 2011 at 1:04 PM, Carlo Curatolo 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: @pgsnake

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

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: PostgreSQL OLE DB Provider not visible in Excel 2010

am 05.05.2011 14:58:12 von Carlo Curatolo

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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc