headers
Carlo Curatolo | 5 May 2011 14:04
Picon

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-Provider-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
Permalink | Reply | 2 comments |
headers
Dave Page | 5 May 2011 14:07
Favicon
Gravatar

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
(Continue reading)

Permalink | Reply | 1 comment |
headers
Carlo Curatolo | 5 May 2011 14:58
Picon

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-Provider-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
Permalink | Reply | 0 comments |
headers
Jan-Peter Seifert | 5 May 2011 16:38
Picon
Picon

SQLDescribeCol – schema cache not being updated completely?

Hello,

we looked into a problem caused by some changes to a db’s schema via psqlODBC - e.g.:

Creating table:
SQLExecDirect(stmt, ‘CREATE TABLE tab1 (sp1 character varying(10));’, SQL_NTS)

Selecting from column:
SQLExecDirect(stmt, ‘SELECT sp1 from tab1’, SQL_NTS)

Getting column description:
SQLDescribeCol(stmt, 1, …) => 
ColumnName = "sp1", DataType = SQL_VARCHAR=12, ColumnSize = 10, DecimalDigits = 0, Nullable = SQL_NULLABLE=1

SQLCloseCursor(stmt);

Altering the column:
SQLExecDirect(stmt, ‘ALTER TABLE tab1 ALTER COLUMN sp1 TYPE char(25);’, SQL_NTS)
SQLExecDirect(stmt, ‘ALTER TABLE tab1 ALTER COLUMN sp1 SET NOT NULL;’, SQL_NTS)

Selecting from column again:
SQLExecDirect(stmt, ‘SELECT sp1 from tab1’, SQL_NTS)

Getting new column description:
SQLDescribeCol(stmt, 1, …)=>
ColumnName = "sp1", DataType = SQL_CHAR=1, ColumnSize = 10, DecimalDigits = 0, Nullable = SQL_NULLABLE=1

Obviously the Datatype information has been updated but ColumnSize und SQL_NULLABLE have been not.

It’s the same for  DecimalDigits/SQL_NUMERIC
(Continue reading)

Permalink | Reply | 2 comments |
headers
Hiroshi Saito | 9 May 2011 17:31
Picon

psqlODBC 09.00.0300 Released

We are pleased to announce the release of psqlODBC 09.00.0300. For
details of the changes in this release, please see the notes at:
http://psqlodbc.projects.postgresql.org/release.html

With this release two versions of the driver are provided for Windows;
'PostgreSQL ANSI' which supports single and multibyte applications
through the ANSI ODBC API, and 'PostgreSQL Unicode' which provides
Unicode support through the Unicode ODBC API. Microsoft's Distributed
Transaction Coordinator (MSDTC) is also supported.

On Unix systems, the driver type (ANSI or Unicode) may be selected
via a configure option. It can be compiled with unixODBC or iODBC.

A new 64 bit version of the driver is also available for Windows, and
includes native SSPI and GSSAPI support, and doesn't require libpq.

psqlODBC may be downloaded from
http://www.postgresql.org/ftp/odbc/versions/ in source, Windows
Installer, merge module, and basic zip file formats.

Please post any bug reports to the pgsql-odbc <at> postgresql.org mailing list.

I'd like to take this opportunity to thank all those involved with the
development, testing and bug fixing of the updated driver.

--
psqlODBC team.

--

-- 
Sent via pgsql-odbc mailing list (pgsql-odbc <at> postgresql.org)
(Continue reading)

Permalink | Reply | 0 comments |
headers
Silvio Brandani | 18 May 2011 10:51
Picon

Postgres Server Odbc driver compatibility matrix

Hi,

where can I found the compatibility matrix between Postgresql server and 
odbc drivers ??

we are going to upgrade our production databases to 9.0.2 and we get 
problems with new odbc drivers 9.0.x .
So we need to know if the "old" 8.3 or 8.4 drivers are still working 
from new postgres server version.

any comment higly appreciated.

-- 
Silvio Brandani

---

Utilizziamo i dati personali che la riguardano esclusivamente per nostre finalità amministrative e
contabili, anche quando li comunichiamo a terzi. Informazioni dettagliate, anche in ordine al Suo
diritto di accesso e agli altri Suoi diritti, sono riportate alla pagina http://www.savinodelbene.com/privacy.html
Se avete ricevuto questo messaggio per errore Vi preghiamo di ritornarlo al mittente eliminandolo
assieme agli eventuali allegati, ai sensi art. 616 codice penale http://www.savinodelbene.com/privacy/codice_penale_616.html
L'Azienda non si assume alcuna responsabilità giuridica qualora pervengano da questo indirizzo
messaggi estranei all'attività lavorativa o contrari a norme.
--

