Skip site navigation (1) Skip section navigation (2)

Re: Postgres Server Odbc driver compatibility matrix

From: Silvio Brandani <silvio(dot)brandani(at)tech(dot)sdb(dot)it>
To: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Postgres Server Odbc driver compatibility matrix
Date: 2011-05-20 07:48:21
Message-ID: 4DD61CC5.5060800@tech.sdb.it (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-jdbcpgsql-odbc
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,
>
> <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
>
> 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.
--

In response to

pgsql-odbc by date

Next:From: Попов Михаил ЮрьевичDate: 2011-06-07 11:04:25
Subject: Client encoding win866.
Previous:From: Hiroshi InoueDate: 2011-05-19 21:51:52
Subject: Re: Postgres Server Odbc driver compatibility matrix

pgsql-bugs by date

Next:From: Koichi SuzukiDate: 2011-05-20 14:06:44
Subject: Invitation to connect on LinkedIn
Previous:From: Hiroshi InoueDate: 2011-05-19 21:51:52
Subject: Re: Postgres Server Odbc driver compatibility matrix

pgsql-jdbc by date

Next:From: Clemens EissererDate: 2011-05-21 14:08:10
Subject: How to diagnose application "hangs" in pg_receive?
Previous:From: Hiroshi InoueDate: 2011-05-19 21:51:52
Subject: Re: Postgres Server Odbc driver compatibility matrix

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group