Thread: 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 quandoli 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 eventualiallegati, 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. --
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.
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 quandoli 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 eventualiallegati, 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. --
(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,
(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
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 quandoli 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 eventualiallegati, 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. --