Обсуждение: PostgreSQL OLE DB Provider not visible in Excel 2010

Поиск
Список
Период
Сортировка

PostgreSQL OLE DB Provider not visible in Excel 2010

От
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-Provider-not-visible-in-Excel-2010-tp4372602p4372602.html
Sent from the PostgreSQL - odbc mailing list archive at Nabble.com.

Re: PostgreSQL OLE DB Provider not visible in Excel 2010

От
Dave Page
Дата:
On Thu, May 5, 2011 at 1:04 PM, Carlo Curatolo <genamiga@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: @pgsnake

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

Re: PostgreSQL OLE DB Provider not visible in Excel 2010

От
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-Provider-not-visible-in-Excel-2010-tp4372602p4372710.html
Sent from the PostgreSQL - odbc mailing list archive at Nabble.com.