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

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

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


---






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

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?

> regards,

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

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,



>>> 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

Thanks.
It will take some time to fix the bug.

Anyway please try to turn on the *Server side prepare* option.

regards,
Hiroshi Inoue

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

Re: Postgres Server Odbc driver compatibility matrix

Il 19/05/2011 23.51, Hiroshi Inoue ha scritto:
> (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,
>
>
>
>>>> 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
>
> Thanks.
> It will take some time to fix the bug.
>
> Anyway please try to turn on the *Server side prepare* option.
>
> regards,
> Hiroshi Inoue
>
Turning on the " server side prepare ", it works .

thanks a lot.

Anyway, can we use the 8.4 driver with 9.x servers or is not compatible??

regards,


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