--

-- 
Sent via pgsql-odbc mailing list (pgsql-odbc <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
(Continue reading)

Permalink | Reply | 3 comments |
headers
Hiroshi Inoue | 18 May 2011 20:34
Picon

Re: Postgres Server Odbc driver compatibility matrix

Hi Silvio,

(2011/05/18 17:51), Silvio Brandani wrote:
> Hi,
>
> where can I found the compatibility matrix between Postgresql server and
> odbc drivers ??
>
> we are going to upgrade our production databases to 9.0.2 and we get
> problems with new odbc drivers 9.0.x .

What kind of problems are you seeing?

regards,
Hiroshi Inoue

> So we need to know if the "old" 8.3 or 8.4 drivers are still working
> from new postgres server version.
>
> any comment higly appreciated.

--

-- 
Sent via pgsql-odbc mailing list (pgsql-odbc <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
Permalink | Reply | 2 comments |
headers
Silvio Brandani | 19 May 2011 09:34
Picon

Re: Postgres Server Odbc driver compatibility matrix

Il 18/05/2011 20.34, Hiroshi Inoue ha scritto:
> Hi Silvio,
>
> (2011/05/18 17:51), Silvio Brandani wrote:
>> Hi,
>>
>> where can I found the compatibility matrix between Postgresql server and
>> odbc drivers ??
>>
>> we are going to upgrade our production databases to 9.0.2 and we get
>> problems with new odbc drivers 9.0.x .
>
> What kind of problems are you seeing?
>
> regards,
> Hiroshi Inoue
>
>> So we need to know if the "old" 8.3 or 8.4 drivers are still working
>> from new postgres server version.
>>
>> any comment higly appreciated.
>
>
We have problems using visual fox pro views to postgres through odbc 
driver 9.0.x but it works with driver 8.4.x

regards,

--

-- 
Silvio Brandani
(Continue reading)

Permalink | Reply | 1 comment |
headers
Hiroshi Inoue | 19 May 2011 11:07
Picon

Re: Postgres Server Odbc driver compatibility matrix

(2011/05/19 16:34), Silvio Brandani wrote:
> Il 18/05/2011 20.34, Hiroshi Inoue ha scritto:
>> Hi Silvio,
>>
>> (2011/05/18 17:51), Silvio Brandani wrote:
>>> Hi,
>>>
>>> where can I found the compatibility matrix between Postgresql server and
>>> odbc drivers ??
>>>
>>> we are going to upgrade our production databases to 9.0.2 and we get
>>> problems with new odbc drivers 9.0.x .
>>
>> What kind of problems are you seeing?
>>
>> regards,
>> Hiroshi Inoue
>>
>>> So we need to know if the "old" 8.3 or 8.4 drivers are still working
>>> from new postgres server version.
>>>
>>> any comment higly appreciated.
>>
>>
> We have problems using visual fox pro views to postgres through odbc
> driver 9.0.x but it works with driver 8.4.x

Unfortunately I don't have a fox pro environemnt.
Could you please tell me a concrete information?
(Continue reading)

Permalink | Reply | 0 comments |
headers
Hiroshi Inoue | 19 May 2011 23:51
Picon

Re: Postgres Server Odbc driver compatibility matrix

(2011/05/19 18:40), Silvio Brandani wrote:
> Il 19/05/2011 11.07, Hiroshi Inoue ha scritto:
>> (2011/05/19 16:34), Silvio Brandani wrote:
>>> Il 18/05/2011 20.34, Hiroshi Inoue ha scritto:
>>>> Hi Silvio,
>>>>
>>>> (2011/05/18 17:51), Silvio Brandani wrote:
>>>>> Hi,

<snip>

>>> We have problems using visual fox pro views to postgres through odbc
>>> driver 9.0.x but it works with driver 8.4.x
>>
>> Unfortunately I don't have a fox pro environemnt.
>> Could you please tell me a concrete information?
>>
>>> regards,
>>
> The problem is on foxpro remote view , we define a remote view on:
>
>
> SELECT * FROM gen_param Gen_param WHERE Gen_param.tipo_par = E'INVOICE'
> AND Gen_param.cod_par = E'DRAFT' AND Gen_param.azienda = E'60 '
>
> and we do not get any results ( no errors message no warning)
>
> with driver 8.4 we get the results.
>
> In attach the odbc logs
(Continue reading)

Permalink | Reply | 1 comment |

Gmane