Re: Postgres Server Odbc driver compatibility matrix
Hiroshi Inoue <inoue@tpf.co.jp>
From: Hiroshi Inoue <inoue@tpf.co.jp>
To: Silvio Brandani <silvio.brandani@tech.sdb.it>
Cc: pgsql-odbc@postgresql.org
Date: 2011-05-19T21:51:52Z
Lists: pgsql-bugs
(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